: When I am root, "mysql" connects without a password, even though I've set one When I am root, "mysql" connects without a password, even though I've set one: # mysqladmin -u root password 'whatever'

@Steve110

Posted in: #Mysql #Password

When I am root, "mysql" connects without a password, even though I've set one:

# mysqladmin -u root password 'whatever'
# mysql -u root -p
Enter password: (typing the 'whatever' above)
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 4.1.22-standard

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> Bye


but unfortunately this also happens...

# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 25 to server version: 4.1.22-standard

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql>


So even though I've set the password, and it IS checked when I use "-p",
it is however not necessary!?!?

Vote Up Vote Down

Login to post a comment!