Grant privilege with mysql.
March 11th, 2010GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv
) ON mysql.user TO 'pma'@'localhost';
and this is the error that it gives me..
SQL-query :
GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv
) ON mysql.userTO 'pma'@ 'localhost'
MySQL said:
#1064 - You have an error in your SQL syntax near ''pma'@ 'localhost'' at line 1 I have changed the user for security purposes but i still can't get the query to work. can some one plase help me!
#If you have any other info about this subject , Please add it free.# |
