Tom,

Have you tried logging into MySQL without the -p option? If there is no password set for root@localhost, then specifying a -p option will cause this to happen.

mysql -u root

This will log you in as root@localhost without asking for a password.

Once you get in, check out the MYSQL faqs on how to set up passwords and such for various users. Otherwise you will be wide open!

Joseph Hobbs
Compaq Web Services / GEAE Team
Backup Team Lead
Tier II/III Web Support
Joseph.Hobbs@ae.ge.com
hobbsj@somecrazyfool.com

-----Original Message-----
From: Tom Kostiainen [mailto:tom.kostiainen@pp.inet.fi]
Sent: Saturday, September 15, 2001 6:26 PM
To: suse-linux
Subject: [SLE] MySQL problem (Access denied?!)

Hi!

I've got MySQL runing and everything works fine when I use the client(?) as root.

But if I start the client with mysql -u root -p then I get the following error (smt like):

ERROR: Access denied for user 'root@localhost' (Using password: YES)

Cause of this loging in as root is the only way for me to use mysql.

I need to get the username+password log-in to work so that I can access my

database through PHP and as another user!

Should I do something with mysqladmin to get this to work?

Cheers!

- tk