MySQL Databases (39 Articles)

I cannot create views in MySQL

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: […]

How to change the MySQL timezone

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 SiteGround's servers is CST. This is a […]

How to optimize a MySQL database

One of the most important prerequisites for achieving optimal MySQL database performance is indexing. Indexing is an internal MySQL feature that allows faster gathering of data. Let's take an example […]