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?

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.10 32 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.10 64 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »



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

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.10 32 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.10 64 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

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


Sorry, only registered users may post in this forum.