Many newbies are confused about
In order to achieve the latter, you will need to set up the MySQL user properly so that he can only read/write to allowed databases. That's until you read the relevant section in the MySQL manual.
Quickly install phpMyAdmin
Unzip the phpMyAdmin software package to a directory.
Open config.inc.php3 and modify $cfgServers[1]["host"], $cfgServers[1]["user"] and $cfgServers[1]["password" according to your environment ] value. You can take a look at all the configurable variables listed in the configuration section below and modify other parameters as appropriate.
It is recommended that after installing phpMyAdmin, protect its directory (unless it is on an intranet). For example, you can use HTTP-AUTH (with a .htaccess file).
Open the file in the browser: installation host domain name/installation directory/index.php3. phpMyAdmin should display a welcome screen and your database.
phpMyAdmin supports multiple languages. If you want to change to the Chinese version, modify require("english.inc.php3"); in config.inc.php3 to require("chinese_gb.inc.php3"). This way the interface will be in Chinese. How great!
Save config.inc.php3.
Note when installing phpMyAdmin
Please make sure the phpMyAdmin directory is protected. The default is no protection! It should not be read by random people, especially search engines.
Although I have added a "nofollow" directive to each page, some search engines may not consider the link and still continue to visit the page.
Imagine what would happen if AltaVista visited a link called "Drop Dtabase". You can have a comprehensive understanding of Apache's authentication methods at http://www.apacheweek.com/features/userauth. Another tutorial at http://deepthought.texsci.edu/protected_dirs.html
PHP3 should be configured with magic_quotes=on.