LinuxSA Mailing list archives

  From: Andrew Galdes <AGaldes@elders.com.au>
  To  : David Lloyd <dlloyd@microbits.com.au>
  Date: Thu, 9 Jan 2003 15:20:02 +1030

RE: MRBS

David,

I have added uer admin to the database. 

"GRANT RELOAD,PROCESS ON *.* TO admin;"

However, i try to connect to it as admin and it gives the following:

[root@sqlserver web]# mysql -uadmin mrbs
ERROR 1044: Access denied for user: 'admin@localhost' to database 'mrbs'

Any ideas as to why this user is not permitted?
I really need a book on this :(

AG.

> 
> 
> Andrew,
> 
> > Will do... But how do i add a user to the database? Is that how it
> > works? The file permissions are ok.
> 
> http://www.mysql.com/doc/en/GRANT.html
> 
> GRANT ALL on database.tables TO user IDENTIFIED BY 'password';
> 
> ..database = database name
> ..tables = table name
>     You can use * for both of these
> ..user = appropriate name
> ..password = a password
> 
> Do this from:
> 
> # mysql -uroot -p mysql
> 
> YOU MUST flush the privileges or restart the MySQL server.
> 
> Try also:
> 
> man mysqladmin
> 
> ..I prefer to use the SQL statement.
> 
> 
> DSL
> 
> -- 
> Microbits Linux Technician
> 
> Ph: +61 8 8362 9220
> 

-- 
LinuxSA WWW: http://www.linuxsa.org.au/ IRC: #linuxsa on irc.openprojects.net
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject