MySQL usage notes

MySQL databases are used in the project as the backend. I have never used them before. I learned how to configure them,
Record the process here for future use.
After the installation is downloaded, go to the bin directory under the MySQL installation directory under DOS.

Logon: mysql-h172.18.2.87-uroot-P
Show existing database name: Show databases;
Use dbname;
Show existing table name: show tables;

Import external *. SQL to the BBS Database: D:/MySQL/bin/> mysql-uroot-p bbs <D:/DDL. SQL

Get the column information: Describe tabname;