Introduction to phpMyAdmin software
phpMyAdmin is written in PHP and can control and operate the MySQL database through the web. Through phpMyAdmin, you can completely operate the database, such as creating, copying, deleting data, etc. Managing a MySQL database is quite simple if you use the right tools. Applying the MySQL command line method requires being very familiar with MySQL knowledge, and the same is true for the SQL language. Not only that, if the database has a lot of access, it will be quite difficult to read the data in the list.
One of the greater advantages of phpMyAdmin is that because phpMyAdmin is executed on the web server like other PHP programs, you can use the HTML pages generated by these programs anywhere, that is, to remotely manage the MySQL database, conveniently creating, modifying, Delete the database and data tables. You can also use phpMyAdmin to create commonly used PHP syntax to facilitate the correctness of SQL syntax required when writing web pages.
phpMyAdmin installation steps
1. After decompressing, get a directory, enter the libraries directory in the relevant directory, find the config.default.php file, copy it to the upper-level directory, and name it config.inc.php;
Find $cfg['PmaAbsoluteUri'] in config.inc.php
Modify the URL of phpMyAdmin that you will use to allow virtual machine users to access
For example: $cfg['PmaAbsoluteUri'] = 'http://ip/phpmyadmin/'; or $cfg['PmaAbsoluteUri'] = 'http://ip:8899' (write the absolute URL to access phpMyAdmin)
There are also these changes:
$cfg['Servers'][$i]['host'] = 'localhost'; (usually the default is used, there are exceptions)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
Use cookies. Because it is used on the Internet, cookies are selected here.
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed, no need to set it in your own machine)
Note: $cfg['blowfish_secret'] = '';
There is no need to set it on this machine, but if it is on the network, it needs to be set as a cookie:
$cfg['blowfish_secret'] = 'cookie';
The settings are complete.
2. Open IE, enter http://ip/phpmyadmin/ (of course, use that URL if your settings are different.), enter the user name and password, and use phpmyadmin to browse the corresponding mysql database;
If you set $cfg['Servers'][$i]['auth_type'] = 'cookie'; then the display will ask you to enter the account number.
3. $cfg['DefaultLang'] = 'zh'; (Here is the language selection, zh means Simplified Chinese)
How to use phpMyAdmin
How to log in to MySQL
config
Directly write an account and password that can log in to mysql in the configuration file. As long as you browse the datamgr directory, you can directly manage mysql operations with the mysql account written in the configuration file. The characteristic is convenience, but the disadvantage is that it is not safe.
HTTP uses the authentication function of the web server. An authentication window will pop up before browsing the datamgr directory. As long as the mysql account is correct, you can have access to the datamgr directory. This is safer,
However, configuring PHP with cgi or fastcgi, will not be able to use this function, because cgi will not send some verification information variables to the server.
Cookies
Like http, a verification window will pop up, but this does not use the verification function of the web server, but is directly a normal login window written in PHP. As long as the browser supports cookies, all browsers on the market should support the basic function of cookies. Therefore, cookie verification is generally chosen.
phpMyAdmin update log:
1.Fix some bugs
2. Optimized some functions
Huajun editor recommends:
phpMyAdmin software is a software with excellent performance, which is obvious to all. Huajun Software Park also hasAlphaEbot action editing software,He Xiaoxiang programming client,Automated testing tool AutoRunner,Easy GUI,Little turtle LOGO languageWaiting for related software that is definitely worth downloading and using, come and choose your favorite one!
it works
it works
it works