change password:

use mysql; update user set authentication_string=PASSWORD(“mynewpassword”) where User=’root’; flush privileges;

 

create user:

create user zhangsan identified by ‘zhangsan’;

 

grant privileges:

grant all privileges on zhangsanDb.* to zhangsan@'%' identified by 'zhangsan';
flush privileges;

连接远程数据库
mysql -u username -p -h ip -P 30005