Originally Said By: Jason Byrnes
you need to substitute your MySQL username for username@'localhost'.On my server, i use the 'root' user, with a password of '123'
so the SQL is:
GRANT SELECT ON dbname TO 'root'@'localhost' IDENTIFIED BY '123';
you also need to change dbname to the name of database to add the select privileges to. In my case the name of the database is 'ps3':
GRANT SELECT ON ps3 TO 'root'@'localhost' IDENTIFIED BY '123';
Hi Jason,
okay something isn't working here for me.
I get the following message returned
MySQL said: Documentation
#1142 - GRANT command denied to user 'databaseusername'@'localhost' for table 'nameofdatabase'
when using:
GRANT SELECT ON databasename TO 'databaseusername'@'localhost' IDENTIFIED BY 'userdatabasepassword';
I have tried root and its associated password. Do I need to start with a database as the install program looks like it doesn't create one until after this point? I have uploaded the store.sql and tried that also.
Isn't the install program designed to make things easier?
Jason, would appreciate any additional help you may be able to offer.
Thanks, Mark.
