* Tim Johnson <t...@johnsons-web.com> [101118 11:05]: > using > 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 issued GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'%' WITH GRANT OPTION for which tables I need access for 'username'.
-- Tim tim at johnsons-web.com or akwebsoft.com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
