Hello, I recently built my unraid server, so pretty new. Here is the link to my first post:

 

I pretty much have everything up and running as I want, except that I want to setup a local wordpress site for cooking and recipes. I installed Apache-PHP, and MariaDB, and to my surprise, phpmyadmin is not included in either, nor is there a convenient docker under community apps. It looks like their is a docker that would have to be installed via the more manual method, but that's where I get lost. 

 

Does anyone know of a guide or tutorial on how to get phpmyadmin setup on unraid?

 

Thanks!

 

 

I guess I'm not too hopeful on this. There are a few previous posts on installing phpmyadmin with either no responses or no resolution:

 

Do i need to setup a VM just for a small wordpress site? 

Edited December 12, 20187 yr by Jason442

Jason, Did you ever figure this out. I'm in the same boat.

 

Thanks, Richard

Worked for me using the official phpmyadmin container.  I can throw up a template if youd like.

I am also baffled about how to get to the phpmyadmin WebUI after installing the docker...I attached the Advanced View of my Container template and notice that phpmyadmin is the only docker not pointing to 10.0.195.2 and that has no port assigned.

@bender1, you offered to throw up your template...would you mind?

On 1/28/2019 at 7:19 AM, bender1 said:

Worked for me using the official phpmyadmin container.  I can throw up a template if youd like.

did anyone ever figure this out?

theres really nothing to it.  Just use the official image (phpmyadmin/phpmyadmin).  Add the variable for PMA_HOST and map the port. 

Edited March 13, 20197 yr by bender1

With MySQL 8, I'm getting the below error. It's a known issue but I can't figure out a way to change the default back to mysql_native_password. Is there a way via extra parameters or post arguments? 

The server requested authentication method unknown to the client [caching_sha2_password]

 

On 9/21/2019 at 10:10 AM, pokmiuhy said:

With MySQL 8, I'm getting the below error. It's a known issue but I can't figure out a way to change the default back to mysql_native_password. Is there a way via extra parameters or post arguments? 

The server requested authentication method unknown to the client [caching_sha2_password]

 

I have the same problem. Did you ever get this resolved?

 

 

On 10/21/2019 at 5:55 PM, David Ramones said:

I have the same problem. Did you ever get this resolved?

 

 

You can use the ALTER command to change the encryption of the password to mysql_native_password instead of the latest authentication plugin caching_sha2_password. I executed the below and it's now working. Not sure if this is the right way or just a work around, but it's working for me.

 

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';