1. Download Heidi Sql from here http://www.heidisql.com/download.php (Click the big Installer button)
2. Install the program to your computer
3. Open the program, you will now be faced with a "session manager" window.
4. Fill in the details accordingly
Network Type: MySQL (TCP/IP)
Hostname/IP: The IP address your game server is on
Prompt for credentials: Unticked
User: The username provided to you
Password: The password provided to you
Port: 3306 (unless specified)
Compressed client/server protocol: Unticked
Databases: Leave blank
Comment: Leave blank
5. Click open
Connecting to an SQL server using Heidi SQL
-
- Site Admin
- Posts: 681
- Joined: Sat Apr 20, 2013 11:16 pm
-
- Posts: 2
- Joined: Fri Apr 14, 2017 9:50 am
Re: Connecting to an SQL server using Heidi SQL
"Acces denied for user "Root"[email protected](My ip) (using password: yes)
I am using my own pc as mysql server
I am using my own pc as mysql server
-
- Posts: 1
- Joined: Sat Nov 05, 2016 3:09 pm
Re: Connecting to an SQL server using Heidi SQL
Is access to a SQL db still a thing for all games? I tried to use my current gamepanel credentials (custom user id and password, unlike the previous poster) with the instructions above, and got a quick "Access Denied" error. I run a TF2 server and AFAIK I'm not using the database, but I would like to if possible.
-
- Site Admin
- Posts: 681
- Joined: Sat Apr 20, 2013 11:16 pm
Re: Connecting to an SQL server using Heidi SQL
SQL access only applies to games that require an sql database by default. If you need a database I would suggest getting a free webhosting package from us.