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

This article is about how to install phpmyadmin on the server. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Using php and mysql development website, phpmyadmin is a very friendly mysql management tool, and free and open source, many virtual hosts in China have their own management tools, the configuration is very simple, and then configure phpmyadmin on the linux server to manage the MySQL database.

First of all, visit the home page of the phpmyadmin official website, the URL is: http://www.phpmyadmin.net/. After entering, there is a download button. Do not download it first, because it is the zip package of windows. Click the Download link in the navigation bar to enter the download interface. Download the latest version 4.5.5.1 here, and select the version shown in the figure to download:

Download it and upload it to the server, and then execute the following command to extract:

Tar-xvzf phpMyAdmin-4.5.5.1-all-languages.tar.gz

After decompressing, we put it in a directory that can be accessed by web, which can be easily managed later, such as / home/wwwroot.

Mv phpMyAdmin-4.5.5.1-all-languages / home/wwwroot/

Then execute cd / home/wwwroot/ and rename the phpmyadmin directory to try not to let others guess the entry, such as:

Mv phpMyAdmin-4.5.5.1-all-languages phpmyAdmina4689f

Then execute cd phpmyAdmina4689f to enter the installation directory. The latest version of phpmyadmin supports quick configuration without executing the installation script. There is an official Chinese document for quick installation: http://docs.phpmyadmin.net/zh_CN/latest/setup.html#quick-install.

At this point you can see that there is a configuration file in the directory: config.sample.inc.php

Make a copy of this document:

Cp config.sample.inc.php config.inc.php

Then perform the edit:

Vim config.inc.php

Find the $cfg ['blowfish_secret'] configuration item, which is empty by default. Here we can easily set a complex string for encryption:

Then the item $cfg ['Servers'] [$I] [' auth_type'] defaults to cookie, which means you have to log in every time, so we don't have to modify it, so it's more secure, and then $cfg ['Servers'] [$I] [' host'] = '127.0.0.1' It is recommended to set it to IP address, then there is no problem with mysql authorization either locally or remotely. The default localhost may have an error such as # 2002-Permission denied-The server is not responding. It is recommended to use IP address.

If you debug locally, set it to config, then fill in the user name and password here, and enter it automatically every time, so it is more convenient to debug.

In general, set the login authentication type and IP address above, save and exit, and then access the directory address of our phpmyadmin through web. For example, if you put it under www.xxxx.com, then we need to access: http://www.xxxx.com/phpmyAdmina4689f. Note that the Linux server is strictly case-sensitive. When you see the login interface, the phpmyadmin is configured.

Thank you for reading! On the server how to install phpmyadmin to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.