I can not login to phpMyAdmin.
Posted by: Fierabras (---.virtua.com.br)
Date: April 27, 2020 10:07PM

I am using wampserver 3.2.0
I launched phpMy Admin from wampserver using root and no password then it gives this error:
Error in processing request
Error code: 200
Error text: OK (rejected)
It seems that the connection to server has been lost.
Please check your network connectivity and server status.



MySQL said:

Error
SQL query:
SELECT CHARACTER_SET_NAME AS Charset, DESCRIPTION AS Description
FROM information_schema . CHARACTER_SETS

MySQL said: Documentation As Description FROM information_schema . CHARACTER_SETS
#1143 - SELECT command denied to user
'mysql.infoschema'@'localhost' for column
'default_collation_id' in table 'character_sets'


Thanks for your help

Options: ReplyQuote
Re: I can not login to phpMyAdmin.
Posted by: Otomatic (Moderator)
Date: April 27, 2020 10:50PM

Hi,

What versions of Apache, PHP, MySQL, MariaDB, PhpMyAdmin ?

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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: I can not login to phpMyAdmin.
Posted by: Fierabras (---.virtua.com.br)
Date: April 28, 2020 01:25AM

Hello:

Apache: 2.4.41
PHP: 7.3.12
MySQL: 8.0.18
Mariadb: 10.4.10
phpMyAdmin: 4.9.2

Options: ReplyQuote
Re: I can not login to phpMyAdmin.
Posted by: Otomatic (Moderator)
Date: April 28, 2020 08:52AM

Hi,

Do you have access to the MySQL and MariaDB consoles?

Left-click -> MySQL -> MySQL Console

Left-click -> MariaDB -> MariaDB Console

Leave the default root user and, when prompted for a password, press Enter.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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: I can not login to phpMyAdmin.
Posted by: Fierabras (---.virtua.com.br)
Date: April 28, 2020 03:21PM

Hello:

This is the result of MySQL console:

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 8.0.18 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>


This is the result of MariaDB console:


Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.10-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>


Thanks.

Options: ReplyQuote
Re: I can not login to phpMyAdmin.
Posted by: Otomatic (Moderator)
Date: April 28, 2020 03:36PM

Hi,

MySQL and MariaDB connections are correct.

Try with a newer version of PhpMyAdmin 4.9.5 or 5.0.2

Both versions are available on http://wampserver.aviatechno.net

First install version 5.0.2 by answering yes to remove existing versions and then install version 4.9.5 by choosing Add to existing versions.

You will have the choice to launch one or the other from 'http://localhost/'.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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


Sorry, only registered users may post in this forum.