Problems logging into mysql

Joe Burgess joemburgess at gmail.com
Sat Jul 10 15:19:41 UTC 2010


On Sat, Jul 10, 2010 at 09:52:00AM -0400, Bob wrote:
> 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
> > 
> 
> 
> -- 
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
Did you do it with the -p?  When you setup your mysql db did you set a
password of some sort?  If you did, the -p will prompt you for that
password and you should be able to login.
-- 
--Joe Burgess
CMU Information Systems '12
(703) 402-9206

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20100710/94965c7a/attachment.pgp>


More information about the ubuntu-users mailing list