mysql 5.7添加用户

******************************

mysql 5.7添加用户

******************************

1. 创建用户

mysql> create user hnltuser identified by 'Passw0rd';

密码策略问题：

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements mysql> set global validate_password_policy=0;

Query OK, 0 rows affected (0.00 sec)

2. 策略修改后再创建

mysql> create user hnltuser identified by 'Passw0rd';

Query OK, 0 rows affected (0.00 sec)

3. 赋远程访问权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'hnltuser'@'%' IDENTIFIED BY 'Passw0rd' WITH GRANT OPTION;

4. 刷新权限

mysql> FLUSH PRIVILEGES;

5. 重启mysql

mysql> quit

# /etc/init.d/mysqld restart

# mysql -uroot -p

Enter password: <输入新设的密码newpassword>