How do I create a connection to a MYSQL database running on Ubuntu 20.04 on WSL2 on Windows 10?

spinozarabel's profile image spinozarabel posted 3 years ago in Creating a connection Permalink

Hi, I have a full Ubuntu linux 20.04 running on my Windows 10 machine using WSL. I can run Moodle, Wordpress etc., using localhost on my browser. Any ideas on how to connect to MYSQL in this scenario? Thanks, Madhu

spinozarabel's profile image spinozarabel posted 3 years ago Permalink

Solved. localhost works. My problem was that the MYSQL 8.0 root user was disabled due to a blank authentication plugin. I had to go into safe mode and 1st update the plugin and then after restarting into normal mode and entering with blank password, update the root password with an ALTER statement as documented in MYSQL 8.0. There are plenty of forum posts that misguided me and only going to the source documentation helped solve my problem.

Please login to leave a reply, or register at first.