Is it possible to connect to remote SQL?

[bWolfie]

Hi,

I've been trying to connect my server to a SQL database located on a different host.

I.e.

My server is located on Host 1 (11.11.11.11).

My SQL files are located on Host 2 (22.22.22.22).

I thought I had set everything up properly, but I receive the following error when trying to start the server:

(while starting server on host 1)

[SQL]: Access denied for user 'remote_user'@'11.11.11.11' (using password: YES)
I want to connect to 'remote_user'@'22.22.22.22'
Before delving further into this, is it even possible to host SQL files elsewhere while having your server files on a different host?

Thanks.

 

[Secrets]

Yes, the hostname setting for your database is there for a reason. You might want to check the permission and hostname setting for your MySQL user.

 

[Vy Low]

Hi,

I've been trying to connect my server to a SQL database located on a different host.

I.e.

My server is located on Host 1 (11.11.11.11).

My SQL files are located on Host 2 (22.22.22.22).

I thought I had set everything up properly, but I receive the following error when trying to start the server:

(while starting server on host 1)

[SQL]: Access denied for user 'remote_user'@'11.11.11.11' (using password: YES)
I want to connect to 'remote_user'@'22.22.22.22'
Before delving further into this, is it even possible to host SQL files elsewhere while having your server files on a different host?

Thanks.

Hello,

you just need to add privilege to 11.11.11.11 to your database in 22.22.22.22 so that it will grant access to your db