Ofc 4G is enough for high online.

Windows consumes more memory, about stability, I guess there is no big deal. So, you can take any os you want. Yeah, Navicat and remote connection (tunneling) is ok to manage. 

All right then.

 

Thank yo guys for the answers and support.

 

Topic can be locked.

Ok, if u have more questions open new topic. Locked.

21 hours ago, Horse said:

and I assume i can use navicat on my pc to remotely connect to the database on on the VPS or dedi. Or is it a bad idea for any reason?

About that, you have to keep in mind that allowing remote access to your dedi/vps database means that if for instance somehow someone got the db details (usually the db name will be the default one from the pack and most users their user/pass is user root/pass none or pass root) anyone knowing the db details can connect to your database remotely, making this option unsafe. Just keep it in mind.

 

p.s. Thanks @Nightw0lf for noticing that you didn't get a reply on that.

It's like saying don't provide your PayPal / email address to people, otherwise they will crack your ass. It's not even worth to mention.

To allow tunneling you create new username and it's obvious you set some wild or not database password. Database name, username and passwords it's up to you. You can always allow connection from specific ip. 

So.. Pointless note to be honest. :D

25 minutes ago, SweeTs said:

It's like saying don't provide your PayPal / email address to people, otherwise they will crack your ass. It's not even worth to mention.

To allow tunneling you create new username and it's obvious you set some wild or not database password. Database name, username and passwords it's up to you. You can always allow connection from specific ip. 

So.. Pointless note to be honest. :D

Well, unfortunately not everybody knows that, i've seen this a lot of times while creating websites with scripts having the same details as the ones in the server configs because they didn't know about that ;p

3 hours ago, Designatix said:

i've seen this a lot of times while creating websites with scripts having the same details as the ones in the server configs because they didn't know about that ;p

That's fine to the moment you set your own username and strong password. Even with default database name, root user, while you use strong password that's OK. Cracking 16 chars password with symbols, letters, upper case.. Would take years, so.. :p

1 minute ago, SweeTs said:

That's fine to the moment you set your own username and strong password. Even with default database name, root user, while you use strong password that's OK. Cracking 16 chars password with symbols, letters, upper case.. Would take years, so.. :p

The most used info i've ever seen are "user: root pass: root" XD

2 hours ago, Designatix said:

The most used info i've ever seen are "user: root pass: root" XD

I believe they leave like that to don't give you the real pass / it's still under preparation, no live, so defaults can stay for a while :D

Otherwise you work with total newbies and they deserve to be 'hacked' :(