Problems logging into mysql

Martin Webster lists at
Sat Jul 10 16:09:48 UTC 2010

On Sat, 2010-07-10 at 10:19 -0500, Joe Burgess wrote:

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

When installing mysql-server you must have created a password. Use the

$ mysql -u root -p
Enter password:

Now follow previous steps to create a new user:

> > You can set-up other users as follows:
> > mysql> CREATE USER 'bob'@'localhost' IDENTIFIED BY 'password';


mysql> exit
$ mysql -u bob -p
Enter password:

As ever,

Martin Webster • Profile:
AOL: martinjwebster • Wordpress:
Jabber: martinwebster at • ICQ: 15893823

More information about the ubuntu-users mailing list