HostOnNet Blog

Cpanel phpMyAdmin shows “test” database

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 with name “test”.

Before deleting the mysql database, just take a backup of it, so if some clients ask for data, you can restore the tables to users database.

# cd /root
# mysqldump test >test.sql

Now lets delete the Database, so it won’t show in phpMyAdmin

server20# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 129273 to server version: 4.1.10a

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.

mysql> drop database test;
Query OK, 80 rows affected (0.02 sec)

mysql> exit
Bye
server20#


Posted in Cpanel Server, Database. Bookmark the permalink.