The easiest way to create a new user and grant permissions to MySQL

Create a user:

create user 'oukele'@'%' identified by 'oukele';

If the information listed below is prompted, you need to refresh the permission table

The MySQL server is running with the --skip-grant-tables option so it cannot execute this st...

Here are the steps:

Extended Learning

Create a new mysql user and grant remote access rights

[root@demo /]# mysql -u root -p #Log in to the server database

Enter password:123xxx

#1. Create a new user testuser with password testuserpass

CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testuserpass';

#2. Create a database testDB

create database testDB;

#3. Execute the command to add testDB permissions for the testuser user

grant all privileges on testDB.* to testuser@localhost identified by 'testuserpass';

#4. Execute the command to add remote access permissions for the testuser user

GRANT ALL PRIVILEGES ON testDB.* TO 'testuser'@'%' IDENTIFIED BY 'testuserpass' WITH GRANT OPTION;

#5. Refresh the permission table

flush privileges;

The above is all the content of this knowledge point. More relevant knowledge points can be found in the related articles below.