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 support both the old and new password hashing for database users. Thus, if your MySQL client sees that we support both types, it may refuse connecting with an error like: Error about legacy type authentication (old-style) when connecting remotely to MySQL 2015-08-28 10-35-06 A workaround would be using a MySQL client such as MySQL WorkBench configured to accept Legacy connections. This can be done by following these steps: 1. Right-click on the database button. 2. Choose Edit connection. 3. Click Advanced. 4. Add useLegacyAuth=1 to the bottom of the 'Others' box. Alternatively, if you need to use some specific MySQL client that has no workaround to it, you can open a support ticket so our team can disable the legacy hashing support. 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...

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

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