Han Ligang Teacher Video teaching website http://www.91xueit.comMr. Han QQ458717185No. 01. mysql User and Rights managementMySQL permissions control is controlled by two steps, can not connect (authenticate user identity), what action (verify user
MySQL changes User Permissions
This entry was posted by admin Monday, 26 then l, 2010
1. "grant all on *. * to root @ '%' identified by 'yourpassword';" -- the password can also be set along with the password.2. "Flush privileges;" -- refresh to
The MySQL privilege system (controlled by MySQL permissions table user and DB) is certified in the following two ways:1) for the connected users to authenticate, legitimate through authentication, illegal to deny the connection.2) for the user who
MySQL users and permissions, mysql user permissions
I. Knowledge about MySQL permissions:
1. the MySQL permission system is mainly used to verify the user's operation permissions.
2. in MySQL, the permission information is stored in the granttable
User Rights Management mainly has the following functions:1. You can restrict which libraries a user accesses, which tables2. You can restrict which tables the user performs for select, CREATE, delete, delete, alter, etc.3. The IP or domain name
MySQLStudy-MySQL User and permission management MySQL server uses the MySQL permission table to control user access to the database. the MySQL permission table is stored in the mysql database and initialized by the mysql_install_db script. These
User management mysql>use MySQL; view mysql> select Host,user,password from user ; creating mysql> Create user zx_ Root identified by ' xxxxx '; //identified by will use plaintext password encryption as a hash value to store modifications
Mysql's common basic command summary and default account permissions and modifications have been simply using the database to store data, and windows is also used bad. many commands cannot be remembered when used. so, change to LINUX! No longer use
Tag:io os use ar for data sp div on User management mysql>use MySQL; view mysql> select Host,user,password from user ; creating mysql> Create user zx_ Root identified by ' xxxxx '; //identified by will use plaintext
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:
and provide relevant evidence. A staff member will contact you within 5 working days.