MySQL Databases

The easiest way to change the password for your MySQL user is to: Log in your cPanel -> MySQL Databases. Find the corresponding database and see which is the user attached to it. For example we will consider that your database is called yourusername_database and … Continued

In order to solve this issue follow these steps: Open the MySQL backup with a text editor on your local computer. Delete the line saying “CREATE DATABASE yourdbname“. Usually this line is found at the very beginning of the file. … Continued

The phpMyAdmin tool available in cPanel is bundled with it and can be used only if you are already logged into cPanel. To use phpMyAdmin outside of cPanel, you can install it on a Addon domain, a Subdomain, or in … Continued

If you have problems setting up the MySQL database for your application please make sure that: Your application is using the correct mysql hostname: localhost Your application is using the correct mysql database / username / password. Make sure you have … Continued

Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE VIEW with a regular user, you will receive the following error message: #1142 – CREATE VIEW command denied to user ‘user’@’localhost’ for … Continued

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin … Continued

MySQL stored procedures and stored routines are supported after MySQL 5. All XonHost clients can use MySQL stored procedures and routines on their web hosting accounts. To use stored procedures, you should first create a database and add a database user to it. Make sure that … Continued

If you have problems accessing your database at your web hosting account remotely please make sure that: You are using the correct MySQL hostname – it should be yourdomain.com or your server’s name; You are using the correct MySQL database / username … Continued

When you develop your website, you may have to compare a certain date/time with the current date/time on the server. The timezone on XonHost’s servers is CST, CEST or SGT, depending on the location you have chosen for your account … Continued

On XonHost’s servers you are not able to create a new database directly from phpMyAdmin. This can be done only through cPanel’s MySQL management tool. For more information check this tutorial. You can also watch cPanel’s video tutorial for additional information.