Introduction to adding new users to MySql, creating databases for users, and assigning permissions to users

1. Add a new user

Only allow local IP access

create user 'test'@'localhost' identified by '123456';

Allow external IP access

create user 'test'@'%' identified by '123456';

Refresh Authorization

flush privileges;

2. Create a database for the user

create database test DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

3. Assign permissions to users

Grant users all permissions to operate the database through the external IP

grant all privileges on `testdb`.* to 'test'@'%' identified by '123456';

Grant users permission to operate all databases through external IP

grant all privileges on *.* to 'test'@'%' identified by '123456';

Refresh Authorization

flush privileges;

This is the end of this article about how to add new users in MySql, create databases for users, and assign permissions to users. For more information about how to add new users in MySql, create databases for users, and assign permissions to users, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!