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
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
participants (2)
-
Joseph Hobbs
-
Tom Kostiainen