For GRANT ALL privileges to root user use the following syntax: GRANT ALL PRIVILEGES ON database_name.* TO 'root'@'localhost'; FLUSH ... ... <看更多>

You only have SELECT privilege on mysql.user and mysql.db . You need to have more than that. If you could be granted. GRANT UPDATE,INSERT ... ... <看更多>

... <看更多>

MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. Check the usecase of dynamic section of mysql ... ... <看更多>