On Cpanel Server, test database shows on all users phpMyAdmin. This create problem as some new users create their tables on this “test” database and some other users delete these tables. To correct this problem, just delete this default database
The query cache stores the text of a SELECT query together with the corresponding result that was sent to the client. If an identical query is received later, the server retrieves the results from the query cache rather than parsing
On a Cpanel/WHM server running RHEL, after rebooting MySQL stoped working for all sites hosted on the server. I tried restarting MySQL, but it won’t solved the problem. Sites still shows the error message Warning: mysql_pconnect(): Can’t connect to local
You can create MySQL database with create database DATABASE_NAME command. root@host [~]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 937316 to server version: 4.0.25-standard Type ‘help;’ or ‘h’ for help.
