Download the latest version of phpMyAdminMYSQL manager, click this site to download phpMyAdmin, decompress it, and get a phpMyAdmin Directory (you can change the name) to find the config in the directory. inc. open the php file and find $ cfg [PmaAbsoluteUri] to modify the phpMyAdmin URL you will upload to the space, for example, $ cfg [PmaAbsoluteUri] http: phpmyadmin
Download the latest phpMyAdmin MYSQL manager. Click here to download phpMyAdmin.
Decompress the package and obtain a phpMyAdmin Directory (you can change the name)
Find the config. inc. php file in the directory and open
Find $ cfg ['pmaabsoluteuri ']
Modify the phpMyAdmin URL that you will upload to the space
For example, $ cfg ['pmaabsoluteuri '] = 'http: // your.domain.com/phpmyadmin /';
And the following
$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; (by default, there are exceptions)
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'config'; // Authentication method (config, http or cookie based )?
Debug config in your own machine, if you use cookies on the Internet.
$ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, root in your machine, set your ftp user name on the Internet)
$ Cfg ['servers'] [$ I] ['password'] = ''; // MySQL password (only needed
You do not need to set it in your own machine
$ Cfg ['servers'] [$ I] ['only _ db'] = ''; // If set to a db-name, only (you have only one data set)
Other settings
$ Cfg ['defaultlang '] = 'zh ';
After the settings are complete, you can upload them to the Internet.
Browsing http://your.domain.com/phpmyadmin/ of course you set up different to use that Web site.
If the cookie is set (see the above), the following login window will appear:
After logging in or without setting cookies, you can access the phpmyadmin homepage.
Select a table (such as cdb_members) on the left. you can see the following:
Pull down the window on the right and you will see
Note that the fields circled in red are added.
You can add multiple fields at a time, or you can select which field is followed by the added field.
If a field is added by default, click start to see
Enter as needed
You can also click SQL
Enter
Run the mysql statement to add or operate mysql.
Backup
Select data and click output
Select the table to be backed up (you can select the first table and press shift to press the last one to select the table from the first to the last one, or select a random table by pressing alt)
Click Start.
You can familiarize yourself with other features. Chinese interface should be easy to understand
Note: $ cfg ['blowfish _ secret'] = '';
You do not need to set the local machine, but you need to set the network to cookie:
$ Cfg ['blowfish _ secret'] = 'cooker ';
