[Solved] MySQL Error: Mouse drag operation failed

kevinf
 
on Nov 22, 2022 09:43 PM
618 Views

I go into MySQL workbench and the only collation I can find is right click table and select alter table then the link say to change utf8mb4 to Table default or delete utf8mb4 there is not table default or delete option help please

How do I change the utf8mb4 in all 3 databases and tables?

Tried your suggestion ran it on all my databases from MYSQL Workbench, went back to VS2019 tried creating dataset and RDLC report viewer report still has errors ? all other options work select Rows in tables in MYSQL reading updating sqldatasource all work see last code insert,  except RDLC and datasets  

ALTER DATABASE
database_name
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci;

Got error

Mouse drag operation failed.

Authentication to host licalhost for user grumpy using method caching_sha2_password failed with message

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Nov 24, 2022 05:45 AM

The issue is your project references an older version.

So, remove the MySql.Data reference, save the project and then re-add the reference to the version you have.

Then check.

For drag drop error check the link.

https://stackoverflow.com/questions/20056593/drag-and-drop-from-server-explorer-to-dataset-and-dbml-designer-not-working