HostOnNet Blog

Cpanel phpMyAdmin shows “test” database

Looking for Linux Server Admin or WordPress Expert? We can help.

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.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.