Start the Server:
Shell>
mysqld
oral
Shell>
Mysqld - Console: The Server Will Continue to Write To The Console Any Further Dianostic Output It Products.
2.SHUTDOW The Server
Shell>
mysqladmin -h -u -p shutdownsuch 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-FILESUCH AS Shell> MySQLD --Install
Shell> mysqld --install mmgg
Shell 4.Remove a Server That ISTALLED AS A Service. Shell> MySQLD - Remove ServiceNameSuch 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 data; 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> loading data local infile 'd: /mysql/data/User.txt' INTO TABLE User; 13.Show The Slected Database. MySQL> Select Database (); 14.Describe Table. MySQL> Describe TableName; Such As Describe User;
