GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION;
mysql -u root -p
# 本机 登陆
mysql -u root -h 192.168.217.82 -p
# 远程登陆
sudo service mysql restart
# 重启
sudo service mysql status
# 查看MySQL服务运行状态
mysql -u root -h 192.168.217.82 -p
Navicat Premium
idea
原文:https://www.cnblogs.com/javayanglei/p/13305281.html