从mysql网站下载mysql rpm安装包(包括server、client)
1、安装server
rpm -ivh MySQL-server-5.6.19-1.el6.x86_64.rpm
报如下错误
[root@iZ257d4pjcoZ ~]# rpm -ivh MySQL-server-5.6.19-1.el6.x86_64.rpm --nodeps
Preparing... ################################# [100%]
file /usr/share/mysql/charsets/README from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
file
/usr/share/mysql/czech/errmsg.sys from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
file
/usr/share/mysql/danish/errmsg.sys from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
file
/usr/share/mysql/dutch/errmsg.sys from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
file
/usr/share/mysql/english/errmsg.sys from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
file
/usr/share/mysql/estonian/errmsg.sys from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
file
/usr/share/mysql/french/errmsg.sys from install of
MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package
mariadb-libs-1:5.5.40-1.el7_0.x86_64
原因是与之前lib库冲突,解决方式删除老版本lib库(注意根据你的提示更改相应版本)
yum -y remove mariadb-libs-1:5.5.40-1.el7_0.x86_64*
再次执行 rpm -ivh MySQL-server-5.6.19-1.el6.x86_64.rpm 即可安装成功
2、启动mysql
启动
service mysql start
停止
service mysql stop
重启
service mysql restart
查看当前mysql状态
service mysql status
3、安装client
rpm -ivh MySQL-client-5.6.19-1.el6.x86_64.rpm
4、客户端登陆
mysql -uroot -p
5、mysql root密码恢复
停止mysql服务
service mysql stop
启动mysql时不启动授权表,跳过权限验证使用空密码登陆
mysqld_safe --skip-grant-tables &
登陆mysql
mysql -uroot -p
设置mysql的root用户密码为123456
update mysql.user set password=password("123456") where user="root";
强制mysql重新加载权限
flush privileges;
退出及重启mysql
exit
service mysql restart
登陆mysql
mysql -uroot -p123456
重设root密码
此时执行任何mysql命令会报如下错误 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
set password=password('123456');