Shulou(Shulou.com)06/01 Report--

1. Introduction

PhpMyAdmin is a database management tool based on PHP and constructed on the host of the website in the way of Web-Base, which allows managers to use Web interface to manage MySQL database. Through this Web interface, it can become a better way to input complicated SQL syntax in a simple way, especially to deal with the import and export of a large amount of data. One of the bigger advantages is that phpMyAdmin runs on the web server like other PHP programs, but you can use the HTML pages generated by these programs anywhere, that is, to manage the MySQL database remotely, and to easily create, modify, and delete databases and tables. You can also use phpMyAdmin to establish a commonly used php syntax to facilitate the correctness of sql syntax needed when writing web pages.

PhpMyAdmin is a software tool written in PHP, which can control and operate MySQL database through web. Through phpMyAdmin, you can fully operate on the database, such as creating, copying, deleting data, and so on. If you use the right tools, the administration of the MySQL database will be quite simple. Applying the MySQL command-line approach requires a lot of knowledge of MySQL, as well as the SQL language. Not only that, if there is a large amount of access to the database, it will be quite difficult to read the data in the list.

At present, there are many GUI MySQL clients, the most outstanding of which is the Web-based phpMyAdmin tool. This is a PHP-based tool for MySQL database foreground.

The disadvantage of PhpMyAdmin is that it must be installed in the Web server, so without proper access, other users may compromise SQL data.

Official site: http://www.phpmyadmin.net/

Introduction to the version:

1 、 phpMyAdmin 4.6.0

Released 2016-03-22, see release notes for details.

Current version compatible with PHP 5.5 to 7.0 and MySQL 5.5.

2 、 phpMyAdmin 4.4.15.5

Released 2016-02-29, see release notes for details.

Older version compatible with PHP 5.3.7 to 7.0 and MySQL 5.5.Supported for security fixes only, until October 1, 2016.

3 、 phpMyAdmin 4.0.10.15

Released 2016-02-29, see release notes for details.

Older version compatible with PHP 5.2 and MySQL 5. Supported forsecurity fixes only, until April 1, 2017.

2. Installation

Download the phpmyadmin-4.6.1 version:

[root@web html] # wget https://files.phpmyadmin.net/phpMyAdmin/4.6.1/phpMyAdmin-4.6.1-all-languages.tar.gz

Decompress:

[root@webhtml] # tar xf phpMyAdmin-4.6.1-all-languages.tar.gz

Copy to the web page directory:

[root@web html] # cp-aphpMyAdmin-4.6.1-all-languages www/

For ease of management, make a soft connection:

[root@web html] # ls50x.html bbs blog phpMyAdmin-4.6.1-all-languages phpMyAdmin-4.6.1-all-languages.tar.gz www [root@web html] # cd www/ [root@webwww] # lsa data dede favicon.ico p_w_picpaths include index.php m member phpMyAdmin-4.6.1-all-languages plus robots.txt special tags.php templets uploads [root@webwww] # ln-s phpMyAdmin-4.6.1-all-languages/ phpmyadmin3, configuration:

Configure phpmyadmin:

[root@web www] # cd phpmyadmin/# provides a sample configuration file by default. We rename it to remove sample[ root @ web phpmyadmin] # cpconfig.sample.inc.php config.inc.php# before modifying the configuration file, we need to get a data number as the password [root@web phpmyadmin] # tr-d 'a-zA-Z0-9'.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.