Problems logging into mysql

[Bob]

I think I got it.

Thank you!

Starting to get the hang of this.

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


> 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
> following:
>
> $ 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> FLUSH PRIVILEGES;
>
> Then...
>
> mysql> exit
> $ mysql -u bob -p
> Enter password:
>
> -- 
> 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
>