phpMyAdmin broke after deleting user

[Michael Leahy]

I'm totally new at using Plesk.
I delete two strange (to me) users and then phpMyAdmin began failing with this error:

Error
MySQL said:

#1045 - Access denied for user 'pma_C8NItFqqfHQq'@'localhost' (using password: YES)

How can I get phpMyAdmin back to working again?

 

[IgorG]

Try to add it to 'mysql' database back. For example:

mysql> select * from user where User like 'pma_%'\G
*************************** 1. row ***************************
Host: localhost
User: pma_oTapOx1V3Rzb
Password: 1fa254bb0edb935e
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
1 row in set (0.00 sec)

 

[Michael Leahy]

More questions

Thanks, Igor.

Unfortunately I don't know enough to understand your answer.

If I had phpMyAdmin running... then maybe I could get access to a SQL table.

The pma users were server users, if I remember correctly. Are they stored in a SQL table? What table?

 

[IgorG]

Just login to this 'mysql' database with

# mysql -uadmin -psetup mysql

mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
17 rows in set (0.00 sec)

If you are not familiar with SQL commands - contact support team for fixing this problem.