LinuxSA Mailing list archives

  From: Andrew Galdes <AGaldes@elders.com.au>
  To  : Tim Aslat <tim@spyderweb.com.au>
        <linuxsa@linuxsa.org.au>
  Date: Thu, 9 Jan 2003 15:34:47 +1030

RE: MRBS

Tim,

> In the immortal words of Andrew Galdes <AGaldes@elders.com.au>...
> > 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 :(
> 
> You seem to have missed the host definition of the grant command
> try 
> GRANT RELOAD,PROCESS on *.* to admin@localhost
> or
> GRANT RELOAD,PROCESS on *.* to admin@'%'

Actually i have tried them both with little luck. :(
AG.

> 
> Cheers
> 
> Tim
> 
> -- 
> | The most exciting phrase to   | Tim Aslat <tim@spyderweb.com.au> |
> | hear in science, the one that | http://www.spyderweb.com.au      |
> | heralds new discoveries, is   | Spyderweb Consulting             |
> | not "Eureka!" (I found it!)   | P: 82270800    M: 0401088479     |
> | but "That's funny ..."        | Webmaster for                    |
> |          -- Isaac Asimov      | http://www.goodiesruleok.com     |
> | No, "Eureka" is Greek for     | The Ultimate Goody Fansite       |
> | "This bath is too hot!        | admin@goodiesruleok.com          |
> |           -- Dr Who           |                                  |
> 
> -- 
> 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
> 

-- 
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