A few 7.5.1 problems ...

[lvalics]

After some time, I observed some anomalies on PLESK 7.5.1.

I create a DB and after I wanna see in PLESK phpMyAdmin, I get:
SHOW DATABASES LIKE 'testdb'
MySQL said: Documentation
#1227 - Access denied. You need the SHOW DATABASES privilege for this operation

It was created with PLESK so is strange.
Only thing is that is MySQL 4.
If I delete and recreate, than will be ok :-(

An another sad thing is when I try to delete domain or create sometimes is stuck PLESK and nothing will happen and I cannot do anything until I not restart the server (or prbabbly some process need to be killed, but I cannot kill psaservmng ...

Any ideea?

 

[lvalics]

For first problem I find the solution, database name was wih _ underscore and even if PLESK accepted, not worked. So not use databas_like_this ...

 

[JLChafardet]

Adding this to:
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.inc.php

solves the issue.

$db_name = str_replace("_","\_", $db_name);

cd /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin
vi config.inc.php
/You can disable
Press I down the line that says
// You can disable a server config entry by setting host to ''.

and paste that line.

save and exit.

problem solved