How to set root privileges for MySQL?

Take the user Lucia test as an example, if you want to set the root, just replace the user with root.

Start by logging in to the database as root.

Then look at the permissions for the user's Lucia test:

mysql> show grants for lucia_test;

usage means "no access".

Add full permissions to the Lucia Test user:

mysql> grant all privileges on *.to 'lucia_test'@'%';

All privileges means all privileges.

In order to ensure that the permission settings are effective, refresh it again:

mysql> flush privileges;

In this way, the specified user Lucia Test is given full permissions.

It is possible to set the permissions of the root user in the same way.

Authorization with grant statement:

grant select on testdb.* to root@'%'；

The preceding statement means that only the query permission on the testdb database is granted to the root user.

grant all privileges on *.to 'root'@'%';

The above statement means that all permissions on all databases are granted to the root user.

Method steps.

As we all know, there are a lot of permissions in mysql, and different permissions can use different functions, today I will teach you how to get the root permission of mysql, that is, the highest permission, you can do anything.

1.First, use an account that does not have permission to link to MySQL, and then run the following command: show databases; In this case, it will be found that users without permissions can only see one database, but not databases such as MySQL and test.

2.If phpmyadmin is already installed, open it, find the user in the menu bar, then find the user who does not have permissions, and click Permissions;

3.Jump to the settings page, find the global permissions, check the checkbox in all selection, click Execute in the lower right corner, and after completion, the user will get all the permissions of the MySQL database;

4.Use the account to link MySQL again, and run the following command after the link is successful: show databases; You'll find that all databases will be displayed, and you can do whatever you want with that account;

65.You can also set it directly on the command line of the cmd window, and the command to set the permission is:

revoke all privileges on *.from 'root'@'localhost'; grant all privileges on *.to 'root'@'localhost'with grant option max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 max_user_connections 0;

PS: The username part can be changed according to your actual situation.

Authorization with grant statement:

The specific steps are as follows:

1. First, use an account without permission to link to MySQL, and then execute: show databases; In this case, it will be found that users without permissions can only see one database, but not databases such as MySQL and test.

2. If phpmyadmin has been installed, open it, find the user in the menu bar, then find the user without permission, and click on permission;

3. Jump to the settings page, find the global permissions, check the checkbox in all selection, click Execute in the lower right corner, and the user will get all the permissions of the MySQL database after completion;

5. You can also set it directly on the command line of the cmd window, and the command to set the permission is:

revoke all privileges on *.from 'root'@'localhost'; grant all privileges on *.to 'root'@'localhost'with grant option max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 max_user_connections 0;

After rooting, you can get administrator permission to delete the built-in software on the phone at will, because the mobile phone manufacturer restricts you, and you can be considered the real owner of the phone with root permission. The next one-click root master can be one-click root, you can try, it's very simple.

Method steps As we all know, there are many permissions in mysql, different permissions can use different functions, today I will teach you how to get the root permission of mysql, that is, the highest permission, you can do anything.

1.First, use an account that does not have permission to link to MySQL, and then run the following command: show databases; In this case, it will be found that users without permissions can only see one database, but not databases such as MySQL and test.

2.If phpmyadmin is already installed, open it, find the user in the menu bar, then find the user who does not have permissions, and click Permissions;

3.Jump to the settings page, find the global permissions, check the checkbox in all selection, click Execute in the lower right corner, and after completion, the user will get all the permissions of the MySQL database;

4.Use the account to link MySQL again, and run the following command after the link is successful: show databases; You'll find that all databases will be displayed, and you can do whatever you want with that account;

65.You can also set it directly on the command line of the cmd window, and the command to set the permission is:

revoke all privileges on *.from 'root'@'localhost'; grant all privileges on *.to 'root'@'localhost'with grant option max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 max_user_connections 0;

PS: The username part can be changed according to your actual situation.