mysql create database, add users, user authorization practical method

--Create a database named "testdb" and set the encoding set to utf8
CREATE DATABASE IF NOT EXISTS testdb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

 --Created a user named: test with password: 1234 create user 'test'@'localhost' identified by '1234';

--Query user select user,host from mysql.user;

--Delete user "test"
drop user test@localhost ;
--If the created user is allowed to log in from any computer, delete the user as follows drop user test@'%';

--Method 1, real-time password update; change the password of user "test" to "1122"
set password for test =password('1122');
--Method 2, requires refreshing; change the password of user "test" to "1234"
update mysql.user set password=password('1234') where user='test'
--refresh privileges;

--Grant user test all privileges on the database "testdb" through the external network IP grant all privileges on 'testdb'.* to 'test'@'%' identified by '1234'; 

--Flush privileges; 

--Grant user "test" the permissions to create, modify, and delete tables in the database "testdb" through the external network IP, as well as the permissions to add, delete, query, and modify table data grant create,alter,drop,select,insert,update,delete on testdb.* to test@'%';

--View user "test"
show grants for test;