Mysql Assign User to Access Specific Database

Created2020-05-22|Updated2026-01-07|devdatabase

|Post Views:

Today, using a new user to access the mysql of the cloud server, I found that an error was reported and I could only access the infomation_schema database. Following the method on the blog to enter the command grant all privileges on test_db.* to testuser@localhost identified by "123456", mysql kept reporting errors.
Image Description
I have been following the blog to grant permissions but it reports errors. I feel it should be due to version inconsistency causing command changes.
Sure enough, I found this command in the instruction document of refman-8.0-en.

Since I just started with mysql, I rely mostly on blogs and baidu. In fact, I should check these query methods against the instruction documents, instead of blindly believing a single solution, which causes precious working time to be wasted on meaningless debugging.

Author: Broccoli

Link: https://xlx.dev/dev/database/mysql/mysql-user-db-access/mysql-user-db-access.en/

Copyright Notice: All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.

Related Articles

WCF IIS配置并引用并初步使用Mysql数据库

学习网址：https://docs.microsoft.com/zh-cn/dotnet/framework/wcf/how-to-create-a-wcf-client本地资源配置与IIS资源配置我是根据微软官网学习的，有兴趣的可以跟着敲一下，我这里只说一下我遇到的问题 IIS 再IIS中配置服务时，根据教程上创建虚拟目录，发现如果我如果再默认站点创建服务将会提示InvalidOperationException: 找不到类型“Microsoft.ServiceModel.Samples.CalculatorService,发现我再默认站点已经托管了一个服务导致的问题。应该是今天感冒有点迟钝新建站点：1.1. 将我们的路径端口及名称输入即可，和创建Web站点一个步骤。创建文件APP_Code、service.svc、Web.config,其中Web.config文件按照官方给的案例后面将会出现无法打开安全通道，因为与远程终结点的安全协商已失败。这可能是由于用于创建通道的 EndpointAddress 中不存在 EndpointIdentity 或错误指定了 Endpoint...

WCF IIS Configuration and Reference and Preliminary Use of Mysql Database

Learning URL: https://docs.microsoft.com/zh-cn/dotnet/framework/wcf/how-to-create-a-wcf-clientLocal resource configuration and IIS resource configuration I learned according to Microsoft official website, interested can follow to type, I only calculate problems I encountered here IIS When configuring service in IIS, creating virtual directory according to tutorial, found if I create service in default site will prompt InvalidOperationException: Cannot find type “Microsoft.ServiceModel.Samples...

vs2019 Connect MySQL You have a usable connection already.

Found big shot solving vs2017 problem, found this is bug of mysql itself, need to install specific version of mysql-connect-net and mysql-connect-netSolution

vs2019连接MySQL You have a usable connection already.

找到大佬在解决vs2017的问题，发现这是mysql本身的bug，需要安装特定版本的mysql-connect-net和mysql-connect-net解决方案

MySQL Lock Granularity and ACID

Table Lock: It locks the entire table. Before a user performs a write operation (insert, delete, update, etc.) on the table, they need to acquire a write lock first, which will block all read and write operations on the table by other users. When there is no write lock, other users can obtain read locks, and read locks between multiple users do not block each other.Row Lock: Row-level locks can support concurrent processing to the greatest extent (and also bring the largest lock overhead). AC...

MySQL 锁粒度与ACID

表锁(Table Lock)：它会锁定整张表。一个用户在对表进行写操作(插入、删除、更新等)钱，他需要先获得写锁，这会阻塞其他用户对该表的所有读写操作。没有写锁的时候，其他用户可以获得读锁，多用户之间的读锁相互不阻塞。行级锁(row lock):行级锁能够最大程度的支持并发处理(同时也带来了最大的所开销)。 ACIDACID表示原子性(atomicity)、一致性(consistency)、隔离性(isolation)和持久性(durability) 原子性(atomicity)：一个事务必须被视为一个最小的工作单元，整个事务中的所有操作要么全部提交成功，要么全部失败回滚，对于一个事务来说，不可能只执行其中的一部分操作一致性(consistency):数据库总时哦才能够一个一致性的状态转换到另外一个一致性的状态。在执行事务某条语句的时候系统突然蹦会，导致事务最终没有提交，所以事务所作的修改也不会保存到数据库中隔离性(isolation):通常来说，一个事务所作的修改在最终提交以前，对其他事务是不可见的。在一个事务没有执行结束时，对事务的修改不会影响外部数据。持久性(durabil...

Loading Database