root account problem or phpmyadmin problem?

[weeie]

Well you either have a mysql password for the root account or you don\'t. If you don\'t you need to set one, which is what the phpmyadmin message is warning you about.

 

Once you login to mysqladmin you should use the mysql database. Then issue this query to change your root password (in the phpmyadmin sql window):

 

UPDATE user SET Password=PASSWORD(\'somenewpw\') WHERE user=\'root\'

 

Once that query completes, issue this command:

 

FLUSH PRIVILEGES;

 

i\'ve just installed mysql and followed your instructions to change the root password as shown above. After i changed the password, i can\'t seem to be able to login to phpmyadmin after a refresh(F5) with the error:

 

\"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

 

Error

 

MySQL said:

 

 

#1045 - Access denied for user: \'root\'@\'localhost\' (Using password: NO)\"

 

 

the server is up running and i am able to login to mysql query through the windows command prompt by C:mysqlbin>mysql -u root -p , and then the new password.

 

So i tried to change these settings in config.inc as shown below:

$cfg[\'Servers\'][$i][\'auth_type\'] = \'config\';

$cfg[\'Servers\'][$i][\'user\'] = \'root\';

$cfg[\'Servers\'][$i][\'password\'] = \'newpasswordhere\';

 

 

And then i got a different error as shown below:

\"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

 

Error

 

MySQL said:

 

 

#1250 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

[Documentation]\"

 

 

The only problem is that i can\'t login to phpmyadmin. Can you or someone help please?

 

My computer:

OS windows 2000

MySQL 4.1.1alpha-nt

Apache 2.0.48

PHP 4.31

 

My sql.user:

+-----------+------+-------------------------------------------+--------

---------+---------------+--------------+-----------+------------+------

-----------+------------------+--------------+-----------------+--------

-+-------------+-----------------+

| localhost | root | *38BD01F782C3A573921C98F969FAE38DD3780B8E | Y

| Y | Y | Y | Y | Y

| Y | Y | Y | Y

| 0 | 0 |

| % | root | *38BD01F782C3A573921C98F969FAE38DD3780B8E | Y

| Y | Y | Y | Y | Y

| Y | Y | Y | Y

| 0 | 0 |

| localhost | | | N

| N | N | N | N | N

| N | N | N | N

| 0 | 0 |

| % | | | N

| N | N | N | N | N

| N | N | N | N

| 0 | 0 |

+-----------+------+-------------------------------------------+--------

---------+---------------+--------------+-----------+------------+------

-----------+------------------+--------------+-----------------+--------

-+-------------+-----------------+

 

 

 

I would appreciate it a lot if someone could help me with this.

[weeie]

i\'ve solved my problem!

 

The problem lies with connecting to 4.1 mysql server with 4.0 mysql client.

 

More info:

http://www.mysql.com/doc/en/Password_hashing.html

 

Thanks to the pple from efnet