WampServer

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.

Hi

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

---------------------------------------------------------------------------------------------
(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-

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.

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.

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 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-

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]