linux下安装MySQL 5.6(RPM方式)

本文介绍通过 RPM 方式安装 MySQL 的详细步骤,包括安装文件下载、安装过程、初始化设置及配置等,并提供默认安装路径说明。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

通过rpm方式来安装Mysql,这是比较简单的一种安装方式,具体详见下文。

《MySQL权威指南(原书第2版)》清晰中文扫描版 PDF http://www.linuxidc.com/Linux/2014-03/98821.htm

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://www.linuxidc.com

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 设置自启动

 

转自http://www.linuxidc.com/Linux/2014-04/100535.htm

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值