Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: TripMX (---.dynamic.kbronet.com.tw)
Date: August 14, 2016 10:09AM

Hello, a month ago, I had installed WampServer on my Windows 10 computer.

I have installed all necessary files, and the WampServer icon is GREEN.

MY SIMPLE GOAL: Have a local test server environment on my PC so that I can practice and simulate using server-sided languages like PHP. Examples: A simple user registration and login, sending data from client to server and vice versa, etc. basic operations.

THE BIG PROBLEM: I click on phpMyAdmin, and then try to login like this:

USERNAME: root
PASSWORD: [blank]



 Cannot log in to the MySQL server

^: Then I get this error.


So, I went to C:\wamp64\apps\phpmyadmin4.5.2\config.inc.php and opened the file:

<?php

/* Servers configuration */
$i = 0;

$cfg['blowfish_secret'] = 'a8b7c6d'; //What you want

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'Local Databases';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

// Hidden databases in PhpMyAdmin left panel
// $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|sys)';

// Allow connection without password
$cfg['Servers'][$i]['AllowNoPassword'] = true;

// Suppress Warning about pmadb tables
$cfg['PmaNoRelation_DisableWarning'] = true;

// To have PRIMARY & INDEX in table structure export
$cfg['Export']['sql_drop_table'] = true;
$cfg['Export']['sql_if_not_exists'] = true;

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.7/en/';
/* End of servers configuration */

?>


^: From this, I noticed that both user and password are BLANK, so I decided to go back to phpMyAdmin and try to login with BOTH username and password BLANK......but when I pressed the GO button, nothing happened.


What should I do to fix this problem?

Thanks in advance!

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: Otomatic (Moderator)
Date: August 14, 2016 03:02PM

Hi,

After installation of Wampserver (all versions) or PhpMyAdmin (all versions) the user is "root" with no password.
--- Launch phpMyAdmin
When starting phpMyAdmin, you will be asked for a user name and password.
After installing Wampserver 3, the default username is "root" (without quotes) and there is no password, which means that you must leave the form Password box empty.

If it does not work, it means that after installing Wampserver
- MySQL users be amended
or
- added a password to "root".

Try to open MySql console :
- Wampmanager icon -> MySQL -> MySQL console. As there is no password to root, juts use the Enter key when password is asked. You should have a console windows like:
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.14 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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>

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.9 32 bit - Apache 2.4.54 - PHP 8.1.8…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.9 64 bit - Apache 2.4.54 - PHP 8.1.8…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.15/10.7.3
PhPMyadmin 5.1.3 - 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: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: TripMX (---.dynamic.kbronet.com.tw)
Date: August 15, 2016 12:59AM

Hello Otomatic, I've already tried the MySQL console....I pressed the ENTER key, and it INSTANTLY closed out in the blink of an eye. I think it also may have had an "Access Denied" message.

The only thing that I haven't tried was the MySQL amendment thing....how to get "amended"?

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: RiggsFolly (Moderator)
Date: August 15, 2016 01:03AM

Then you probably have 2 MYSQL Server instances installed on your system

The other one has a password attached to the root userid.

Until you know what you are doing I suggest you uninstall the other MYSQL After backing up any batabases you may want to keep Just in case you dont keep regular backups already!

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: TripMX (---.dynamic.kbronet.com.tw)
Date: August 16, 2016 11:14AM

RiggsFolly Wrote:
-------------------------------------------------------
> Then you probably have 2 MYSQL Server instances
> installed on your system
>
> The other one has a password attached to the root
> userid.
>
> Until you know what you are doing I suggest you
> uninstall the other MYSQL After backing up any
> batabases you may want to keep
Just in case
> you dont keep regular backups already!


Hi again, the only mySQL server program I have installed on my computer is Wampserver. I'll just uninstall Wampserver completely and re-install it....hopefully, this would solve the problem.

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: RiggsFolly (Moderator)
Date: August 16, 2016 12:16PM

Some Applications come with their own version of MYSQL, it may not always be obvious that you have another version on your system.

Best way to work it out is to lok at the Services Snapin

CTRL+R
Enter services.msc
Press OK button


WAMPServer's MySQL is called `wampmysqld` or `wampmysqld64`

If you see a service in the list called MYSQL then it is not from WAMPServer and is another instance of MYSQL that is probably started at boot time and will always take presidence over WAMPServers MYSQL which is manually started when you launch WMAPSeerver

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: TripMX (---.dynamic.kbronet.com.tw)
Date: August 16, 2016 12:39PM

RiggsFolly Wrote:
-------------------------------------------------------
> Some Applications come with their own version of
> MYSQL, it may not always be obvious that you have
> another version on your system.
>
> Best way to work it out is to lok at the Services
> Snapin
>
> CTRL+R
> Enter services.msc
> Press OK button
>
>
> WAMPServer's MySQL is called `wampmysqld` or
> `wampmysqld64`
>
> If you see a service in the list called MYSQL then
> it is not from WAMPServer and is another instance
> of MYSQL that is probably started at boot time and
> will always take presidence over WAMPServers MYSQL
> which is manually started when you launch
> WMAPSeerver



Hello again RiggsFolly, on my Windows PC, I pressed WindowButton + R and accessed the services.msc

This is what I found for WAMPServer's presence:

wampapache64
wampmysqld64

^: Both are RUNNING.

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: RiggsFolly (Moderator)
Date: August 16, 2016 04:43PM

YES.....

But did you also find a service called MYSQL?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: TripMX (---.dynamic.kbronet.com.tw)
Date: August 16, 2016 05:52PM

NOPE.....

There are no services called MYSQL in the list.

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: RiggsFolly (Moderator)
Date: August 16, 2016 06:26PM

We nevre did ascertain what version you were running.

I assume WAMPServer 3.0.something and as phpMyAdmin was an ADDON I also assume you applied this version on top of .something

Can I suggest you download the latest phpMyAdmin ADDON v4.6.3 and see if that fixes anything, but only if I am right about you having V3.0.something

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 08/16/2016 06:28PM by RiggsFolly.

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: TripMX (---.dynamic.kbronet.com.tw)
Date: August 16, 2016 10:12PM

RiggsFolly Wrote:
-------------------------------------------------------
> We nevre did ascertain what version you were
> running.
>
> I assume WAMPServer 3.0.something and as
> phpMyAdmin was an ADDON I also assume you applied
> this version on top of .something
>
> Can I suggest you download the latest phpMyAdmin
> ADDON v4.6.3 and see if that fixes anything, but
> only if I am right about you having V3.0.something


Okay, I just checked the installation file name:

FILENAME: wampserver3_x64_apache2.4.17_mysql5.7.9_php5.6.16_php7.0.0


....I suppose it's outdated? Then I should uninstall everything, then download and install the latest version, right?

Options: ReplyQuote
Re: Cannot login to phpMyAdmin, PLEASE HELP!
Posted by: RiggsFolly (Moderator)
Date: August 16, 2016 10:39PM

Thanks

Uninstall NOT NECESSARY any more with WAMPServer 3

Most things are now ADDONS i.e. install over base V3 install.

See here for the downloads [wampserver.aviatechno.net]

I suggest you apply V3.0.5 its a straight upgrade over existing V3.0.0

Then take your pick of versions of Apache/MYSQL/PHP that you might want to have available to switch between.

Always suggest taking a backup of the complete \wamp folder before doing any sort of update though of course

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.