我在x上运行了一个远程MySQL服务器。还有一个叫做abc的数据库。我可以做以下工作use abcmysql -h x.x.x.x -uroot --database=abcERROR 1044编辑:ssh in the boxGRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
我试着在mysql上制作一个表格,但我总是收到。CONSOLE: [SEVERE] Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usingpassword: NO)mysql> SHOW GRANTS FOR 'root'@'localhost';
+--------------------------
.* -> IDENTIFIED BY 'root';
ERROR 1064 (42000): You have an errorin your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax我尝试在'root'上删除和添加IDENTIFIED BY 'roo
我意外地删除了我的MySQL根用户的一些特权,包括修改表的能力。是否可以通过某种方法将此用户恢复到其原始状态(具有所有权限)?UPDATE mysql.user SET Grant_priv = 'Y', Super_priv = 'Y' WHERE User = 'root';# MySQL returned an empty resul