phpmyadmin3 installation and configuration graphic tutorial_PHP tutorial

In PHP website development, the most basic PHP environment construction involves PHP, Apache/IIS, and Mysql. For database management, in addition to the command line tool provided by the Mysql database itself to facilitate developers to manage the database, phpmyadmin developed based on PHP is also a very An easy-to-use Mysql database management program, phpmyadmin is also a necessary PHP program in PHP environment configuration and installation programs such as xampp. Today I would like to share with you how to install and configure phpmyadmin.

phpmyadmin installation and configuration preparations

First of all, of course, download the phpmyadmin installation package, providing two phpmyadmin download addresses: phpmyadmin download address 1, phpmyadmin download address 2, Address 1 lists phpmyadmin2.x and phpmyadmin3.x, address 2 is only the latest phpmyadmin version.

I downloaded phpmyadmin3.3. When installing phpmyadmin3, the PHP environment required is at least PHP5.2 and Mysql5 or above. How to configure PHP environment?

phpmyadmin installation tutorial: How to install phpmyadmin

First unzip phpMyAdmin-3.3.3-rc1-all-languages.zip, then rename it to phpmyadmin3, and copy it to the php program running directory. I copied it to the D:PHPWEB directory.

After completing this installation step of phpmyadmin3, please make sure that your IIS or Apache server is turned on, and whether the Mysql service is turned on. You can enter net start mysql in CMD mode to start the Mysql database service, and at the same time Please make sure that PHP has enabled the Mysql extension library. As long as one item is not turned on, it may cause phpmyadmin3 to be unable to open and access errors.

Now that the installation of phpmyadmin3 is complete, the next step is to configure phpmyadmin.

phpmyadmin configuration tutorial

First, enter the remote access address of phpmyadmin in the browser: http://localhost/phpmyadmin3, the following interface will appear

phpmyadmin remote access configuration username and password

Instructions for this interface: 1. You must log in using cookies, 2. You must log in remotely with a legal username and password. If the username and password of phpmyadmin are not configured, access will be rejected. So how to set the username and password for phpmyadmin? Referring to the configuration of the phpmyadmin2 version, there are two configuration methods:

1. Traditional phpmyadmin configuration method, create config.inc.php in the same level directory of the phpmyadmin root directory index.php, refer to the configuration file for details Please refer to config.sample.inc.php.

2. In the phpmyadmin3 version, there is a new configuration method, that is, there is no need to create config.inc.php, just modify the configuration items of the libraries/config.default.php configuration file. This is because phpmyadmin3 loads the contents of the libraries/config.default.php configuration file first by default. If there is config.inc.php, the same variables will be found in the config.inc.php configuration file and overwritten, so if there is no special Settings, you don't need to create a config.inc.php, just make relevant configurations in libraries/config.default.php.

Setting the username and password works as follows

Copy the code The code is as follows:

$cfg['Servers'][$i]['auth_type'] = 'cookie';//Set the phpmyadmin remote access method to cookie
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
?>

First set the login method as cookie, and then set the user name and password. The default user name is root and the password is empty. You need to set the user name and password according to the Mysql database configuration. I set them to root.

After configuring phpmyadmin, enter the user name and password to log in to phpmyadmin to manage the Mysql database, as shown in the figure:

phpmyadmin management interface

At this point, the configuration work of phpmyadmin3 is basically completed.
How to solve the problem that the additional features of phpmyadmin’s linked table have not been activated?
Returning to the picture above, we see that although phpmyadmin is configured and can be used, there is still a prompt at the bottom that some configuration work has not been completed. One of the prompts: The additional features of the linked table have not been activated, so how to solve it?
First, click the import link, upload scripts/create_tables.sql and execute it to create the phpmyadmin database.
Secondly, find

in the phpmyadmin configuration file config.default.php and copy the code The code is as follows:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable '] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = ' pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history' ;
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
?>

These variables are empty by default in the phpmyadmin configuration file. You only need to assign values ​​to the variables according to the comments.

After completing the above configuration operations, close the browser and log in again.

The phpmyadmin configuration file now requires a phrase password. How to solve it?

Find

in the phpmyadmin configuration file config.default.php Copy the code The code is as follows:

< ;?
$cfg['blowfish_secret'] = 'jb51.net'
?>

Here I assign the value to jb51.net, and this password is used for the encryption of Cookies.

Instructions for login methods of phpmyadmin

In phpmyadmin3, there are a total of four login methods

Config: Directly enter the phpmyadmin remote login address, as long as the user is set in the configuration file Just a password.

http: A dialog box pops up, enter the user name and password and enter

signon: A login method similar to page jump, and you need to set $cfg['Servers'][$i] ['SignonURL'], when you enter the remote login address of phpmyadmin, it will automatically jump to the URL set by signonURL.

Cookie: This is the login method when phpmyadmin is configured.

At this point, the entire installation and configuration of phpmyadmin3 is completed, and you can experience the new features of the new version of phpmyadmin.

http://www.bkjia.com/PHPjc/325188.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/325188.htmlTechArticleIn PHP website development, the most basic PHP environment construction involves PHP, Apache/IIS, Mysql, and for databases Management, in addition to the Mysql database itself provides command line tools to facilitate developer management...