mysql未开放ip连接权限: Access denied for user 'root'@'%' to database 'mytest'
mysql未开放ip连接权限: Access denied for user ‘root’@’%’ to database ‘mytest’
1 进入mysql: mysql -uroot -ptest (root为root账户名,test是登录密码)
2 给数据库设置ip访问权限: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'test' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'test' WITH GRANT OPTION;
3 刷新数据库: FLUSH PRIVILEGES;