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