List:General Discussion« Previous MessageNext Message »
From:Tim Johnson Date:November 18 2010 9:46pm
Subject:Re: Granting access rights to a user
View as plain text  
* Tim Johnson <tim@stripped> [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
Thread
Granting access rights to a userTim Johnson18 Nov
  • Re: Granting access rights to a userTim Johnson18 Nov
    • Re: Granting access rights to a userTim Johnson19 Nov