mysql 基本的常用命令（MySQL basic common commands）.docVIP

mysql 基本的常用命令（MySQL basic common commands） Mysql basic common commands Many friends, although installed MySQL, but do not know how to use it. In this article, we learn some common commands for MySQL from connecting MySQL, modifying passwords, and increasing users. Connect MySQL. Format: MySQL -h -u username password P host address 1 example 1: MYSQL connected to this machine. At first, open the DOS window, and then enter the mysql\bin directory, and then enter the command MySQL -uroot -p, enter the password prompt you, if just installed MySQL, root super user is no password, so you can directly enter into the MySQL, the MySQL prompt is: MySQL 2 example 2: the MySQL connected to the remote host. Suppose the IP of the remote host is 110.110.110.110, the user name is root, and the password is abcd123. Then type the following command: MySQL -h110.110.110.110 -uroot -pabcd123 (Note: u and root can use no spaces, and so will others) 3, exit the MySQL command: exit (carriage return) Two, change the password. Format: mysqladmin -u user name, -p old password, password new password 1 example 1: add a password to root ab12. First, enter directory mysqlbin under DOS, and then type the following command Mysqladmin -uroot -password ab12 Note: because root does not have a password at the beginning, an old password of -p can be omitted. 2 example 2: change the password of root to djg345 again. Mysqladmin, -uroot, -pab12, password, djg345 Three, add new users. (Note: unlike the above, the following is the command in the MySQL environment, so a semicolon is used as the command terminator at the back.) Format: Grant select on database. To user @ host identified by login password Example 1, add a user test1 password for ABC, so that he can log on any host, and all databases have inquiries, insert, modify, delete permissions. First, connect the root user to the MySQL, and then type the following command: Grant select, insert, update, delete on to test1@. * % Identified by ABC ; But in