1. Generally, phpmyadmin downloaded from the Internet is a compressed package, and we release it to the htdocs directory, such as htdocs\phpmyadmin.
2. Open the phpmyadmin directory, whether there is a config.sample.inc.php file in this directory, if so, rename it to config.inc.php. (Depending on the version, there may be a direct config.inc.php file, then there is no need to change the name, or there may be no config.sample.inc.php or config.inc.php at all, then we go to phpmyadmin\ librariesdirectory and copy config.default.php to phpmyadmin directory and rename it to config.inc.php).
3. Open config.inc.php file (you can use WordPad) and find $cfg['blowfish_secret']=''; and $cfg['servers'][$i]['auth_type']='cookie'; If the value of $cfg['servers'][$i]['auth_type'] is a cookie as seen earlier, then we must write an arbitrary string of characters in the quotation marks of $cfg['blowfish_secret']='', which can be understood as an authentication code. For example, $cfg['blowfish_secret']='sunec'. Save and withdraw.
At this point, the installation and configuration work of phpmyadmin is over, enter the browser, enter the http://localhost/phpmyadmin/main.php in the address bar, (the path here is determined according to the directory name of the phpmyadmin you unzipped in htdocs before), if it goes well, the screen should appear on the page that allows you to enter the username and password, enter the username password (mysql username password), Then you will enter the main interface of phpmyadmin. As for how to use it~ it will not be expanded here for the time being, you can explore it yourself first~
How to install the tool:
1. First download phpmyadmin online, and then unzip it to the web directory that can be accessed (if it is a virtual space, you can unzip it and upload it to the web directory through ftp, etc.), of course, you can modify the name of the file after extraction.
2. Configure the config file
Open the config.default.php file under Libraries, find the following items in order, and follow the instructions to configure it:
a. Access URL
$cfg['pmaabsoluteuri'] = ''; Fill in the access URL of phpmyadmin here
b. MySQL host information
$cfg['servers'][$i]['host'] = 'localhost'; // mysql hostname or ip address
Fill in the IP address of the server where LocalHost or MySQL is located, and press the default localhost if MySQL and the phpMyAdmin are on the same server
$cfg['servers'][$i]['port'] = ''; // mysql port - leave blank for default port
mysql port, if it is the default 3306, just leave it empty
c. mysql username and password
$cfg['servers'][$i]['user'] = 'root'; mysql user accesses the mysql username used by phpmyadmin
fg['servers'][$i]['password'] = ''; mysql password (only needed) The password corresponding to the mysql username mentioned above
d. Authentication method
$cfg['servers'][$i]['auth_type'] = 'cookie';
There are four modes to choose from here, cookie, http, http, config
config method is to enter the access URL of phpmyadmin to enter directly, without entering the username and password, which is not safe and not recommended.
When this item is set to cookie, http or http, login phpmyadmin requires a data username and password for authentication, as follows:
php installation mode is Apache, which can use http and cookies;
PHP installation mode is CGI and cookies can be used
e. Setting of phrase password (blowfish_secret).
$cfg['blowfish_secret'] = '';
If the authentication method is set to a cookie, you need to set a phrase password, and it is up to you to decide what password you want, but you cannot leave it blank, otherwise you will be prompted with an error when logging in to phpmyadmin
Well, so far, you have successfully installed phpmyadmin, it's simple :), hurry up and log in to experience it.
disposition
3. Open the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory), edit it with WordPad (don't use notepad, this is utf8 encoding), and follow the instructions to configure it.
4. Find $cfg['pmaabsoluteuri']=''; Change it to the URL of phpmyadmin that you will upload to the space
For example: $cfg['pmaabsoluteuri'] = 'http: // website domain name/phpmyadmin/';
5. Find $cfg['servers'][$i]['host'] = 'localhost'; Usually use defaults, there are exceptions, and you can do without modification
6. Find $cfg['servers'][$i]['auth_type'] ='config'; debug config in your own machine; If you use cookies in space on the web. |
Posted on 2/3/2015 2:48:14 PM
|
|
|
