Hello,
I installed MYSQL 8 in my system. After that I am not able to connect via Toad.
Authentication method 'caching_sha2_password' not supported by any of the available plugins.
Like this error coming.Pls Provide the solution for this.
If you're using Toad Edge to connect to your MySQL database, then please re-post your question to the Toad Edge forum. e.g. so that other users can help you if they've run into a similar experience.
However, if you are attempting to use Toad for SQL Server, please be aware that Toad for SQL Server only support SQL Server databases. Use either Toad Edge (for MySQL) or Toad Data Point to connect to MySQL.
That said, if you ARE using either Toad Data Point or TOad Edge, you might want to get your DBA to take a look at the error first.
Hi,
I am using Toad for MYSQL ONLY Not Toad Edge.Here Toad for MYSQL category is not there so that only i posted in Toad for SQL SERVER Category.
Till MYSQL 5.7 Toad for MYSQL worked correctly, after Installed MYSQL 8 Only i got this error (Image Attached).Pls tell where to ask this solution for this issue.
Quest no longer offers or supports the Toad for MySQL product (since a few years back). Because of that, it's possible that the old product does not support the newer versions of MySQL.
Given that Toad Edge is the product that most have gravitated toward from the old Toad for MySQL, you might still want to post your question in the Toad Edge Forum, where ex-Toad-for-MySQL users may have some guidance for you.
Otherwise, I would take a look at Toad Edge for MySQL if you are doing developer type work on MySQL.
If analyst persona, you might want to take a look at Toad Data Point, which not only can connect to MySQL, but many other sources as well.
Toad Data Point still does not support MySQL 8.0 - they are still on 5.7. I have been using it for years, and it has become a serious problem for my company since Data Point's support for either MySQL or Mariadb are for versions that are no longer being supported and are many years out of date. I have had occasional contact with Quest where they promise that they are working on updating Data Point but have not been able to get a solid answer.
Basically, if you are looking for a SQL query editor/ reporting tool tool, you are better off looking elsewhere (And I have been using Toad products for SQL Server, MySQL and Mariadb since 2010, and am ready to quit).
As mentioned before, please look at Toad Edge for MySQL 8.x support. TDP already supports connecting to MySQL 8.x via ODBC, FYI, and more native support for MySQL 8.x is coming, though it's hard at times to nail down a specific release, especially if there are many priorities.
TDP is a very popular product and Quest is managing the priorities based on what we hear from our many customers.
Hang tight, and let's keep the forums helpful, not bash-ful, please.
BTW, in checking with Quest Development, you'll be happy to know that release 6.3 of TDP will have support for MySQL 8.x... release is due out in the next month or two. Stay tuned.
Gary, TDP 6.3 came out and sure enough, MySQL 8.0 is now supported (over 6 years after its release).
But MariaDB support has not been updated as was expected. TDP is still on 10.3 which is 7 years old now.
Please, please, please pass on to your developers - stop screwing around with toys like new pivot tables etc and concentrate on the most critical part of the product - compatibility!
The toys are nice-to-have. Lack of compatibility is undoubtedly costing you customers.
Appreciate your comments and feedback.
Will certainly let our Dev and Product Management teams know (they do participate on these forums, of course).
In general, the prioritization of features and enhancements within any of our solutions, as you probably already know, are largely driven by customer requests, and sometimes these can pre-empt adoption of support for latest versions of databases, especially if we don't see customers readily adopting those latest releases.
Anyway, PM and Dev teams have been notified of your commentary here.
THanks again!