#1165 About User Name for MySQL Grants

[Peng-Fei Zheng]

I used squirrelsql-3.5.3-optional.zip and squirrel-sql-3.6-standard.jar, when I click the "MySQL USERS", the log is:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: There is no such grant defined for user 'root@localhost' on host '%'

I think the user name is wrong, the correct is root@localhost, like this SQL result as follow:
SELECT CONCAT('SHOW GRANTS FOR ', '`', user, '`', '@', '`', host, '`\;') AS 'MySQL Grants' FROM mysql.user;

[Peng-Fei Zheng]

correct user name is 'root'@'localhost'