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