Author Archives: Obaydullah Likhon

The MySQL trigger is a database object that is associated with a table. It will be activated when a defined action is executed for the table. The trigger can be executed when you run one of the following MySQL statements … Continued

A database index is a data structure that improves the speed of operations in a table. Every time your web application runs a database query, the database will look through all the rows in your table to find those that … Continued

MySQL database size limitations are applied for all shared hosting plans, in order to ensure fair resource usage. The limitations are as follows: StartUp – 500 MB GrowBig – 750 MB GoGeek – 1000 MB If a database on your … Continued

If you want to connect to your database from an application or a script on your XonHost hosting account, you can simply use localhost as MySQL hostname. If you’re accessing your database from a remote server, you need to grant it access … Continued

There are two ways of exporting a MySQL database from your account: You can export it via the cPanel -> phpMyAdmin tool. You can find information how to do that in our tutorial here. You can perform the export by accessing your account via SSH. Our article explains … Continued

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

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

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

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

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