phpMyAdmin Tutorial Create a new user/import/Export Database

Source: Internet
Author: User
Tags php source code phpmyadmin what is phpmyadmin

If you use PHP source program (such as WordPress) to build a station, it is best to learn how to operate phpMyAdmin, so that the maintenance of your website database, is more handy. Perhaps you would ask, what is PhpMyAdmin? Why learn to use PhpMyAdmin?

What is PhpMyAdmin?

PhpMyAdmin is a php-written, web-based way to control and manipulate MySQL databases. With PhpMyAdmin, you can fully manipulate the database, such as creating, copying, deleting data, and so on.

Why learn to use PhpMyAdmin?

PHP source code programs (such as WordPress) are generally to use the MySQL database, and through the phpMyAdmin can operate on the MySQL database, which is why you have to learn to use.

PhpMyAdmin How do I create a new user and database?

1. Log in using your PhpMyAdmin account, click "Permissions", "Add New User"

2. Fill in the "Login information", then select "Create a database with the same name as the user and grant all permissions", and finally create a new:

3, according to the operation, we can get a MySQL database without any data table, the basic information of this database is:

User name: Wpdaxue

Database name: Wpdaxue

Database address: localhost

Database Password: The one that was filled in when created

MySQL database already has, you also have a Web site database file, how to import this file into the new MySQL database?

PhpMyAdmin How do I import a database file?

1. After logging in, click to enter the database you want to import:

2. Then click "Import", select the database file you want to import, execute:

3. Import Success:

PhpMyAdmin How do I export a database file?

Still, go to the database you want to manipulate and click "Export" to execute:

Note the differences in how you export from the diagram, depending on your needs, select "Customize" here

Summary of this article

1, to create a new user and database in the PhpMyAdmin, your account must have the corresponding operation rights, otherwise there is no way.

2, usually, we are in the site backup, the site move (that is, change the host space), will use the PhpMyAdmin import and export functions.

phpMyAdmin Tutorial Create a new user/import/Export Database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.