how the mysql database sets user permissions, such as 100 tables. I want to set the user to read only 99 of these tables. There is also a table that does not have access. -sharp-sharp-sharp problem description
/ / Please paste the code text below (do not replace the code with pictures)
if it is convenient, separate 99 tables and 1 table into two schema, and only authorize the schema permission of 99 tables to the user. Otherwise, let's use
grant statement to learn about
if it is inconvenient, grant all the tables under the database to the user first;
then revoke the table that you do not have access to separately.
for more information on the usage of grant and revoke, please refer to mysql Authorization and revocation
Previous: The file downloaded by vue+axios through POST request is garbled.
Next: Why does the meta written by "the solution of 1px" in the desert only use to set scale??
set up a Linux server (Ubuntu 18.04) in Linode. Using PhpStorm to connect remotely has been a failure, and attempts to retrieve various scenarios have been fruitless. Please help me a lot. Thank you! the settings are as follows: : system log: ...
problem description after installing LNMP, if you want to build a database, you enter phpmyadmin, but after logging in, the following error message is displayed the environmental background of the problems and what methods you have tried I searche...
linux server, a master server, the speed of using tp5 to connect to the website opened by mysql, is too slow, how to solve it? skip_name_resolve this part of the code has been added ...
use mysqldump to back up data from the MySQL server on the web server if so: mysqldump -hxxx.xxx.xx.xx -uusername -ppwd db table --where="order_id > 4300284 and order_id < 4300293" > xxxx file.sql enter the password in clear text...