Granting access rights to a user
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? -- 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
Re: Granting access rights to a user
* 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
Re: Granting access rights to a user
* Tim Johnson t...@johnsons-web.com [101118 12:58]: * 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'. michael dykman points out (OTL) that it is not a good idea to give a user a grant option The syntax for removing the grant option is: REVOKE GRANT OPTION ON databasename.* FROM 'username'@'%'; at least that is what I deduce from docs and `show grants for user;' displays user privileges without the grant option. :) I'm cleaning up after someone else. cheers -- 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