Phone 1.877.423.1155
Need help? Contact us

Knowledgebase

Portal Home > Knowledgebase > MySQL and PostgreSQL


Can I connect to MySQL from my computer
Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...
Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
If you receive this error message when connecting to MySQL trough command line on your VPS...
Export and import MySQL databases via SSH
If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...
Export and import of MySQL databases from cPanel
For management on databases in your hosting account you can use the web application phpMyAdmin....
How to see the MySQL variables
Log into your MySQL database and type: show variables; You will see the following: mysql>...
Optimization and repair of MySQL database
If you have suspicions that the MySQL database is running slowly or appear errors, you need to...
Optimize MySQL database for more speed
If the MySQL database access times seems high and you feel a slow down you need to optimize your...
What is the version of MySQL
The installed version of MySQL on all shared web hosting, VPS hosting and dedicated servers is...
Which host and port to use to connect to MySQL
MySQL host (hostname): localhostMySQL port: 3306  
Language: