Hi Peter,
There isn't any problem. If there was a problem, it is already fixed. Previously, MYSQL sever was working ok and then suddenly it just could not accept the password.
Even though now MYSQL can be connected, the schemas previously created are not there.
So, I'd like to know how to bring in these schemas with the tables already created before the breakdown.
I read about bringing in the tables in a very complicated way via :
https://dba.stackexchange.com/questions/71596/restoring-mysql-tables-from-ibd-frm-and-mysqllogbin-files
etc.
So, I thought the fastest way is just create the schema with different name without importing the tables, since I have the scripts.
In this case, do you suggest I can go ahead and delete the ibd tables or just don't touch them ?
Is there a workaround to bring in the existing schemas ?