MySQL Make Instruction 1

xiaoxiao2021-04-01  237

1, first install MySQL.

2, under the installation directory, run Winmysqladmin.exe, then enter the username and password (newly established users), then you will see the MySQL icon of the desktop right foot (like traffic light).

3, login database:

Located under the DOS to mysql / bin, use mysql -uroot -q to connect to the local database

If root has set a password: use the mysql -uroot -p password;

Connect to MySQL on the remote host. Suppose the IP of the remote host is: 110.110.110.110, the username is root, the password is ABCD123. Type the following command: mysql -h110.110.110.110 -uroot -Pabcd123

Description: Username: root Password: ABCD123

4, then use the Connect Database command to select the database after selecting the database.

5, authorization statement

Grant all privileges on test. * To luning @ localhost iDentified by "password";

6. Database structure and data export:

Export table structure and data statement: Use mySQLDUMP command in mysql / bin directory

MySQLDUMP PHPTEST> A.SQL

Data Import:

Perform a.sql file directly under MySQL is OK.

转载请注明原文地址:https://www.9cbs.com/read-131252.html

New Post(0)