docker for mac cant connect wordpress to mysql

Docker Cant Connect Wordpress To Mysql How To Fix WordPress

I ended up installing another dmg from here for version 5.7. So I downgraded. Loading.

Docker Cant Connect Wordpress To Mysql How To Fix WordPress

In this article I will show how to fix WordPress database connection for MySQL 8.

As many recently have experienced this resulted in my WordPress sites showing this error message.

MySQL 8 have changed from using native encryption for passwords to a more standardized approaches.

As a matter of fact, this change happened even earlier, in release 5.7.

However, in MySQL 8 the team changed default value of defaultauthenticationplugin configuration variable from previous mysqlnativepassword to cachingsha2password.

What this means is that when a client connects to MySQL without specifying which password encryption method it uses MySQL assumes it to be using cachingsha2password.

But most of clients currently in use are assuming to use mysqlnativepassword.

In this guide we will be changing MySQL configuration file, so lets back it up first.

I always recommend using current date and backup sequence number in backup names to easier identify them and being able to keep multiple backups from before: sudo cp etcmy.cnf etcmy.cnf.backup.20181027.001.

After this you need to restart MySQL server process: sudo systemctl restart mysqld.

Please let me know in the comments if this solution helped you to fix wordpress database connection for MySQL 8 Share this: Facebook LinkedIn Reddit Twitter Like this: Like Loading.

I dont know is it was becasue we are running MySQL and WordPress on a Windows OS, but we had to drop and re-create our WordPress user in MySQL becasue the authentication method is stored as part of the user setup and I had created the user on the new server before I found your fix.

Re-creating the user after changing the defaultauthenticationplugin setting in my.ini meant that the user was then created with mysqlnativepassword as the user default.

That is the problem with PHP because at the time of me writing this article PHP still did not implement new password hashing options that MySQL was telling everyone about for a good few years.

I mean it is not like they did this silently, they actually were saying that this will be a new default in MySQL8, but seems PHP developers are unprepared for that.

Upgrading to PHP 7.2 should work, but only after they finished their implementation: Loading.

I loosely recall the prompts asking about password encryption during MySQL 8 but just blasted through it foolishly.

Moving forward I will read everything extremely carefully on updates.

What version of MySQL you have installed Is it stock MySQL Or is it MariaDB You need to note that on newer systems when you try to install MySQL from default repositories, it will instead install MariaDB.

And MariaDB while started off as a fork of MySQL has diverted away already enough to NOT make them equal.

I removed it and put 5.4 instead and worked right away as usual.

So I dont think it was anything to do with how I installed it.

I think they changed something or something else was happening.

I ended up installing another dmg from here for version 5.7.

So I downgraded. Loading.

Docker For Mac Cant Connect Wordpress To Mysql