Step1: 检测系统是否自带安装mysql
#yum list installed | grep mysql
Step2: 删除系统自带的mysql及其依赖 命令:
# yum -y remove mysql-libs.x86_64
Step3: 给CentOS添加rpm源,并且选择较新的源 命令:
#wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
#yum localinstall mysql-community-release-el6-5.noarch.rpm
# yum repolist all | grep mysql
# yum-config-manager --disable mysql55-community
# yum-config-manager --disable mysql56-community
# yum-config-manager --enable mysql57-community-dmr
# yum repolist enabled | grep mysql
Step4:安装mysql 服务器 命令:
# yum install mysql-community-server
Step5: 启动mysql 命令:
#service mysqld start
Step6: 查看mysql是否自启动,并且设置开启自启动 命令:
# chkconfig --list | grep mysqld
# chkconfig mysqld on
Step7: 修改密码
首先关闭mysqld服务
#service mysqld stop
以不启用grant-tables模式启动mysql
#mysqld_safe --skip-grant-tables &
修改密码:
update mysql.user set authentication_string=password('123qwe') where user='root' ;
然后,刷新权限
flush privileges;
退出
quit;
修改完毕。重启mysql;
此时MySQL还不能完全使用,还需要进行授权,设置密码
alter user 'root'@'localhost' identified by '123';
此时如果直接进入MySQL,会出现以下错误:
ERROR 1819 (HY000): Your password does not
satisfy the current policy requirements
这说明,我们打开mysql的方式不对
下面,关闭mysql
service mysqld stop
然后,以正确的方式打开mysql
service mysqld start --validate-password=off
再执行alter user的语句就可以了。
alter user 'root'@'localhost' identified by '123';
set password = password(123)
蓝后就可以愉快的使用了。