External Database Access

[DrStigHD]

I am using MySQL to connect to my database internally however i need to access the database externally (From my own computer) The current login information does not have a username or password and when i try connect externally, it says https://gyazo.com/2c47bc66e0ee55a67a0fadf714c78fb6 Can i have some help?

[soja]

Is the database on NFO's webhosting? If so, is "allow external connections" checked?

[DrStigHD]

No, it is MySQL on the VPS

[soja]

How are you managing it, through CLI or an administration tool like phpmyadmin? You need to allow your IP addresses access to whatever user you are trying to log in as.

[DrStigHD]

I am using XAMPP, im hosting an arma 3 server

[soja]

First off, xampp isn't very good and you should really install your own app stack or secure your xampp installtion.

Xampp came with phpmyadmin, use that to add your home IP address to the root user.

[DrStigHD]

Sorry, i do not know what you mean, im new to the VPS side of stuff, do you think you could come to teamspeak?
92.222.200.121:10199

[DrStigHD]

First off, xampp isn't very good and you should really install your own app stack or secure your xampp installtion.

Xampp came with phpmyadmin, use that to add your home IP address to the root user.

Could you come?

[soja]

sorry I can't. You can add me on steam and I could try to help from there.

[DrStigHD]

I added you

[DrStigHD]

DRHDGaming is my name

[DrStigHD]

It was fixed, database got fucked so im needing help again, anyone willing to help?

[DrStigHD]

Still needing help....

[Edge100x]

What do you mean by "got fucked"?

Have you tried deleting and recreating the database?

[DrStigHD]

No, basically I'm trying to set up something called a white listing panel for arma 3 and each time I get the same error. I believe it is something to do with the database but it may be something to do with the web host. Last time the guy who replied came on teamviewer and sorted it for me but now it's a new VPS