Phpmyadmin help

Question

I’ve been trying to setup phpmyadmin for about 2 weeks now and it keeps showing the same errors on my Mac. Could anyone please help me get into it?

Answer 1

Hey Rob Curcio, so far the searches I did mostly signaled that there is a compatibility problem in authentication that prevents PHP from communicating with MySQL (I looked up that error message). But still am not sure because you didn't provide enough information (PHP, MySQL, phpMyAdmin versions) and whether you get that error only on phpMyAdmin or on all your PHP codes. Anyways, I'm passing you this link in a hope one of the answers there can help you:

https://stackoverflow.com/questions/49948350/phpmyadmin-on-mysql-8-0

Hope you find the solution : )

Answer 2

You're welcome Rob Curcio, but have you tried any of the proposed solution in that forum?, I saw some responses there from Mac users too.

I'm not familiar with Mac products, but if you're willing to try, perhaps you can head to https://www.apachefriends.org/index.html to download and install XAMPP, it's a software package containing Apache, PHP, MariaDB (free version of MySQL) with this package you don't need to install each software individually.

I'm not sure about versions, but I presume iMac & MacBook runs on OSX? I see there is a package for OSX on that site, hope it works for you. Mind that you may need to uninstall your current installation of PHP and MySQL should you choose to install XAMPP, just to avoid possible conflict between installations.

Good luck!

Answer 3

Thank you for searching for me, I have the latest verisions of php, mysql snd phpmyadmin installed on my iMac abd Macbook. localhost works and so does php code because I can go to the php info page in an info.php file I created to test it. Is there any other ways to use php and use another database server?

Answer 4

Thank you so much and appreicate tge feedback! I have heard of XAMPP, I’ll take a look later on. I’m glad there’s a friendly envirenment on here to guide others. Keep it up! 👍🏻

Answer 5

Is there a way I can show the picture of the errors and what it looks ljke? It uses apache and php, which I already setup to get in. For some reason it keeps showing this and also tried to change the config file.

Answer 6

The error says “mysql_real_connection(): The server requested authentication method unkown to the client (caching_sha2_password)”

The other is “ mysql_real_connection(): (HY000/2054): The server requested authentication method unknown to the client”.