Redhat6下安装MySQL Server

1. 去官网下载MySql，核心有三个，以5.6.13 64位为例：

MySQL-client-5.6.13-1.el6.x86_64.rpm
MySQL-devel-5.6.13-1.el6.x86_64.rpm
MySQL-server-5.6.13-1.el6.x86_64.rpm

2. 安装：

[root@localhost download]# rpm -ivh --replacefiles MySQL-server-5.6.13-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%] 

 
[root@localhost download]# rpm -ivh --replacefiles MySQL-client-5.6.13-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%] 

 
[root@localhost download]# rpm -ivh --replacefiles MySQL-devel-5.6.13-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]

要移除安装可以使用 rpm -e MySQL-server 、 rpm -e MySQL-devel、MySQL-client即可；

3. 初始化数据库

/usr/bin/mysql_install_db

4. 启动mysql服务

service mysql start

使用命令ps -ef | grep mysql 查看mysql进程：


[root@localhost ~]# ps -ef | grep mysql
root 26047 1 0 18:14 pts/12 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid
mysql 26227 26047 0 18:14 pts/12 00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock
root 26545 24726 0 18:27 pts/8 00:00:00 grep mysql

5. 登陆mysql并修改初始密码

首先查看 cat /root/.mysql_secret

root@localhost ~]# cat /root/.mysql_secret
# The random password set for the root user at Fri Aug 30 15:57:18 2013 (local time): fMYcarvB

然后命令行：mysql -u root -p ，然后输入上面的密码进入mysql

设定新密码如下：

>mysql set password=password('root');

退出mysql后即可使用新密码

6. 配置root远程登陆

mysql> use mysql;

mysql> grant all privileges on *.* to 'root'@'%' with grant option;

mysql> flush privileges;

7. 重启即可

service mysql restart;