Easy eight words to teach you to completely handle MySQL database

Source: Internet
Author: User
Tags modify mysql host mysql database

This article allows you to use eight easy words to teach you to completely handle the MySQL database.

First, connect MySQL

Format:

mysql -h主机地址
-u用户名
-p用户密码

1, Example 1: connected to the MySQL on this computer:

First in the Open DOS window, and then into the directory Mysqlbin, and then type the command mysql-uroot-p, enter after the prompt you to lose the password, if just installed MySQL, superuser root is no password, so direct return can enter into MySQL, The MySQL prompt is:mysql>.

2, Example 2: Connect to the remote host MySQL. Assume the IP of the remote host is: 110.110.110.110, username is root, password is abcd123. Type the following command: mysql-h110.110.110.110-uroot-pabcd123.

3, exit MySQL command: Exit (enter).

Second, modify the password

Format: Mysqladmin-u username-P Old password password new password

1, Example 1: To root add a password ab12. First enter the directory Mysqlbin in DOS, and then type the following command:

Mysqladmin-uroot-password AB12

Note: Since Root does not have a password at the beginning, the-p old password can be omitted.

2, Example 2: Then change the root password to djg345:

MYSQLADMIN-UROOT-PAB12 Password djg345

Iii. increasing the number of new users

(Note: Unlike the above, the following are the commands in the MySQL environment, followed by a semicolon as the command Terminator)

Format:

grant select on 数据库.*
to 用户名@登录主机 identified by "密码"

Example 1, add a user test1 password for ABC, so that he can log on any host, and all databases have query, insert, modify, delete permissions. First connect the root user to MySQL, and then type the following command:

grant select,insert,update,
delete on *.* to test1@"%" Identified by "abc";

But for example 1 the increased user is very dangerous and you want someone who knows Test1 's password so that he can log on to your MySQL database on any computer on the Internet and get your information right, as shown in Example 2.

Example 2, add a user test2 password for ABC, so that he can only log on the localhost, and can query the database mydb, insert, modify, delete operations (localhost refers to the local host, that is, the MySQL database of the host), This allows the user to use a password that knows test2, and he cannot access the database directly from the Internet, only through a Web page on the MySQL host.

Grant Select,insert,update,delete on mydb.* to Test2@localhost identified by "ABC";

If you do not want to test2 the password, you can make another command to eliminate the password.

Grant Select,insert,update,delete on mydb.* to Test2@localhost identified by "";

Note: You must first log in to MySQL, and the following actions are performed under the MySQL prompt, and each command ends with a semicolon.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.