Jump to content

Archived

This topic is now archived and is closed to further replies.

weeie

root account problem or phpmyadmin problem?

Recommended Posts

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? :cry:

 

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.