How do I connect a Heidisql database to Visual Studio using Report Viewer packages?

Question

Follow the code of my comic book from Heidisql:

CREATE DATABASE ProdPacote;  
USE ProdPacote;

CREATE TABLE Produto(  
ID_Produto INT PRIMARY KEY AUTO_INCREMENT,  
Nome VARCHAR (200) NOT NULL,  
Descricao VARCHAR (200) NOT NULL,  
Preco DOUBLE NOT NULL);  

CREATE TABLE Pacote(  
ID_Pacote INT PRIMARY KEY AUTO_INCREMENT,  
Nome VARCHAR (200) NOT NULL,  
ID_Produto VARCHAR (200) NOT NULL,  
Quantidade INT NOT NULL,  
Data_entrada DATE NOT NULL,  
Data_saida DATE NOT NULL);  


CREATE TABLE Produto_Pacote(  
ID_Produto_Pacote INT PRIMARY KEY AUTO_INCREMENT,  
Data_Hora DATE NOT NULL,  
FK_ID_Produto INT NOT NULL,  
FK_ID_Pacote INT NOT NULL,  

CONSTRAINT Produto_Pacote  
FOREIGN KEY (FK_ID_Produto)  
REFERENCES Produto (ID_Produto),  

CONSTRAINT Pacote_Produto  
FOREIGN KEY(FK_ID_Pacote)  
REFERENCES Pacote(ID_Pacote)); 

That particular mistake won’t let me continue:

ERROR MESSAGE: Authentication to host 'localhost' for user 'root' method using 'mysql_native_password' failed with message: Access denied for user "root" @"localhost" (using password: YES)

Answer 1

I had the same problem a few months ago, I followed this process and solved, detail I used specific versions and so I do not guarantee that it works in different versions. The process below solves the following errors:

1. "Some updating Commands could not be generated Automatically. The database returned the following error: Unexpected Error"
2. Error: Failed to open a Connection to the database "Cannot obtain Provider Factory for data Provider named 'Mysql.Data.Mysqlclient'. " Check the conection and Try Again.

PROPOSED SOLUTION:

1. Uninstall "Connector /Net" and "Mysql for Visual Studio" if installed.
2. Install "Mysql for Visual Studio v1.2.7" . NOTE: Install Mysql for Visual Studio before Connector / Net.
3. Install "Connector / Net V6.9.8".
4. Try to carry out the process you need.

Unfortunately working with Mysql in VS is quite complicated, many errors only solve with specific versions and often the problem even solves, but another appears.