English 中文(简体)
如何设置 phpmyadmin 数据库的读/ 写权限?
原标题:How to set read/write permission on database in phpmyadmin?

我在一个文字印刷站工作, 没有人可以访问仪表板, 因为数据库被设置为只读。 我可访问 phpmyadmin, 但我无法找到如何将数据库改回读/ write 。

就我所知,我有全部特权(例如,我可以修改表格,我成功地建立了一个新的行政账户)

我尝试过使用查询:

`美国大师;

上 去

ALTER 数据数据库名称

(a) 标准读写;

上 去`

但我明白错误

1044 - Access denied for user xxx @ localhost to database master

这是改变 msql 数据库权限的正确方法吗? 还是我抓错树了? 如果它是正确的树, 它是否只是获取根访问权限的一个案例?

谁能指给我正确方向?

提前感谢大家,

育空地区

最佳回答

如果您正在使用 CPartel, 也可以去 MySQL 区域, 并更改用户的权限, 只需让他们都能够确保它不是一个特权问题。 还要检查您在连接中使用的用户名是否正确 。

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签