How to fix Authentication method caching_sha2_password not supported by any of the available plugins in Visual Studio
Authentication method caching_sha2_password not supported by any of the available plugins.
How can I fix this? or do I need to use another SQL Server?
I don't know what's the problem if it's the installation of MySQL Server
or just the code I'm using, I also added MySQL.Data on the reference still not working.
This is the code:
Imports MySql.Data.MySqlClient
Public Class PIS
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
cn.ConnectionString = "server=localhost; userid=circuit; password=password; database=pis;"
cn.Open()
MsgBox("Connected")
switchpanel(search)
End Sub
End Class
Solution
I solved the problem by updating .NET FRAMEWORK target value to 4.5.2
- How do I restore a dump file from mysqldump?
- Cannot log in to the MySQL server (PhpMyAdmin)
- Create advanced search in JPA through user defined dynamic where clause conditions
- Mysql command not found in OS X 10.7
- How can I improve DELETE FROM performance on large InnoDB tables?
- Altering table to add column before specific column
- Why does my SQL while(set.next()) skips the first element?
- mySQL breaks when adding a var
- How I can set a session in codeigniter 3 database?
- Drizzle ORM not support Insert Returning
- Peewe upgrade causing weired autocommit behaviour
- Remote MySQL database connection Laravel 5 not working
- How to link 3 SQL tables and pass 0 value if the value is NULL
- How to ignore certain MySQL tables when importing a database?
- Retrieve just one column from MySQL query results
- Multiple mysql INSERT statements in one query php
- Can anyone please explain this solution of hacker rank Binary Tree Nodes?
- Golang using lowercase for first letter in Struct property
- Laravel Livewire Search Issue With Space
- List filtering of users, returns empty object
- Python 'timestamp' cannot be converted to a MySQL type
- Exclude records that have 3 or more dates within a series of date columns
- write data to MySQL
- Drop MySQL databases matching some wildcard?
- How to export Mysql (big) table to CSV using laravel?
- MySQL LIKE statement supporting multiple queries
- multiple connections in CodeIgniter are very slow - how to speed up
- Emulating PARTITION OVER with MySQL 5.7
- How can I rebuild indexes and update stats in MySQL innoDB?
- Can't execute a MySQL stored procedure from JDBC