Jump to content
  • 0
Sign in to follow this  
bWolfie

Is it possible to connect to remote SQL?

Question

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 by True Zeal

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

 

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.