WampServer

mysql error 2003 (hy000) can't connect to mysql server on 'localhost' (10061)


does not start MySQL, I have already tried changing the port and restarting the service and it does not work

Well in that case you need to work out WHY it does not start before you try fixing it !!

Look at the error logs and if that tells you nothing look at the Windows Event Viewer for error messages from MySQL and if they dont mean anything to you, show them to us

Added by Otomatic:
You should also specify by doing what you get this error so that we know if it is a Wampserver problem or a problem in your script.
And, it would be nice to: READ (and answer) BEFORE YOU ASK A QUESTION

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



Edited 1 time(s). Last edit at 08/21/2019 07:43PM by Otomatic.

Windows 7 ultimate 32bits
Wamp Server 3.1.9 32 bits
Apache 2.4.39
Php 7.3.5
MySQL 5.7.26
MariaDB 10.3.14

Icon Orange

MySQL Error Log empty

Windows Event Viewer

Warning

Can't create test file d:\wamp32\bin\mysql\mysql5.7.26\data\Mihor-PC.lower-testFor more information, see Help and Support Center at [www.mysql.com].

Error

failed to set datadir to d:\wamp32\bin\mysql\mysql5.7.26\data\For more information, see Help and Support Center at [www.mysql.com].

Abort

phpMyAdmin work with MariaDB

Did you run the install using an Administrator account

How to Run As Administrator

If not, uninstall WAMPServer and the Install it again, properly.

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



Edited 1 time(s). Last edit at 08/21/2019 09:12PM by RiggsFolly.

Hi,

Andresser17 may have installed Wampserver on a factory formatted 4K Native type hard disk.

In which case Mysql will not be able to run on such a hard disk. We have already encountered this problem and it has still not been solved by Oracle.
In this case, the only solution is to disable MySQL (Right-click -> Wamp Settings -> Enable MySQL to uncheck) and use MariaDB instead by reassigning port 3306 to it.

How do I know if I have a 4K Native formatted disk?
- Open a command windows as an administrator (The word "administrator" must be in the tittle bar)
In this command windows type :

fsutil fsinfo ntfsinfo c: (c: is the drive with Wampserver)

If in the answer to this command there are:

Bytes per sector: 4096
Bytes per physical sector: 4096
or
Number of bytes per sector: 4096
Number of bytes per physical sector: 4096

is that it's a native 4K disk

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 08/22/2019 04:18PM by Otomatic.

Thanks for your help I already solved the problem, my D partition has permission issues, I changed the permissions on the wamp folder and reinstalled