Problems logging into mysql

[Martin Webster]

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