MySQL Database learning experience (5)

Four. Install phpMyAdmin

The MySQL graphical interface manager phpMyAdmin is a set of Web management interfaces written in PHP3 for MySQL database systems. It can be easily graphical interface to the MySQL database in the fields, data additions, deletions and other actions, but also to do the database itself and add and remove management; phpMyAdmin can manage the entire MySQL server (requiring superuser) or manage a single database. In addition, you can also use this graphical interface to learn the SQL correct

Grammar, until mastered. That's until you've read the relevant parts of the MySQL manual. You can go to http://www.phpwizard.net/phpMyAdmin/to download the latest version.

First, the phpMyAdmin package is extracted to a directory.

1. Modify the document CONFIG.INC.PHP3.

Set the original setting:

§cfgservers[1][' host ' = '; MySQL hostname

§cfgservers[1][' port '] = '; MySQL Port-leave Blank Fordefault port

§cfgservers[1][' Adv_auth '] = false; Use advanced authentication?

§cfgservers[1][' stduser '] = '; MySQL Standard user (only needed with advanced auth)

§cfgservers[1][' stdpass '] = '; MySQL standard password (only needed with advanced auth)

§cfgservers[1][' user '] = '; MySQL user (only needed withbasic auth)

§cfgservers[1][' password '] = '; MySQL password (only needed with basic auth)

§cfgservers[1][' only_db '] = '; If set to a db-name, only this db is accessible

§cfgservers[1][' verbose '] = '; Verbose name for this host-leave blank to show the hostname

:

:

Require ("english.inc.php3");

Modified into:

§cfgservers[1][' host ' = ' hostname of MySQL server '; Fill in the host name of your MySQL server

§cfgservers[1][' port '] = '; Fill in the port with MySQL, do not fill in the default port to link

§cfgservers[1][' Adv_auth '] = true; If you change to true, you must be authenticated before entering phpMyAdmin.

§cfgservers[1][' stduser '] = ' root '; MySQL User's account number

§cfgservers[1][' stdpass ' = ' password '; MySQL User's password

§cfgservers[1][' user ' = ' root '; MySQL Admin account

§cfgservers[1][' password ' = ' password '; MySQL admin password

§cfgservers[1][' only_db '] = '; Specify the name of the managed repository, and you can manage the entire server without filling it out

§cfgservers[1][' verbose '] = '; Specify the name of MySQL, do not fill in the system itself using the hostname

:

:

Require ("chinese_gb.inc.php3"); Change the language into Chinese

Description

(1) Because of this management interface, you can manage multiple MySQL servers with an interface, so you can find in config.inc.php3

§CFGSERVERS[1] ...

§CFGSERVERS[1] ...

§CFGSERVERS[1] ...

：

§CFGSERVERS[2] ...

§CFGSERVERS[2] ...

§CFGSERVERS[2] ...

Where [1] represents the first MySQL server,[2] represents a second MySQL server, you want to manage more than three MySQL server, you can follow the same statement, increase [4] ... Down

(2) If your MySQL server is the same as HTTP server, then §cfgservers[1][' host ' = can be directly filled in localhost.

Finally, open the browser, enter your URL/phpmyadmin after you will see a Small Password verification window, enter your MySQL management account and password, you can successfully see the phpMyAdmin Management screen. By phpMyAdmin, you can graphically and conveniently manage all your databases.

Five. Summary

Through the above learning and operation, finally can operate the MySQL database freely, can also be familiar with the use of PHP or ASP call MySQL. Finally, I would like to pay special thanks to the development of MySQL and the free contribution of the talent and the Internet to provide MySQL use instructions of prawns.