mysql RPM包安装

mysql RPM包安装

1.------先卸载
rpm -qa | grep mysql
mysql-libs-5.1.61-4.el6.x86_64

rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps

2.-----再安装----
注意，因为包之间有彼此依赖，所以安装有顺序要求，

rpm -ivh MySQL-server-5.6.31-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-devel-5.6.31-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-client-5.6.31-1.linux_glibc2.5.x86_64.rpm

3. 初始化数据库，启动和配置
安装完成，需要初始化数据库，

mysql_install_db

复制配置文件，

cp /usr/share/mysql/my-default.cnf /etc/my.cnf

启动MySQL服务，

service mysql start

设置开机启动，

chkconfig mysql on

检索设置生效，

chkconfig --list | grep mysql
mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off

 

4. 重置密码

上面初始化操作，记录了root账户的临时密码，存储于文件/root/.mysql_secret中，

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.

 

/root/.mysql_secret文件，

# The random password set for the root user at Mon Aug 28 09:40:09 2017 (local time): pcqEmPanlf3emxWW