Cannot log in to the MySQL server - 2
Posted by: bunak (---.50.90.212.it-tv.org)
Date: March 19, 2017 08:33PM

Hi

1. I have new install of Windows 10, 64 bit.
I installed
Visual C++ Redistributable for Visual Studio 2012 Update 4 (BOTH x86 and x64)
Visual C++ Redistributable Packages for Visual Studio 2013 (BOTH x86 and x64)
Visual C++ Redistributable Packages for Visual Studio 2015 Update 3(BOTH x86 and x64)

2-5. Install Wampserver 3.0.6 (apache2.4.23, mysql5.7.14, php5.6.25) now on new system. It is Wampserver 3.0.6 64 bit x64 – Apache 2.4.23 – PHP 5.6.25/7.0.10 – MySQL 5.7.14 – PhpMyAdmin 4.6.4 – Adminer 4.2.5 – PhpSysInfo 3.2.5

6. Wampserver is green

7.
# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost
::1 localhost

8. I have access to localhost (Homepage WampServer)
8a. No any errors

9. I have access to phpMyAdmin. BUT I CAN NOT LOG INTO MySQL!
10.
11. Have not Antivirus. Only included to Windows 10.
12. c:\wamp64\
13. Virtual Hosts are is default of WampServer 3.0

But I'm unable to log into MySQL via PHPMyAdmin and mysql console too. I have error
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Also I have many warnings and errors for mysql such as here - [forums.mysql.com]
There are some of them
2017-03-19T19:08:05.833812Z 0 [Warning] System table 'plugin' is expected to be transactional.
2017-03-19T19:08:05.836789Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-03-19T19:08:05.840800Z 0 [Warning] Failed to open optimizer cost constant tables

2017-03-19T19:08:05.886922Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2017-03-19T19:08:05.886922Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2017-03-19T19:08:05.886922Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2017-03-19T19:08:05.887925Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2017-03-19T19:08:05.888928Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2017-03-19T19:08:05.907978Z 0 [Warning] System table 'servers' is expected to be transactional.
2017-03-19T19:08:05.921013Z 0 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.



Edited 1 time(s). Last edit at 03/19/2017 08:38PM by bunak.

Options: ReplyQuote
Re: Cannot log in to the MySQL server - 2
Posted by: RiggsFolly (Moderator)
Date: March 19, 2017 08:46PM

Hi

Is this a vanilla WAMPServer or have you changed anything or added any databases?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Cannot log in to the MySQL server - 2
Posted by: bunak (---.50.90.212.it-tv.org)
Date: March 19, 2017 08:55PM

Hmmm
I remove wampserver3.0.6_x64_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10.exe
and install 32 bit WampServer - wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10.exe
All is good



Edited 1 time(s). Last edit at 03/19/2017 08:55PM by bunak.

Options: ReplyQuote
Re: Cannot log in to the MySQL server - 2
Posted by: bunak (---.50.90.212.it-tv.org)
Date: March 19, 2017 09:01PM

RiggsFolly Wrote:
-------------------------------------------------------
> Hi
>
> Is this a vanilla WAMPServer or have you changed
> anything or added any databases?

You are right - the problem is in my old databases. If I change my.ini datadir-path to my databases the error will happen!!!! Even in wampserver3.0.6_x86



Edited 1 time(s). Last edit at 03/19/2017 09:13PM by bunak.

Options: ReplyQuote
Re: Cannot log in to the MySQL server - 2
Posted by: RiggsFolly (Moderator)
Date: March 20, 2017 01:47AM

So I am guessing that the old databases were not created by the version of MYSQL that is in WAMPServer.

You cannot just point at the old datbases, you must backup the old databases using the old version of MYSQL and restore them in the new version.

What version of MYSQL were the old databases created with?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Cannot log in to the MySQL server - 2
Posted by: bunak (---.50.90.212.it-tv.org)
Date: March 20, 2017 02:44PM

Thank you, RiggsFolly, and don't worry.
I resolve my problems. The topic is need close

The errors and warnings are because i try use my old mysql and system_perfomences databases from old MySQL from WampServer 2.5.x (about 2013-2014 year production).

I still use WampServer 3.0.6 32 bit. And think is it good idea reinstall WampServer 3.0.6 to 64 bit version? - see [forum.wampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.