[Help] Accessing Database From Home Computer [Navicat]

[Clit]

How do you set up so I can access my VPS hotel database from Navicat on my home compueter. I know that it is possible because I have done it before.

 

[HabPRO]

Make a user with host % and grant all privileges. Make sure you allow port 3306 on your VPS firewall to access your database anytime using that user. Use a strong username & password to prevent someone from randomly accessing it.

 

[Clit]

Host %?

 

[HabPRO]

When you make a new user, it ask for host, put % there instead of localhost.

 

[Kaz]

If you have done it before, then why cant you do it now?

 

[HabPRO]

If you have done it before, then why cant you do it now?

He could of forgotten how to do it.

 

[Clit]

If you have done it before, then why cant you do it now?

Been awhile & forgot. Well I'm doing something wrong.

 

[Clit]

So this is my home navicat:

this is my vps navicat:

Is this correct? :\
Cause still isn't working.

 

[HabPRO]

So this is my home navicat:

this is my vps navicat:

Is this correct? :\
Cause still isn't working.

All is well.

 

[Clit]

Okay, Got it! Thank-You!

 

[HabPRO]

Welcome. Glad it worked all well for you.

 

[Stabby]

dont put % put youre ip adress of youre computer you can see it on

You must be registered for see links

if you use % any ip can connect to phpadmin if they know youre user and pass....

 

[HabPRO]

dont put % put youre ip adress of youre computer you can see it on

You must be registered for see links

if you use % any ip can connect to phpadmin if they know youre user and pass....

Not unless if he uses a strong username and password that is almost impossible to guess. And putting % means the user can be accessed through any IP.
And he will also need to portforward 3306. This was solved already.

 

[Stabby]

Not unless if he uses a strong username and password that is almost impossible to guess. And putting % means the user can be accessed through any IP.
And he will also need to portforward 3306. This was solved already.

I know that LOL......