How to enable root access for mysql after installation of the server?
Answers
Answered by
3
______✨ HEY MATE ✨________
➡️I tried following what answers to other question here on SO suggested but most of them require access to mysql shell.
➡️I also tried to reconfigure using sudo dpkg-reconfigure mysql-server-5.5 (my version number is 5.5.41).
➡️Using this I am able to set the root password but still can't connect it. I also tried running mysql in safe mode, as suggested by some user, with no luck.
➡️Last thing I could think of was somehow renable the remote access for root, since I can reset it's password, and then reset the user password through mysql shell. So, I tried looking the /etc/mysql/my.cnf file but didn't see anything relevant.
✌️ I THINK IT HELPED YOU ✌️
➡️I tried following what answers to other question here on SO suggested but most of them require access to mysql shell.
➡️I also tried to reconfigure using sudo dpkg-reconfigure mysql-server-5.5 (my version number is 5.5.41).
➡️Using this I am able to set the root password but still can't connect it. I also tried running mysql in safe mode, as suggested by some user, with no luck.
➡️Last thing I could think of was somehow renable the remote access for root, since I can reset it's password, and then reset the user password through mysql shell. So, I tried looking the /etc/mysql/my.cnf file but didn't see anything relevant.
✌️ I THINK IT HELPED YOU ✌️
Similar questions