Articles
The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...
Can I create new databases in phpMyAdmin?On Siteground's servers you are not able to create a new database directly from phpMyAdmin. This...
Do you support ODBC for MySQL on Linux?Unfortunately we do not support the ODBC driver for MySQl on our hosting plans. cPanel is easy...
Error about legacy type authentication (old-style) when connecting remotely to MySQLThis particular error can occur in some MySQL clients. The reason for it is that our servers...
How can I change my MySQL database collation?Usually you will be interested in changing your MySQL collation in order to solve problems with...
How can I configure DreamWeaver to connect to MySQL database?SiteGround does allow remote applications to connect to its MySQL servers. The exact instructions...
How can I create a MySQL database?n order to create a new MySQL database please check this part of our mysql tutorial. or check...
How can I empty a MySQL database?The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select...
How can I import a large database to my account? PhpMyAdmin times out.For importing large databases we recommend using tools such as MySQL Workbench. Before being...
How to access phpMyAdmin directly from my domain?n order to access phpMyAdmin directly from: http://yourdomain.com/phpmyadmin you need to...
How to back up a MySQL database?You can backup a MySQL database through phpMyAdmin. For detailed instructions on how to do this...
How to change the MySQL timezoneWhen you develop your website, you may have to compare a certain date/time with the current...
How to change the collation for all tables in a MySQL database to UTF-8?Changing the collation for all tables in a MySQL database can be time consuming depending on how...
How to change the database engine of a MySQL database table?In this article we will show you how to change the database engine of a MySQL table. Let's...
How to change the password of a Mysql user in cPanel?If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...
How to check the MySQL version on the server hosting my account?You can check the MySQL version using the mysqli_get_server_info function. To do this, you should...
How to export a large database using phpMyAdmin?If you have a large database, it may be difficult to export all of its tables at once through...
How to export/import a MySQL database via SSHIn this article we will show you how to export and import a MySQL database via SSH. Managing your...
How to optimize a MySQL databaseOne of the most important prerequisites for achieving optimal MySQL database performance is...
How to optimize a MySQL database using phpMyAdmin?It is always a good idea to keep your databases' tables optimized. Fortunately, making this...
How to repair a MySQL database?In this article we will show you two ways to repair a MySQL database. Through cPanel: Log in to...
How to reset the password for a MySQL database?You may need to change the password of your database in order to improve the security of your...
How to restore my database?If you have a backup of your database, you can easily restore it via the phpMyAdmin tool...
How to use MySQL stored procedures and routines?MySQL stored procedures and stored routines are supported after MySQL 5. All SiteGround clients...
I cannot create views in MySQLRegular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...
I don’t have enough privileges for creating/dropping databases in PhpMyAdminYour user does not have enough privileges for creating or dropping databases in PhpMyAdmin...
I get an error ‘ACCESS DENIED CREATE DATABASE db_name’ when I try to import a databaseIn order to solve this issue follow these steps: Open the MySQL dump with a text editor on...
I get syntax error when trying to run a MySQL query.This error indicates that the syntax of your query is not correct. Reasons for incorrect mysql...
I have problems accessing my MySQL database remotelyIf you have problems accessing your database at your web hosting account remotely please make...
I have problems setting up the MySQL database for my applicationIf you have problems setting up the mysql database for your application please make sure that:...
Internal error encountered (Cannot connect to user_database)The most common reason for this issue is a corrupted SiteBuilder database. The possible solutions...
I’m getting a ‘Server shutdown in progress’ MySQL errorThere are two main reasons for this error message to show: 1) The MySQL query you are trying to...
Multi-language applications and UTF-8 databasesBy default, the databases on SiteGround's servers are created with latin1_swedish_ci collation....
PHP script for MySQL database importYou should start by creating a file called for example import.php and placing it in your...
What are MySQL triggers and how to use them?he MySQL trigger is a database object that is associated with a table. It will be activated when...
What is the default path to the MySQL binary?The correct path to the MySQL binary at all hostlantern servers is: /usr/bin/mysql cPanel is...
What is the information_schema database?n MySQL version 5.02 and above there is an additional database called information_schema. This...
What type of databases do you support? PGSQL and MySQL?All Siteground servers support MySQL and PostgreSQL databases. Also with any of our hosting...
‘1064 – You have an error in your SQL syntax’ error in phpMyAdminSometimes, when you try to modify a database in phpMyAdmin, you can get this error message when...
