Jesse Marlin writes:
Anders Johansson writes:
On Friday 10 May 2002 23.00, Jesse Marlin wrote:
I am new to mysql and am having some problems. Whenever I start up the server with /etc/rc.d/mysql start it starts up great. I have been able to run a few tests that show some of the server's internal variables etc, so I am able to communicate with it. Whenever I try to change the root password I get this:
root@maniac:/var/lib/mysql > mysqladmin -u root -p password Enter password:
What do you enter here? The default root password is blank, so just press enter. And to set the password you're supposed to give it as a parameter. This is from the startup message you get when you start the server.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password'
Okay I tried with a password:
mysqladmin -u root -p password 'something' Enter password:
At the 'Enter password:' I just reentered it. This is kinda confusing behavior. Now when I run mysql:
mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
What does this 'Using password: NO' mean. It used to be set to YES. Thanks.
Never mind.
mysql -p Enter password:
Works. Thanks for the help.