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.

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
3
  • 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, 2019 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, 2019 at 14:06
  • Use your mysql backup.
    – danblack
    Feb 10, 2019 at 21:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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