Php My Admin

[CahitE]

I have 2 Problems with php My admin
1- On the chrome browser when i press webAdmin It does not open the window (I've checked it seems no limitation for plesk and the domain)
2- When i try to upload an sql file to the php my admin it returns :

#1044 - Access denied for user 'yyyy_xxxx'@'%' to database 'yyyyy_xxxx'
but i am able to upload over mysql administrator so there is no problem with the user rights i also tryed from my phpmyadmin console wihch is in settings part on the plesk. Also it successfully upload the sql file.

Where should be the error ?

 

[IgorG]

It seems that issue is caused by problem in restore if database already exists - user of this database looses permissions. Here is example from our test server before and after restore performed same way as on your server:

mysql> show grants for 'dbuser1'@'%';
+-------------------------------------------------------------------------------+
| Grants for dbuser1@% |
+-------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dbuser1'@'%' IDENTIFIED BY PASSWORD '64f6539969715ad7' |
| GRANT ALL PRIVILEGES ON `admin\_db`.* TO 'dbuser1'@'%' |
+-------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show grants for 'dbuser1'@'%';
+-------------------------------------------------------------------------------+
| Grants for dbuser1@% |
+-------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dbuser1'@'%' IDENTIFIED BY PASSWORD '64f6539969715ad7' |
+-------------------------------------------------------------------------------+
1 row in set (0.00 sec)

For fixing this issue you should correct permissions with adding PRIVILEGES with something like:

GRANT ALL PRIVILEGES ON `yyyyy_xxxx`.* TO 'yyyy_xxxx'@'%';

 

[CahitE]

but that problem occurs in all new database users how should i follow for a new db user always ? this is a shared hosting enviroment ?

 

[IgorG]

Did you checked in database that all new created db users haven't this ALL PRIVILEGES ?

 

[CahitE]

very strangely i am able to connect over the mysql administrator from a remote machine with the given user above , and the others too. But on the phpMyAdmin it returns this error. So i think user rights are correct