0

I was getting access denied for root@localhost. To resolve this, I stopped the mysql services, ran mysqld --install and mysqld --initialized, added skip-tables in the my.ini file and was able to log back in with the root user got the password to reset. Cleared the skipped-tables from the my.ini file. Flush the privileges, granted the root all access. Put in the command "show databases;" but it only shows these databases and its missing one.

information_schema mysql performance_schema sys

I looked at the my.ini file to see where the datadir was, looked at the path and I see the folder and the ibd file where the database resides, but it still does not show in MySQL. Any help on this would be greatly appreciated.

0

MySQL --initialize installs a clean data directory. It seems like that's what you got.

There may be a previous idb file there but its not connected to the database.

  • oh I see, is there a way to reconnect it? Or I just have to use the last mysql dump to load it up again? – Yodavish Feb 8 at 13:11
  • I also noticed that there are two MySQL services now, after the mysqsl --initialize. One called "MySql" the other "MySql80". – Yodavish Feb 8 at 14:06
  • Use your mysql backup. – danblack Feb 10 at 21:17

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.