phpMyAdmin

I just changed my mysql password using

Code:

mysqladmin -u root -pcurrent_password password new_password

and now I can't login to phpMyAdmin at all. I tried using the client username and password, and I tried "root" and the mysql admin password. I tried "root" and the old password. What am I doing wrong?

 

I can log on just fine as the system user. When I try as root, I get the error:

 

Have you tried to restart MySQL?

 

I restarted mysql and I restarted the machine. I can now log in as root using the new password, but I am supposed to be able to login using my client login information as well, right? I am still not able to do that.

Is there anywhere else I need to change the password? I did the following:

then, to change it on the line

in /home/admispconfig/ispconfig/lib/config.inc.php

Another thing I notice is when I click to logout of phpMyAdmin it asks me for a username and password again and won't accept anything I give it. I eventually just close the window.

 

Do you see any MySQL errors in the syslog?
Does your new password contain any special characters?

 

Where is the syslog?

There is one special character in the new password, but, like I said, I can log in as root, so I'm guessing that's not the problem.

 

I think I know where the problem might be. You set password to mysql root account and before access from localhost was without any password. I'd advice to configure root account permission in mysql that password from localhost is not required. All should come back to previous state after that.

I can't give you now more precise instruction how to do it, but using man pages I suppose it should take 2-5 min to reset mysql root account permission to state that password from localhost is not required providing you know current root mysql password.

 

Uh...so, how can I fix it?

 

Try this to set another password: http://www.howtoforge.com/reset-forgotten-mysql-root-password

 

I would advice:

man mysql
man mysqladmin .. or
http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html

dig a bit

 

Falko, I tried to follow that tutorial, but got an error on the first step:

Code:

nohup: ignoring input and redirecting stderr to stdout
mysqld_safe[21759]: A mysqld process already exists

 

Please stop MySQL first.

 

OK, now, I get the following:

Code:

nohup: ignoring inupt and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[5657]:started

It never gives me a mysql prompt though.

 

Have you tried to connect to MySQL?

Code:

mysql --user=root mysql

 

After stopping MySql and trying again, I get this:

Code:

Access denied for user 'root'@'localhost' (using password: NO)

 

Please make sure that MySQL has stopped (if there are MySQL instances that don't stop, you can use the kill command) before you try the tutorial.

 

When I try the tutorial I get the following:

Code:

# mysqld_safe --skip-grant-tables
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6959]: started

...and it just hangs there.

If I try

Code:

mysql --user=root mysql

I get the following:

Code:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

 

Help me out, please. This still isn't working.

Code:

mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)

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

mysql> update user set Password=PASSWORD('new-password');
ERROR 1046 (3D000): No database selected
mysql> mysql --user=root mysql
    -> update user set Password=PASSWORD('new-password');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql --user=root mysql