Page 18-phpMyAdmin Programming Tutorials: Learn phpMyAdmin Online-php.cn

Article Tags

All
web3.0
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Backend Development
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Web Front-end
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Database
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Operation and Maintenance
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Development Tools
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
PHP Framework
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Common Problem
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Other
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Tech
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
CMS Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Java
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
System Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Computer Tutorials
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Hardware Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Mobile Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Software Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Mobile Game Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache

Home

Technical Articles

Database

phpMyAdmin

What should I do if the Alibaba Cloud database cannot connect to phpmyadmin?

The solution to the problem that Alibaba Cloud database cannot connect to phpmyadmin: first copy "config.sample.inc.php" to "config.inc.php"; then modify the code to "$cfg['Servers']['host']=' 127.0.0.1'" will do.

Apr 06, 2020 am 09:52 AM

phpmyadmin

How to upgrade phpmyadmin in Alibaba Cloud

How to upgrade phpmyadmin on Alibaba Cloud: First, go to the official website to download the latest version of phpmyadmin compressed package; then unzip it and name the folder "phpMyAdmin"; finally, directly overwrite it in the phpMyAdmin folder in the root directory of the website to complete the upgrade.

Apr 06, 2020 am 09:47 AM

phpmyadmin

What should I do if phpmyadmin reports an error when setting the ID primary key to auto-increment?

The solution to the error when phpmyadmin sets the ID primary key to auto-increment: first log in to phpmyadmin, select a table in the database, and select "Structure"; then find the primary key to be set to auto-increment, and click [Modify]; then drag the browser's scroll bar Go to the far right to find the word "A_I" and check it; finally save it.

Apr 01, 2020 am 10:06 AM

phpmyadmin

What does phpmyadmin mean?

phpmyadmin is a MySQL database management tool based on PHP and structured in Web-Base mode on the website host. It allows administrators to use the Web interface to manage MySQL databases, such as creating, modifying, deleting MySQL databases and data tables, etc.

Apr 01, 2020 am 10:01 AM

phpmyadmin

How to modify the table prefix in phpmyadmin

How to modify the table prefix in phpmyadmin: First use phpMyAdmin to open the database where you want to modify the prefix; then select "Customize" -> "Display directly as text"; then enter the SQL execution window of the database; finally, replace the code "replace(..) "Paste it into the SQL text box and execute it to complete the modification.

Apr 01, 2020 am 09:56 AM

phpmyadmin

How to add auto-increment in phpmyadmin

How to add auto-increment in phpmyadmin: first open the phpmyadmin management tool; then create a new data table in phpmyadmin and add the id field; then tick the "AUTO_INCREMENT =A_I" option to add the id auto-increment.

Apr 01, 2020 am 09:49 AM

phpmyadmin

How to set field attributes in phpmyadmin

How to set field attributes in phpmyadmin: first open the phpmyadmin management tool; then click the "Structure" tab in the phpmyadmin interface; then check the field in which a unique index needs to be established; and finally click "unique" to set the attributes for the field.

Apr 01, 2020 am 09:44 AM

phpmyadmin

How to assign sub-accounts in phpmyadmin

How to allocate sub-accounts in phpmyadmin: First open phpMyAdmin, click the [User] button in the menu bar to enter the user management page; then click [Add User] to create a new user and enter the user name; then enter the host [Host] information; finally enter Password and assign permissions to the user.

Apr 01, 2020 am 09:36 AM

phpmyadmin

What does phpmyadmin mean?

The function of phpmyadmin is to control and operate the MySQL database through the web; because phpmyadmin is executed on the web server, the HTML pages generated by these programs can be used anywhere, that is, to manage the MySQL database remotely, making it easy to create, modify, and delete the database. and data sheets, etc.

Apr 01, 2020 am 09:30 AM

phpmyadmin

What should I do if the sql file exported by phpmyadmin is garbled?

The solution to the garbled sql file exported by phpmyadmin: first open the phpmyadmin management tool; then find and open the Language drop-down menu; then select the "中文-chinese simplified" option; and finally re-select the export sql file to display it normally.

Apr 01, 2020 am 09:24 AM

phpmyadmin

phpmyadmin exports Chinese garbled characters

Solution to Chinese garbled characters exported by phpmyadmin: When exporting the database, change the character set used by phpmyadmin to Chinese simplified(zh-utf-8) or Chinese simplified(zh-gb2312-utf-8) according to the database encoding.

Mar 27, 2020 pm 04:58 PM

phpmyadmin

How to add field primary key in phpmyadmin

How to add a field primary key in phpmyadmin: Find the table to which you want to add the primary key in the database corresponding to phpMyAdmin, click the corresponding "Structure" behind the table, and then click the corresponding "Primary Key" button.

Mar 19, 2020 pm 03:59 PM

phpmyadmin

What should I do if phpMyAdmin cannot connect to MySQL?

The solution to the problem that phpMyAdmin cannot connect to MySQL: first open the config.inc.php file; then search localhost and find $cfg['Servers'][$i]['host']; finally change its value to 127.0.0.1. Can.

Mar 14, 2020 am 10:51 AM

phpmyadmin mysql 无法连接

How to change the import limit of phpmyadmin to 2m

How to modify the phpmyadmin import limit of 2m: first find "uplod_max_filesize" in the "PHP.ini" configuration file and change the default 2M to the size of the file to be imported; then find "post_max_siz" and change the default 8M to the size of the file to be imported. size is enough.

Mar 12, 2020 pm 01:56 PM

phpmyadmin