Shulou(Shulou.com)06/01 Report--

What does it mean that mysql should pay attention to creating roles? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Mysql creates roles

1. Enter MySQL

Mysql-u root-p

two。 Create a new user

Create a user name of testuser and password of 123456

Grant all privileges on *. * to testuser@localhost identified by "123456"

Set user testuser to access mysql locally

Grant all privileges on *. * to testuser@localhost identified by "123456" l

Set the user testuser, which can access mysql remotely

Grant all privileges on *. * to testuser@ "%" identified by "123456"

3. Set user database permissions

Set that users can only access the database test_db

Grant all privileges on test_db.* to testuser@localhost identified by "123456"

Set up that users can access all databases on mysql

Grant all privileges on *. * to testuser@localhost identified by "123456"

3. Set user operation permissions

Set user administrator permissions

Grant all privileges on *. * to testuser@localhost identified by "123456" WITH GRANT OPTION

Set the user only to query operation permissions

Grant select on *. * to testuser@localhost identified by "123456" WITH GRANT OPTION

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

This is the answer to the question about what you should pay attention to in creating roles in mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.