mysql root password

gabsik · 05-31-2006, 08:27 AM

I'm a begginner in mysql .I'm trying to password it and this is what i was doing:

Quote:

mysql> UPDATE user SET Password = password('p4ssw0rd')WHERE User = ('root');
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0

mysql> quit
Bye
root@mail:~# mysql -u root -p ga8r13l3
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
root@mail:~# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

What is the correct way ???
Thanks !!!!

billymayday · 05-31-2006, 08:36 AM

I don't think you want parentheses around root - ie

UPDATE user SET Password=PASSWORD('passwd') WHERE User='root';

ps gabsik - why are you and I always on the same threads?

gabsik · 05-31-2006, 08:49 AM

Mysql is not a networking issue ?
I don't understand your question ... thanks anyway !!!!

billymayday · 05-31-2006, 08:53 AM

I don't get your first line - what's networking got to do with it?

On the second point, I was refering to you port redirection issue, and I noticed we were both answering something else

gabsik · 05-31-2006, 09:18 AM

Missunderstandings do happen , pardon !
Mysql allows access with no password:

Quote:

root@mail:~# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 4.0.24_Debian-10sarge1-log

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

mysql> quit
Bye
root@mail:~# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

... denyes when i enter the one i previously succesfully set !

Quote:

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password=PASSWORD('password')WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0

gbell72 · 05-31-2006, 09:29 AM

From the reference manual the correct way to set your passwords are

Code:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');

If you forgot your password shutdown mysqld then run

Code:

mysqld_safe --skip-grant-tables &

You should now be able to login without a password. In the MySQL command line prompt type the following to update your passwords.

Code:

mysql> UPDATE user SET password=PASSWORD('newpass') WHERE user="root" AND hostname="localhost";
mysql> FLUSH PRIVILEGES;

You can also use the mysqladmin command mysqladmin -h hostname -u user password 'new password'

gabsik · 06-03-2006, 10:58 AM

Thanks !!!