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

Editor to share with you how to configure the server phpmyadmin, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

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, then 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, 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, phpmyadmin is configured.

The above is all the contents of the article "how to configure phpmyadmin on the server". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.