Articles

 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 Change a MySQL Database Users Password in cPanel

How to Change a MySQL Database Users Password in cPanel? First you should log in to the cPanel...

 How to Manage a MySQL Database with phpMyAdmin in cPanel

How to Manage a MySQL Database with phpMyAdmin in cPanel? In order to manage a MySQL database...

 How to assign a user to a MySQL database in cPanel

How to assign a user to a MySQL database in cPanel? First you need to log in to the cPanel...

 How to check a MySQL database for errors in cPanel

How to check a MySQL database for errors in cPanel? First of all log in to the cPanel by using...

 How to create a MySQL database in cPanel

How to create a MySQL database in cPanel? First you need to log in to the cPanel while using...

 How to create a MySQL database user in cPanel

How to create a MySQL database user in cPanel? Log in to the cPanel while using username and...

 How to delete a MySQL database in cPanel

How to delete a MySQL database in cPanel? First you need to log in to the cPanel while using...

 How to delete a MySQL database user in cPanel

How to delete a MySQL database user in cPanel? Once you log in to the cPanel while using your...

 How to remove a user from a MySQL database in cPanel

How to remove a user from a MySQL database in cPanel? You need to log in to the cPanel while...

 How to repair a MySQL database in cPanel

How to repair a MySQL database in cPanel? In order to repair a MySQL database in cPanel, you...

 How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...

 How to setup a database using the MySQL Database Wizard in cPanel

How to setup a database using the MySQL Database Wizard in cPanel? Login to your cPanel...

 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