External Database Access - STILL NEED HELP..
-
DrStigHD
- New to forums
- Posts: 13
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sun Feb 14, 2016 9:25 am
External Database Access - STILL NEED HELP..
I am using MySQL to connect to my database internally however i need to access the database externally (From my own computer) I had trouble with this last time but since i have gotten a new VPS, i need help with connecting externally and setting up a panel (already have the panel need sql info help)
-
Caliban55
- This is my homepage
- Posts: 439
- Joined: Sat Sep 04, 2010 10:20 am
- Location: Cologne, Gemany
- Contact:
Re: External Database Access - STILL NEED HELP..
I hope you got rid of XAMPP in any form...
To connect to your MySQL server, you can use MySQL Workbench, which is in the package for the community server, if you choose to install it (recommended!). You can then download the MySQL Workbench tool on you home computer and connect to the MySQL server from there (or any client).
The user that accesses the database has to be whitelisted (and please do never use the root user for either running the database, or external connections) and needs permissions to for that particular database schema. That is all that is required.
MySQL Workbench Download
http://dev.mysql.com/downloads/workbench/
To connect to your MySQL server, you can use MySQL Workbench, which is in the package for the community server, if you choose to install it (recommended!). You can then download the MySQL Workbench tool on you home computer and connect to the MySQL server from there (or any client).
The user that accesses the database has to be whitelisted (and please do never use the root user for either running the database, or external connections) and needs permissions to for that particular database schema. That is all that is required.
MySQL Workbench Download
http://dev.mysql.com/downloads/workbench/