MySQL commands in Linux

I. Summarize some MySQL commands in Linux:

1. commands for starting mysql in Linux:
Mysqladmin start
/Ect/init. d/mysql start (the installation path of mysql is earlier)

2. Command for restarting mysql in Linux:
Mysqladmin restart
/Ect/init. d/mysql restart (the installation path of mysql is earlier)

3. Run the following command to disable mysql in Linux:
Mysqladmin shutdown
/Ect/init. d/mysql shutdown (the installation path of mysql is earlier)

4. Connect to mysql on the local machine:
Enter the mysql \ bin directory, type the mysql-uroot-p command, and press enter to enter the password.
Exit mysql command: exit (Press ENTER)

5. Modify the mysql password:
Mysqladmin-u username-p old password New password
Or enter the mysql command line set password for root = PASSWORD ("root ");

6. Add new users. (Note: commands in the mysql environment are followed by a semicolon as the command Terminator)
Grant select on database. * to username @ login host identified by "password"
For example, if a user's test password is added to 123, the user can log on to any host and have the permission to query, insert, modify, and delete all databases. First, use the root user to connect to mysql, and then type the following command:
Grant select, insert, update, delete on *. * to "Identified by" 123 ";

1 2 3 Next Page