Mysql database Management Common commands summary _mysql

MySQL Database management is a crucial part of the database, to understand the management of MySQL database must start from the foundation, only the first knowledge of the database Management command, the actual operation is much easier. Here is the MySQL database management common commands:

2. Install MySQL using the RPM package and set the TCP 3306 port iptables.
4. Root password management Sets the password of root user mysqladmin-uroot password ' password '.
6. Modify root password mysqladmin-uroot-p password ' password '.
8. Database, table management enters Mysqlmysql-h hostname-uroot-p.
10. Creating database mysql> Create DB location.
12. Import data Structure mysql-uroot-p location <./location.sql.
14. View database mysql> show databases;
16. Enter a library mysql> use location;
18. View table information mysql> show tables;
20. View table structure mysql> desc contact;
22. Change table name mysql> Rename table contacts to Contact_new.
24. Delete Library mysql> drop database location.
26. Delete Table mysql> drop table contact.
28. The authorization section establishes the user and authorizes mysql> grant all on location.* to gk1020@ ' 10.1.11.71 ' identified by ' gk1020 '.
30. Suppresses authorization mysql> revoke all on location.* from gk1020@ ' 10.1.11.71 '.
32. Refresh Permissions mysql> flush privileges.
34. Action Statement Query mysql> SELECT * from Contacts.
36. Mysql> Select COUNT (*) from the contact.
38. Modify mysql> Update Contact set regtime= ' 2008-01-01 00:00:00 ' where id=1.
40. mysql> Update Contact Set regtime= ' 2008-01-01 00:00:00 ', cid=1 where id=1.
42. Inserts mysql> INSERT into the contact values (', ' ...)
44. Mysql> insert into Contacts (id,cid,contact) VALUES (', ' ...)
46. Deletes the mysql> delete from the contact where id=1.
48. Export Export Database locationmysqldump-uroot-p location >./location.sql.
50. Export a table mysqldump-uroot-p--database location--table contact >./contact.sql.
52. Export the database location data structure mysqldump-d-uroot-p location >./location.sql.
54. Copy table copy table contact for contact_bakmysql> CREATE TABLE Contact_bak as SELECT * from Contacts.
56. Copy table contact's structure mysql> CREATE TABLE Contact_bak as SELECT * from Contacts where 1=2.
58. View the tasks you are performing mysql> show processlist.

Special Note:

Location for library name, contact for table name

Everyone to understand these MySQL database management commonly used commands, and in the actual operation of the application, proficiency, then MySQL database management common commands will be easy.