doulao1966 2019-08-15 12:48
浏览 254

MySQL说:您的SQL连接存在问题 - 用户'''%'访问被拒绝到数据库

I am using the wpDataTables plugin on WordPress. I am trying to connect to a MySQL database on my local machine. It asks for server, port, database name, user, and password. No matter what I try, I get one of two errors:

wpDataTables could not connect to mysql server. mysql said: There was a problem with your SQL connection - Access denied for user ''@'%' to database 'storm' " using 127.0.0.1 as host

wpDataTables could not connect to mysql server. mysql said: There was a problem with your SQL connection - No such file or directory" trying to use 'localhost' as host

I use MySQL an application called TablePlus on my MacBook.

I have tried changing authentication string for the root user, created users and changed their authentication string. Yet nothing still works.

I have tried select * from mysql.user and saw the users and their privileges and none of the information I plugin in there works.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥65 汇编语言除法溢出问题