Hide Other Account MySQL Databases

Last Updated: November 30, 1999

With the new current version of cpanel your server will also upgrade to PHPMYADMIN Version 2.6.0-pl1 . This version sometimes defaults to showing all databases on the server instead of just the ones for the specific cPanel account. This how-to will show you step-by-step how to fix this cPanel problem.

1. Login to your dedicated server via SSH.

2. Lets edit the mysql configuration file.
Type: pico -w /etc/my.cnf

3. Add this to the bottom of the file if it is not there already.
safe-show-database

4. Save the MySQL Configuration file
Press: CTRL-X Then Y then Enter

5. Restart MySQL with the following command.
Type: /scripts/restartsrv_mysql

This will solve your problem.