* Tim Johnson <tim@stripped> [101118 11:05]:
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
> I have root access to the mysql command line.
> I need to grant access to user 'username' for all databases
> except for the mysql database for both onsite (cgi script) and
> remote access.
> What is the syntax?
here is what I did to solve this:
As root I issued from the mysql DB:
SHOW GRANTS FOR username@'%';
Then making note of the stored grant commands
GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'%' WITH GRANT
for which tables I need access for 'username'.
tim at johnsons-web.com or akwebsoft.com