Mysql实例不适用于本地用户帐户

I installed an instance of MySQL 5.1. The service runs fine when I log on as Administrator. But I am unable to run the instance using a local user account. The instance runs in 'localhost'. I get Error 5: Access Denied when I try to start the service from the local account. Should I elevate privileges to run the service? How do I do it? I tried to Run As Admin and it still doesn't work.

我安装了MySQL 5.1的一个实例。以管理员身份登录时,该服务运行正常。但是我无法使用本地用户帐户运行实例。该实例在“localhost”中运行。当我尝试从本地帐户启动服务时,我收到错误5:访问被拒绝。我应该提升权限来运行服务吗?我该怎么做?我试图以管理员身份运行,但仍然无效。

1 个解决方案

#1

See MySQL docs: you need to CREATE USER and GRANT permissions specifically to the user@localhost.

请参阅MySQL文档:您需要专门为用户@ localhost创建USER和GRANT权限。