Install and use phpMyAdmin to manage MySQL databases

Learn to use phpMyAdmin, a Web-based database management tool. If appropriate tools are used, MySQL database management will be quite simple. To use the MySQL command line method, you must be familiar with MySQL knowledge and use the same SQL language. In addition, if the database has a large access volume, it will be quite difficult to read the data in the list. Many install GUIM phpmyadminmysql

Learn to use phpMyAdmin, a Web-based database management tool.

If appropriate tools are used, MySQL database management will be quite simple. To use the MySQL command line method, you must be familiar with MySQL knowledge and use the same SQL language. In addition, if the database has a large access volume, it will be quite difficult to read the data in the list.

There are currently many GUI MySQL client programs, the most outstanding of which is the Web-based phpMyAdmin tool. This is a PHP-based MySQL database front-end tool. The disadvantage of PhpMyAdmin is that it must be installed on your Web server. Therefore, if you do not have proper access permissions, other users may damage your SQL data.

The installation process of PhpMyAdmin is very simple. Download phpmyadminfrom http://www.phpmyadmin.net/and the latest version is 2.6.4-pl3. Decompress the downloaded file to the path you selected, such as/srv/www/domain.com/html/admin. Before you connect phpMyAdmin to the database, make sure that phpMyAdmin is protected. you can create an. htaccess file to complete the operation:



AuthUserFile /srv/www/domain.com/.htpasswd

AuthGroupFile /dev/null

AuthName adminAuthType basic



Order Deny,Allow

Deny From All

Allow From localhost

require user admin

satisfy any





The above code snippet makes it possible that the path/srv/www/domain.com is not protected, so the. htaccess file is outside the Web path (for example, the DocumentRoot in Apache is/srv/www/domain.com/html ). Use the htpasswd tool to create the/srv/www/domain.com/.htpasswdfile: create the/srv/www/domain.com/.htpasswd file using the htpasswd tool:



# htpasswd -cm /srv/www/domain.com/.htpasswd admin



Once you have provided the administrator password, you can edit the config. inc. php file containing phpMyAdmin. You can edit the $ cfg ['pmabsoluteuri'] keyword to point to the position of phpMyAdmin installed on the server, and then edit the $ cfg ['servers'] array. To quickly create and run databases and edit all the databases on the server, you must provide the following proof of permission:



$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';$cfg['Servers'][$i]['password'] = 'mysecretrootpass';



Now you can go to the ingress.