MySQL common command Import and export modify root password

MySQL Forgot Password Solution
If MySQL is running, first kill it: Killall-term mysqld.
Start Mysql:mysql--skip-grant-tables &
/etc/init.d/mysqld start
You can go to MySQL without a password.
Mysql-u root-p
Then there is
>use MySQL
>update User Set Password=password ("New_pass") where user= "root";
>flush privileges;

MySQL Import command:
Mysql-uroot-p Password Vault Name < Xxxx.sql
MySQL Export command:
Mysqldump-uroot-p Password Vault name > Xxxx.sql

Export-only data does not change the table structure:

MYSQLDUMP-T database name-uroot-p > Xxx.sql

Export the table structure of a data table in a database (without data)

Mysqldump-u Username-p-D dbname tablename > Tablename.sql

MySQL common command Import and export modify root password