mysql 设置密码

用SET PASSWORD命令
首先登录MySQL。
格式:mysql> set password for 用户名@localhost = password('新密码');
例子:mysql> set password for root@localhost = password('123');

添加用户
1.允许本地访问的用户(127.0.0.1)

create user zhrt@localhost identified by '123456';  

2.允许外网IP访问的用户

create user 'zhrt'@'%' identified by '123456'; 

查看用户

select user,host from mysql.user;

用户分配权限
授予用户在本地服务器对该数据库的全部权限

grant all privileges on dbname.* to zhrt@localhost identified by '123456';

授予用户通过外网IP对于该数据库的全部权限

grant all privileges on dbname.* to 'zhrt'@'%' identified by '123456';