MySQL 8 with PHPMyAdmin (Login with root)
Posted by: AmiAmigo (---.neo.res.rr.com)
Date: August 20, 2022 02:33AM

I am having a problem accessing PHPMyAdmin with username: root and no password. I can access MySQL Console with those credentials but they fail when using PHPMyAdmin. Thanks

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: Otomatic (Moderator)
Date: August 20, 2022 08:37AM

What are the versions of :
- Wampserver
- PHP
- PhpMyAdmin
- MySQL

What is the exact and complete error message?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 08/20/2022 11:46AM by Otomatic.

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: AmiAmigo (143.105.19.---)
Date: August 29, 2022 06:28PM

Sorry for a late reply, message went to spam folder. Here is more info:

WampServer: Release version 3.2.4.2 64 Bits
PHP: 7.4.26
PHPMyAdmin: 5.1.1
MySQL: 8.0.27


Error Message 1: Cannot log in to the MySQL Server

Error Message 2: mysqli:real_connect(): (HY000/1045): Access denied for user root@localhost (using password: No)

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: Otomatic (Moderator)
Date: August 30, 2022 08:28AM

Hi,

- 1 - Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
Do not use a previously loaded tool. Make a new download to make sure you are using the correct version.
To download missing packages, do not rely on Microsoft links, they are not reliable, download packages on http://wampserver.aviatechno.net in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.

- 2 - Apply Update 3.2.9 to your version of Wampserver
Wampserver update 3.2.9

- 3 - Install PhpMyAdmin 5.2.0

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: AmiAmigo (143.105.19.---)
Date: August 30, 2022 08:07PM

Ok. Thanks. Will try that.

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: DJMarvin54 (---.us-east-2.compute.amazonaws.com)
Date: September 30, 2022 08:30PM

Not sure if I need to start a new post. I had to update my PHP to 8.0.24 to get WordPress to work properly. The version (v 5.0.2) of PHPMyAdmin I currently have installed is not compatible with PHP 8.0.4 so I need to update PHPMyAdmin to 5.2.0 as indicated in this thread. Before I run the PhpMyAdmin 5.2.0 install (wampserver3_x86_x64_phpmyadmin5.2.0.exe) as administrator and verifying my Visual C++ Redistributable Packages are all there, are there any special requirements I need in place before I install phpmyadmin 5.2.0?

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: Otomatic (Moderator)
Date: September 30, 2022 09:04PM

Let's Go

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 09/30/2022 09:57PM by Otomatic.

Options: ReplyQuote
Re: MySQL 8 with PHPMyAdmin (Login with root)
Posted by: DJMarvin54 (---.us-east-2.compute.amazonaws.com)
Date: September 30, 2022 10:28PM

My French is extremely rusty but:

Merci

Options: ReplyQuote


Sorry, only registered users may post in this forum.