mysql 5.6.23 安装 删除

rpm -qa|grep -i mysql //查看是否安装


rpm -ev MySQL-server-5.6.23-1.el6.x86_64
rpm -ev MySQL-shared-5.6.23-1.el6.x86_64
rpm -ev MySQL-devel-5.6.23-1.el6.x86_64
rpm -ev MySQL-shared-compat-5.6.23-1.el6.x86_64
rpm -ev MySQL-client-5.6.23-1.el6.x86_64



rm -rf /usr/lib64/mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql/mysql



rpm -ivh --replacefiles MySQL-s*.rpm
rpm -ivh --replacefiles MySQL-d*.rpm
rpm -ivh --replacefiles MySQL-c*.rpm

chown -R mysql.mysql /mnt/install/mysql/data/mysql/

/usr/bin/mysql_install_db
service mysql start
cat /root/.mysql_secret 

[root@iZ25lzdfhm0Z mysql]# mysql -u root -p
Enter password:   //输入上面的密码
mysql>  SET PASSWORD = PASSWORD('1111');
Query OK, 0 rows affected (0.03 sec)




安全启动

方法一：
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit；