MySql sets the specified user database view query permissions

1. Create a new user:

1. Execute SQL statement to create a new one (recommended):

INSERT INTO `mysql`.`user` (
	`Host`,
	`User`,
	`Password`,
	`ssl_cipher`,
	`x509_issuer`,
	`x509_subject`,
	`authentication_string`
)
VALUES
(
	'%', -- Allow remote access 'zhangsan', -- User name '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9', -- Plain text password: 123456
	'',
	'',
	'',
	''
);

select * from user where `user` = 'zhangsan';

2. Use tools to create:

2. Set permissions

1. Configure the database and data table (remember to save):

2. Set [Server Permissions] to revoke all

3. Refresh database permissions:

MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.000 sec)

4. Configure the connection:

3. Test permissions:

1. Test results show that the databases and tables without permissions have been blocked:

2. Test whether there is deletion permission:

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.