phpMyAdmin

Thanks, Till.

I will try this later today. Will I then need to change the ISPConfig password? If so, where do I do this?

Thanks.

 

Thanks, Till and Falko. It seemed to have worked, but I still have the same problem: I can't login to phpMyAdmin as anything other than root.

I set up a client, gave it a username and password in the Client Login tab and tried to use that username and login with phpMyAdmin with no luck.

 

Do you see any error messages when you restart MySQL?

 

No. It seems to be fine. Again, I can login fine as root.

 

Can you log in to MySQL with a username other than root on the command line?

 

Sorry, how do I do that?

 

Code:

mysql -u [I]<username>[/I] -p

Replace <username> with the MySQL username.

 

No luck. I get the following error:

Code:

ERROR 1045 (28000): Access denied for user 'clientusername'@'localhost' (using password: YES)

I was able to log into ISPConfig as a client without trouble.

 

The MySQL usernames are something like web1u1 and have nothing to do with the ISPConfig logins.

 

That would explain the whole mess. So is there a way for a client to log in to phpMyAdmin and adjust all of his databases or does it have to be done on an individual database basis?