首先要mysql授权
mysql>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql>FLUSH PRIVILEGES; //使命令生效
Query OK, 0 rows affected (0.00 sec)
mysql>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql>FLUSH PRIVILEGES; //使命令生效
Query OK, 0 rows affected (0.00 sec)
本文标题：Navicat连接服务器数据库
本文链接：https://www.haomeiwen.com/subject/wwsloctx.html
网友评论