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.