Is it possible to connect to remote SQL?

[bWolfie 138]

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.

Edited November 9, 2016 by True Zeal

[Secrets 2]

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 11]

 

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