Greetings all. Sorry if already posted. I've been out of state for a few months training for my new job and having to manage the DCS remotely. What I have found out by staying in three different hotels is that in addition to updating each new location's IP for remote authorization you also have to supply a new log-in and password to the SEOW database. I've noticed that creating a new ID/password or deleting and reloading the original works best. Just resetting the existing password doesn't appear to work.
I have also confirmed this through several other trouble reports posted on MySQL forums.
Hope this helps someone.
Remote Access to DCS
Moderator: SEOW Developers
-
- Posts: 142
- Joined: Sun 21 Jan 2007 10:20 am
- Location: Virginia, USA
- Contact:
-
- Posts: 2211
- Joined: Mon 08 Jan 2007 11:10 pm
- Location: Perth, Western Australia
Hi Thud,
I think your topic refers to remote connections to the DB server (MySQL) when using the DCS from different locations.
Unless your MySQL server is hidden behind CPanel, you should be able to set up a remote connection account that works from any location/host, e.g.:
login: seowremote@% (the % sign means "from any IP address")
password: whatever you like
If your MySQL is hidden behind CPanel, then yes you will need to add your new host address to the CPanel Remote MySQL whitelist first.
Cheers,
4S
I think your topic refers to remote connections to the DB server (MySQL) when using the DCS from different locations.
Unless your MySQL server is hidden behind CPanel, you should be able to set up a remote connection account that works from any location/host, e.g.:
login: seowremote@% (the % sign means "from any IP address")
password: whatever you like
If your MySQL is hidden behind CPanel, then yes you will need to add your new host address to the CPanel Remote MySQL whitelist first.
Cheers,
4S
IV/JG7_4Shades
SEOW Developer
SEOW Developer
-
- Posts: 142
- Joined: Sun 21 Jan 2007 10:20 am
- Location: Virginia, USA
- Contact:
Tutorial
Is there any tutorial on how to do this?
Remote control
I just created a user "seowremote@" with the % as instructed but how do i fill up the fields for connection in the DCS from the remote computer?
In the server address i put the external ip of the server, in server login name i put seowremote@ and the password and then the database name... But no connection... what am i doing wrong?
In the server address i put the external ip of the server, in server login name i put seowremote@ and the password and then the database name... But no connection... what am i doing wrong?
-
- Posts: 2211
- Joined: Mon 08 Jan 2007 11:10 pm
- Location: Perth, Western Australia
You don't need to establish a separate connection first, DCS is like any other application. However there are two issues:
1/ Can your PC connect the to remote MySQL server (router access, firewalls etc)?
2/ Do you have the correct login credentials to establish an authorized connection (password, database name, permissions etc)?
Cheers,
4S
1/ Can your PC connect the to remote MySQL server (router access, firewalls etc)?
2/ Do you have the correct login credentials to establish an authorized connection (password, database name, permissions etc)?
Cheers,
4S
IV/JG7_4Shades
SEOW Developer
SEOW Developer