Home >Database >phpMyAdmin >How to use phpmyadmin locally and access address?

How to use phpmyadmin locally and access address?

coldplay.xixi
coldplay.xixiOriginal
2020-07-21 09:44:147413browse

How to use phpmyadmin and access address locally: first install the latest version and extract it to the htdocs folder; then modify the relevant code and configure the [config.default.php] file; finally enter [ localhost/phpmyadmin] login information.

How to use phpmyadmin locally and access address?

How to use phpmyadmin locally and access address:

1, https://www.phpmyadmin.net/ Visit this page to download the latest version of the installation package.

2. Unzip the installation package and put it in the htdocs folder in APMSever.

3. Change

$cfg['blowfish_secret'] = '';

in phpMyAdmin/libraries/config.default.php to

$cfg['blowfish_secret'] = '123456'; (注:其中的’123456′为随意的字符)

In the phpMyAdmin directory, open config.sample.inc.php, Find line 18

$cfg['blowfish_secret'] = '';

and change it to

$cfg['blowfish_secret'] = '123456'; (注:其中的’123456′为随意的字符)

4. Configure the config.default.php file

(1) Open config.default.php and find

$cfg['PmaAbsoluteUri'] =""

Add the path where phpmyadmin is located,

such as:

$cfg['PmaAbsoluteUri'] ="http://218.241.157.76:3380/"

(2) Find

$cfg['Servers'][$i]['user'] = 'root';           
$cfg['Servers'][$i]['password'] = '';         
分别填上你mysql的用户和密码即可,这里为        
$cfg['Servers'][$i]['user'] = 'root';           
$cfg['Servers'][$i]['password'] = '123456';

(3) Change the root user and password.

5. After modifying the file, enter "localhost/phpmyadmin" in the browser. The login information is as follows:

Server: 127.0.0.1:3306

User Name: root

Password: Blank (do not fill in)

Related tutorial recommendations: phpmyadmin

The above is the detailed content of How to use phpmyadmin locally and access address?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn