CodeIgniter 3 & PhpMyAdmin Hide Database

If you encountered within the CodeIgniter3 Backend MYSQL during create and import of database files,and not show in the sidebar of phpMyAdmin. and it show

#1007 - Can't create database '<YourDatabase>'; database exists

It happens that phpmyadmin has a feature to hide some DBs. To change that behaviour, you can navigate to : settings > features > general > Hide databases OR

Follow these instructions:

S1: Go to your PHPMyAdmin and look for the settings:

S2: After you click, go to the Features

S3: After you put in the Features, go now in the database

S4: In the database section, you can see here like this

Hide databases use for only the database want to hide for the organized and not move or delete accidentally the DATABASE. It improves to hide temporarily the database not totally use often (e.g. Status) to make the database in sidebar are listed on what most often use and need to inspect

⚠️📢

IF YOU WANT TO INSPECT AND CONFIGURE YOUR DATABASE HIDE, YOU NEED TO REMOVE FIRST THE DETECT OF HIDE DATABASE NAMES (e.g. UserDatabase (Your database)), You must remove the database to not detect your FILES and show it in the PHPMyAdmin Sidebar.

TO

Import SQL files in WAMP (ERROR, exceed on the files maximum upload: (WAMP LOCALHOST)

S1: Go to file explorer, and follow this directory:

C:\wamp64\bin\mysql\mysql9.1.0\bin

S2: After you have done in this, put your SQL files just copy and paste it in the directory.

S3: With that directory, Go to Terminal/CMD (Command Prompt) and put this command:

you can type here in the directory (if you don’t know how fast go cmd in your directory)

mysql -u root infosys < infosys.sql

After you command with this, just wait for the uploading (It will not show anything just blank and then, REFRESH YOUR PHPMYADMIN TO SEE THE CHANGES.