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.