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';
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'
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.