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.