0

I'm trying to connect to a Mysql DB from a server that isn't where the database exists, another words two servers. They exist on the same network.

I've created a remote user and granted it permissions, my server is using SELinux, but this is disabled so shouldn't be having any impact on connecting.

I can connect using the user through Sequel Pro

I've tried the following commands:

CREATE USER 'reports'@'%' IDENTIFIED BY 'my_password';
GRANT ALL PRIVILEGES ON * . * TO 'reports'@'%';
FLUSH PRIVILEGES;

What am I missing?

Ryan H
  • 1,979
  • 1
  • 19
  • 53
  • Does this answer your question? [MySQL: How to allow remote connection to mysql](https://stackoverflow.com/questions/14779104/mysql-how-to-allow-remote-connection-to-mysql) – Wahyu Kristianto Feb 11 '22 at 15:18

0 Answers0