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

How to solve the setting of MySQL access rights? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The method to solve the setting of MySQL access permission is to enter [mysqld-shareware.exe] and then [mysql-- user=root mysql] under the mysql execution directory, and then enter [mysql''gt] and operate at the prompt.

How to solve the MySQL access setting:

Access permission setting method 1

Authorize with the Grant command, and enter the following code:

Mysql "gt;GRANT ALL PRIVILEGES ON *. * TO system@localhostIDENTIFIED BY 'manager' WITH GRANT OPTION

Should display: Query OK, 0 rows affected (0.38 sec)

Access permission setting method 2

Set each permission for the user:

Mysql "gt;INSERT INTO user valueS ('localhost','system',PASSWORD (' manager'), 'Yacheng pageantry, yawphippy, yawphiko, yangzhongpai, yangyun, yaoyun, Y').

For version 3.22.34 of MySQL, there are 14 "quot;Y" quot;, with the corresponding permissions as follows (in field order): permissions table column names explain the scope of use accordingly

Select Select_priv requires the select permissions table only if it is actually retrieved from a table.

Insert Insert_priv allows you to insert new rows into an existing table

Update Update_priv allows you to update the list of rows in an existing table with new values

Delete Delete_priv allows you to delete row tables that meet the criteria

Create Create_priv allows you to create new databases and tables databases, tables, or indexes

Drop Drop_priv discards (deletes) existing databases and tables

Reload Reload_priv allows you to tell the server to re-read the authorization table server management

Shutdown Shutdown_priv may be abused (by terminating the server denying service to other users) server management

Process Process_priv allows you to view the plain text of the currently executed query, including setting or changing passwords to query server management

File File_priv permissions can be abused on the server to read any readable file to file access on the database table server.

Grant Grant_priv allows you to grant those permissions you own to other user databases or tables

References References_priv allows you to open and close record file databases or tables

Index Index_priv allows you to create or drop (delete) indexed tables

Alter Alter_priv allows you to change the table, which can be used to * * permission system table by renaming the table.

If you create a user with only select, insert, update, and delete permissions, the user is allowed to perform operations only on existing tables in one database.

Now we can create the database we want to use, and we enter it directly. For example, if we want to create a database named XinXiKu, we can use the following code:

Mysql "gt;create database XinXiKu

Should display: Query OK, 1 row affected (0.00 sec)

Thank you for reading! After reading the above, do you have a general idea of how to solve the setting of MySQL access rights? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.