Linux 5 下安装MySQL 5.6(RPM方式)

    MySQL在很多领域被广泛使用,尤其是很多互联网企业,诸如腾讯,阿里等等。本文主要介绍在Linux 5下通过rpm方式来安装Mysql,这是比较简单的一种安装方式,具体详见下文。

1、准备对应的安装文件 下载页面:http://dev.mysql.com/downloads/mysql/ 找到对应的版本及所需的文件进行下载,如果下载的为tar文件,请使用tar解压 本人在Oracle Edelivery 下载,所以为V44331-01.zip #安装环境 [root@linux1 Mysql_src]# cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel \r on an \m #源文件路径 [root@linux1 Mysql_src]# pwd /Mysql_src [root@linux1 Mysql_src]# unzip V44331-01.zip Archive:  V44331-01.zip  extracting: MySQL-embedded-advanced-5.6.17-1.rhel5.i386.rpm   extracting: MySQL-test-advanced-5.6.17-1.rhel5.i386.rpm   extracting: MySQL-shared-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL的共享库  extracting: MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm           # MySQL的库和头文件  extracting: MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL客户端程序  extracting: MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL服务端程序  extracting: MySQL-shared-compat-advanced-5.6.17-1.rhel5.i386.rpm   # RHEL兼容包  extracting: README.txt             

2、MySQL默认安装路径  Directory             Contents of Directory /usr/bin               Client programs and scripts /usr/sbin               The mysqld server /var/lib/mysql         Log files, databases /usr/share/info         Manual in Info format /usr/share/man         Unix manual pages /usr/include/mysql     Include (header) files /usr/lib/mysql         Libraries /usr/share/mysql       Miscellaneous support files, including error messages,                         character set files, sample configuration files, SQL for database installation /usr/share/sql-bench   Benchmarks

3、安装MySQL [root@linux1 Mysql_src]# rpm -ivh MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm Preparing...                ########################################### [100%]    1:MySQL-server-advanced  ########################################### [100%] 2014-04-15 17:26:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-15 17:26:59 6524 [Note] InnoDB: Using mutexes to ref count buffer pool pages                    ........................... 2014-04-15 17:27:06 6558 [Note] InnoDB: FTS optimize thread exiting. 2014-04-15 17:27:06 6558 [Note] InnoDB: Starting shutdown... 2014-04-15 17:27:08 6558 [Note] InnoDB: Shutdown completed; log sequence number 1625987

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER ! You will find that password in '/root/.mysql_secret'.

You must change that password on your first connect, no other statement but 'SET PASSWORD' will be accepted. See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

  /usr/bin/mysql_secure_installation

#  Author : Leshami #  Blog   : http://blog.csdn.net/leshami

which will also give you the option of removing the test database. This is strongly recommended for production servers.

                  ...........中间省略................ New default config file was created as /usr/my.cnf and will be used by default by the server when you start it. You may edit this file to change server settings

[root@linux1 Mysql_src]# rpm -ivh MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm Preparing...                ########################################### [100%]    1:MySQL-client-advanced  ########################################### [100%]

[root@linux1 Mysql_src]# rpm -ivh MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm Preparing...                ########################################### [100%]    1:MySQL-devel-advanced   ########################################### [100%]

4、初始化MySQL及密码 [root@linux1 Mysql_src]# service mysql start Starting MySQL..                                           [  OK  ] [root@linux1 Mysql_src]# more /root/.mysql_secret # The random password set for the root user at Tue Apr 15 17:27:05 2014 (local time): lyHfNb87EBXhJDe2

[root@linux1 Mysql_src]# mysql -u root -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.17-enterprise-commercial-advanced

mysql> set PASSWORD=PASSWORD('mysql'); Query OK, 0 rows affected (0.01 sec)

mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | test               | +--------------------+ 4 rows in set (0.03 sec)

5、允许远程登陆 mysql> use mysql; Database changed mysql> select host,user,password from user; +-------------------+------+-------------------------------------------+ | host              | user | password                                  | +-------------------+------+-------------------------------------------+ | localhost         | root | *E74858DB86EBA20BC33D0AECAE8A8108C56B17FA | | linux1.orasrv.com | root | *AE207AEF7D22B37183E435AAE64CECF7102A2DB2 | | 127.0.0.1         | root | *AE207AEF7D22B37183E435AAE64CECF7102A2DB2 | | ::1               | root | *AE207AEF7D22B37183E435AAE64CECF7102A2DB2 | +-------------------+------+-------------------------------------------+ 4 rows in set (0.02 sec)

mysql> update user set password=password('mysql') where user='root'; mysql> update user set host='%' where user='root' and host='localhost'; mysql> flush privileges; mysql> exit

6、配置开机自启动 [root@linux1 Mysql_src]# chkconfig --list mysql mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off 如果没有的话使用chkconfig mysql on 设置自启动

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏杨建荣的学习笔记

10g升级至11g exp的问题解决(23天)

昨天升级数据库,从10.2.0.5.0升级到11.2.0.2.0.按照预定的步骤很快就操作完了。升级完成后,开始跑一些应用和Job.有一个Job开始报错,Job...

51960
来自专栏程序员同行者

scrapy爬取伯乐在线文章

14850
来自专栏Java技术栈

mysql语句性能开销检测profiling详解

之前我介绍过msyql查询优化explain检查命令的使用,explain主要是检查sql语句的基本性能,sql是否优秀,但不能查看具体的涉及硬件资源的开销,今...

35960
来自专栏个人分享

SparkSQL相关语句总结

1.in 不支持子查询 eg. select * from src where key in(select key from test); 支持查询个...

19720
来自专栏杨建荣的学习笔记

一条sql语句“导致”的数据库宕机问题及分析 (38天)

最近测试环境需要做一些变更,把测试环境切分成两套环境,存储空间也需要压缩压缩和整理。 unix组的人已经开始做空间划分了,然后我们需要在此基础上重建一套环境。 ...

36940
来自专栏杨建荣的学习笔记

impdp异常中断导致的问题(r2第8天)

今天查看数据库的负载,发现cpu消耗异常的高。里面有不少dw的进程.但是查看impdp的进程却不存在。 查看datapump的进程情况,发现大量的job,但是状...

404110
来自专栏乐沙弥的世界

Oracle 联机重做日志文件(ONLINE LOG FILE)

--=========================================

14120
来自专栏数据和云

返璞归真:如何判断一个初始化参数是否来自默认设置

? 杨廷琨(yangtingkun) 云和恩墨 CTO 高级咨询顾问,Oracle ACE 总监,ITPUB Oracle 数据库管理版版主 Oracle初...

29370
来自专栏杨建荣的学习笔记

关于db link权限分配的苦旅(一) (r7笔记第42天)

昨天接到一个开发的需求,内容看起来非常简单。 申请数据库192.168.1.118:1522:TEST下用户APP_TE_FLOW_128赋予对表testore...

35260
来自专栏乐沙弥的世界

使用带dblink方式的datapump迁移Oracle 10g到11g

      对于从Oracle 10g下迁移数据库到Oracle 11g,除了使用RMAN方式之外,我们可以使用带dblink的datapump方式来实现基于逻...

8910

扫码关注云+社区

领取腾讯云代金券