mysql5.6 rpm

卸载mariadb : rpm -e --nodeps mariadb-libs-5.5.40-1.el7_0.x86_64

wget http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/MySQL-5.6.12-2.linux_glibc2.5.x86_64.rpm-bundle.tar

tar -xvf MySQL-5.6.12-2.linux_glibc2.5.x86_64.rpm-bundle.tar

rm -rf MySQL-5.6.12-2.linux_glibc2.5.x86_64.rpm-bundle.tar

rpm -ivh MySQL-server-5.6.12-2.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-devel-5.6.12-2.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-embedded-5.6.12-2.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-shared-5.6.12-2.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-shared-compat-5.6.12-2.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-test-5.6.12-2.linux_glibc2.5.x86_64.rpm

rm -rf *.rpm

启动

service mysql start 

vi /root/.mysql_secret 查看随机码xxx

mysql -uroot -p 后输入随机码

SET PASSWORD=PASSWORD(''); 设置新密码

mv ../my.cnf /etc/my.cnf (cp /usr/share/mysql/my-default.cnf /etc/my.cnf)  

service mysql stop

rm /root/.mysql_secret

配置/etc/my.cnf文件

....

赋予任何主机访问数据的权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

修改生效

FLUSH PRIVILEGES 

转载于:https://my.oschina.net/u/1992157/blog/638172