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

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

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.

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.