1.先进入linux连接数据库并输入密码:
2.进行授权:GRANT ALL PRIVILEGES ON *.* TO 'root'@
'%'
IDENTIFIED BY
'这里写自己数据库的密码'
WITH GRANT OPTION;
3.退出用navicat连接
1.先进入linux连接数据库并输入密码:
2.进行授权:GRANT ALL PRIVILEGES ON *.* TO 'root'@
'%'
IDENTIFIED BY
'这里写自己数据库的密码'
WITH GRANT OPTION;
3.退出用navicat连接