Date: Thu, 28 Mar 2024 20:53:23 +0100 (CET) Message-ID: <1018707482.29.1711655603685@confluence-8.glowhost.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_28_1213517536.1711655603684" ------=_Part_28_1213517536.1711655603684 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Some of you may wish to us=
e tools like MySQL Front and MySQL Maestro to access your cPanel databases =
from your desktop instead of using PHPMyAdmin which comes preinstalled on y=
our site with the latest stable version, and is constantly updated for thos=
e of you who did not know we had it in there for you.
Here is how to set them up:
Fi=
rst go to this page and get your IP address:
https://glowhost.com/web-hosting-technical-support/what-is-my=
-ip.html
Put that on your clipboard and login=
to your cPanel > MySQL and all the way at the bottom is a part for remo=
te access hosts. Put your IP in there. If you get a new IP every time you l=
og on to the Internet from your ISP then you may wish to put a % sign at th=
e end of your IP which will act as wildcards allowing access from 0-255. So=
for example:
123.456.789.% or 123.456.%.%=
but be warned you are now allowing remote access to your databases from lo=
ts of people! it were mine I would not allow any access hosts but my own IP=
if I had to use one of these tools to connect, then remove it after I was =
done with the session for the most secure way to do it remotely.
For MySQL Front:
1. On the General Tab it will ask for Login Information, with one te=
xt box. That is your cPanel username.
2. O=
n the connection tab it will ask for:
Serv=
er
Port
Connection type
TimeoutCompression
You can keep all the defaults. The only thing it asks for is the Serv=
er. Type in yourdomain.com (not http://yourdomain.com)
3. Next is the Login tab. =
It asks for:
User
Password
database
So, assuming you are familiar with how to set =
your databases up in cPanel, then it would look something like this:=
User: cpanelusername_databaseusername
Password:=
your database user's password
Database: cpanelusername_databasename
4. The cache tab does not need anything messed =
with.
M=
ySQL Maestro is qui=
te a bit easier to configure.
Click on "re=
gister existing database"
Your hostname is yourdomain.com
Username: c=
panelusername_databaseuser
Password: your database user's password<=
br style=3D"text-align: left;">
Don't forget to add yourself as an access host a=
s we did above or you will not be able to connect.
N=
avicat is also quit=
e easy to configure
Connection Name: Somet=
hing to remember your database by.Hostname/IP Address: yourdomain.com=
Username: cpanelusername_databaseuser
Password: your database user's pas=
sword
Don't forget to add yourself as an a=
ccess host as we did above or you will not be able to connect.
TROUBLESHOOTING
If you cannot connect, there can be several reasons:
1. You did not add yourself as an allowed re=
mote access host in he database manager in your cPanel control panel.
2. You are behind a firewall. Temporarily disab=
le all software and hardware firewalls, and try again. If you can connect t=
his way, re-enable your firewalls and reconfigure them to allow for the mys=
ql port 3306
3. You have typed in your dat=
abase username or database username's password incorrectly. Double check th=
is in your configuration script.
4. You ar=
e trying to connect to "yourdomain.com" instead of your actual domain n=
ame. Replace yourdomain.com in the examples above with your real websi=
te's domain name.