Problems logging into mysql

[Bob]

Thank you!

I did do the test and got an error: ERROR 1045 (2800): Access denied for 
user "root"@"localhost" (using password: No)

Bob
----- Original Message ----- 
From: "Martin Webster" <lists at martinwebster.eu>
To: <ubuntu-users at lists.ubuntu.com>
Sent: Friday, July 09, 2010 7:16 PM
Subject: Re: Problems logging into mysql


> On Fri, 2010-07-09 at 18:16 -0400, Bob wrote:
>
>> I was trying to set up mysql and recieve this error.   I've tried to
>> change in module but have had not any luck.   Thanks!   Bob   DBI
>> connect failed : Access denied for user 'bob'@'localhost
>
> Check that you can connect to the test database:
> $ mysql -u root test
>
> You should connect without error. Next set-up users and permissions:
> $ mysql -u root
> mysql> UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 
> 'root';
> mysql> FLUSH PRIVILEGES;
>
> You can set-up other users as follows:
> mysql> CREATE USER 'bob'@'localhost' IDENTIFIED BY 'password';
> mysql> GRANT ALL PRIVILEGES ON *.* TO 'bob'@'localhost' WITH GRANT OPTION;
>
> Note: you are creating a superuser 'bob' that can only connect from 
> localhost.
>
> Next time you access MySQL use:
> $ mysql -u root -p
>
> -- 
> As ever,
> .\\artin
>
> Martin Webster • Profile: http://www.linkedin.com/in/martinwebster
> AOL: martinjwebster • Wordpress: http://martinwebster.info/
> Jabber: martinwebster at xmpp.org.uk • ICQ: 15893823
>
>
> -- 
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: 
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>