1.Start the server:
shell> mysqld
or
shell> mysqld --console : The server will continue to write to the console any further dianostic output it produces.
2.Shutdow the server
shell> mysqladmin -h -u -p shutdown
such as shell> mysqladmin -h 192.168.12.252 -u root -p shutdown :the server in 192.168.12.252
shell> mysqladmin -u root -p shutdown :the server in localhost
3.Start mysql as a window service.
shell> msyqld --install serviceName --defaults-file
such as shell>mysqld --install
shell>mysqld --install mmgg
shell<mysqld --install mmgg --defaults-file=c:/mmgg
4.Remove a server that is installed as a service.
shell> mysqld --remove serviceName
such as shell>mysqld --remove
shell>mysqld --remove MySQL
5.Connect to the server.
shell> mysql -h -u -p
such as shell>mysql -h 192.168.12.252 -u root -p
shell>mysql -u root -p
6.Disconnect from the server.
mysql> quit(/q)
7.Show all databases.
mysql> show databases;
9.Chanage database.
mysql> use database;
10.Show all tables of one database.
mysql> show tables;
11.Describe one table.
mysql> describe tableName.
12.Load data into a table.
mysql> LOAD DATA LOCAL INFILE 'fileName' INTO TABLE tableName;
such as mysql>LOAD DATA LOCAL INFILE 'd:/mysql/data/user.txt' INTO TABLE user;
13.Show the selected database.
mysql> select database();
14.Describe table.
mysql> describe tableName;
such as describe user;
shell> mysqld
or
shell> mysqld --console : The server will continue to write to the console any further dianostic output it produces.
2.Shutdow the server
shell> mysqladmin -h -u -p shutdown
such as shell> mysqladmin -h 192.168.12.252 -u root -p shutdown :the server in 192.168.12.252
shell> mysqladmin -u root -p shutdown :the server in localhost
3.Start mysql as a window service.
shell> msyqld --install serviceName --defaults-file
such as shell>mysqld --install
shell>mysqld --install mmgg
shell<mysqld --install mmgg --defaults-file=c:/mmgg
4.Remove a server that is installed as a service.
shell> mysqld --remove serviceName
such as shell>mysqld --remove
shell>mysqld --remove MySQL
5.Connect to the server.
shell> mysql -h -u -p
such as shell>mysql -h 192.168.12.252 -u root -p
shell>mysql -u root -p
6.Disconnect from the server.
mysql> quit(/q)
7.Show all databases.
mysql> show databases;
9.Chanage database.
mysql> use database;
10.Show all tables of one database.
mysql> show tables;
11.Describe one table.
mysql> describe tableName.
12.Load data into a table.
mysql> LOAD DATA LOCAL INFILE 'fileName' INTO TABLE tableName;
such as mysql>LOAD DATA LOCAL INFILE 'd:/mysql/data/user.txt' INTO TABLE user;
13.Show the selected database.
mysql> select database();
14.Describe table.
mysql> describe tableName;
such as describe user;