mysql修改密码、创建用户、开放远程、关闭远程连接

创建密码：

MariaDB [(none)]> use mysql;

MariaDB [mysql]> UPDATE user SET password=password('newpassword') WHERE user='root';

MariaDB [mysql]> flush privileges;

MariaDB [mysql]> exit;

创建用户：

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

开放远程：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

flush privileges;

关闭远程：

delete from user where host='%';

flush privileges;

mysql5.7修改密码方法：

update mysql.user set authentication_string=password('新密码') where user='用户';

flush privileges;