Access your MS Sql or MySql with Heidi SQL
Posted by Vipin Nehra on 15 April 2016 07:20 PM
- Open Heidi SQL.
- Click New.
- Name the connection. Hit the enter key.
- Enter your connection settings. The settings should be like the following.
Network type: MySQL (TCP/IP). [for MS Sql use MS SQL (TCP/IP)]
Hostname / IP: You use your domain name or your server IP address.
User: Your cPanel username or the database user you created.
Password: Your cPanel password or the password for the database user.
Port: 3306. [1433 for MS SQL] NOTE: These are default ports they can be different
Databases: Leave as Separated by Semicolon.
Startup Script: Leave it blank.
- Click Open.
Now you will see the databases and tables on your server.