Can't sign in using root.
Posted by: jeberlan (104.129.204.---)
Date: July 22, 2016 08:02PM

1 - Windows version 7 sevice pak 1 64-bit
2 - Version WampServer3 64-bit
3 - Apache Version 2.4.18
4 - PHP Version 5.6.19
5 - MySQL Version 5.7.11
6 - WampServer icon Green

Downloaded the Wampserver3 package yesterday. Installed no problem, no changes; straight install.
Server Running
PHP working
PHPinfo() looks good
phpmyadmin working, but I can't sign in using root. #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I've uninstalled and reinstalled both 32bit wamp and 64bit wamp. No change.

Even tried this to set the password to a value, no change: [dev.mysql.com]

Options: ReplyQuote
Re: Can't sign in using root.
Posted by: RiggsFolly (Moderator)
Date: July 23, 2016 12:20AM

The root password is blank after the initial install.

Use username = root
password = blank

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<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: Can't sign in using root.
Posted by: jeberlan (165.225.34.---)
Date: July 23, 2016 12:48AM

Yes, and as I stated with " (using password: NO)" I indicated that I attempted to sign in with a blank password.

It did not work.

Options: ReplyQuote
Re: Can't sign in using root.
Posted by: RiggsFolly (Moderator)
Date: July 23, 2016 09:26AM

Then it is likely that you have 2 MYSQL Servers installed on your system, and the one that did not come with WAMPServer is starting automatically and therefore is the one being used.This other one will have a password set for the root account.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<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: Can't sign in using root.
Posted by: jeberlan (165.225.32.---)
Date: July 23, 2016 09:57PM

Nailed it.

I had a previous version of WinLAMP installed and had faith that the uninstall would remove it all.

Many Thanks.

Sometimes when the door won't open all you can manage to see is the handle.

Options: ReplyQuote


Sorry, only registered users may post in this forum.