安装使用 rpm 方式安装源wget http://repo.mysql.com//mysql57-community-release-el6-7.noarch.rpm
rpm -i mysql57-community-release-el6-7.noarch.rpm安装mysql mysqld\yum install mysql mysql-server跳过授权直接登录,这样可以直接修改密码
方法修改 my.confvim /etc/my.conf
# 添加一行
skip-grant-tables启动mysqlservice mysqld start
# 或者 service mysqld restart修改密码update mysql.user SET authentication_string=password (’sfew5@#@w5er2sdf’) where user=’root’;
flush privileges;
set password = PASSWORD('sfew5@#@w5er2sdf');
需要注意的是密码要复杂点,因为如果密码简单是不行的。
会提示这个 ,大概意思 密码不符合安全策略
Your password does not satisfy the current policy requirements
密码的安全策略set global validate_password_policy=0;
# 0 表示比较低的安装策略, 满足长度就可以
# 1 表示,满足长度、大小写、特殊符号
# 2 满足1并且 dictionary file
密码的长度set global validate_password_length=1;
查看mysql> show variables like 'validate_password%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password_dictionary_file | |
| validate_password_length | 4 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 1 |
+--------------------------------------+-------+
6 rows in set (0.00 sec)