Old boy Education day-106th day-mysql How to authorize users to Admin:password remote access permissions

Answer:

Assume the intranet segment 172.16.1.0, user admin, password password, database Oldboy.

Create users only:

Create user ' admin ' @ ' 172.16.1.% ' identified by ' password ';

Creating users and authorizing database permissions is also the most common use of work:

Grant all privileges the oldboy.* to ' admin ' @ ' 172.16.1.% ' identified by ' password ';

Note

Today is the 106th day of the day to accompany you and look forward to your progress .

For questions and answers, please leave a comment in the blog comments section .
Index of the topic of the previous period

http://lidao.blog.51cto.com/3388056/1914205

This article is from the "Lee blog" blog, make sure to keep this source http://lidao.blog.51cto.com/3388056/1953294

Old boy Education day-106th day-mysql How to authorize users to Admin:password remote access permissions