List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 24 2003 3:40am
Subject:Re: problem establishing privileged user.
View as plain text  
At 23:34 -0400 5/23/03, Neben Kabon wrote:
>I am a newbie to using mysql. I have been reading Welling and Thomson's
>new book, "PHP and MySQL Web Development". 
>
>I am having difficulty logging in as a privileged user other than root
>on my YellowDog Linux 3.0 machine. (I have used the same method on my
>Redhat 7.3 machine with success.) I have been able to create a root user
>for mysql, however after I initiate the following to create privilages
>to a user "tony"..
>
>mysql> grant select, insert, update, delete, index, alter, create, drop
>     -> on books.*
>     -> to tony identified by '*password*'
>
>Then I quit mysql as root and try to log in mysql as tony, I get the
>following result:
>
>$ mysql -h localhost -u tony -p
>Enter password: *password*
>ERROR 1045: Access denied for user: 'tony@localhost' (Using password:
>YES)
>
>Are there other privileges that I need to check?  Any pointers would be
>appreciated.

Do you have rows in the mysql.user table that have blank User column
values?

>
>Tony K.


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
problem establishing privileged user.Neben Kabon24 May
  • Re: problem establishing privileged user.Paul DuBois24 May