‘1064 – You have an error in your SQL syntax’ error in phpMyAdmin

Sometimes, when you try to modify a database in phpMyAdmin, you can get this error message when you try to execute the SQL query:

MySQL said:  
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...

This is a known issue in cPanel which occurs when you access your cPanel via the Access cPanel Normally button in your Customer Area.

In other words, this issue appears when you access your cPanel using the cPanel proxy, i.e:

http://cpanel.sitegroundXXX.com

In order to avoid it, please access your cPanel via:

http://yourdomain.com/cpanel

or using the Access cPanel Securely button in your Customer Area.

If the above doesn't help, you should check the syntax of the query you are trying to execute and make sure it is correct.

cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to export/import a MySQL database via SSH

In this article we will show you how to export and import a MySQL database via SSH. Managing your...

Error about legacy type authentication (old-style) when connecting remotely to MySQL

This particular error can occur in some MySQL clients. The reason for it is that our servers...

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 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...

I cannot create views in MySQL

Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...