常用命令
登陆数据库
登陆远程地址为xx端口为3307用户为root
mysql -u root -h xx -p -P 3307
修改密码
set password for root@localhost = password('123');
set password for root@localhost = password('123');
新建用户远程连接mysql数据库
grant all on *.* to admin@'%' identified by '123456' with grant option;
flush privileges;
支持root用户允许远程连接mysql数据库
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
查看系统用户
use mysql;
select user,host from user;
「真诚赞赏，手留余香」
Little Star Blog真诚赞赏，手留余香
使用微信扫描二维码完成支付
