mysql error 2003
Posted by: Andresser17 (190.200.16.---)
Date: August 21, 2019 06:02PM

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

Options: ReplyQuote
Re: mysql error 2003
Posted by: RiggsFolly (Moderator)
Date: August 21, 2019 07:29PM

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

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.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

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

Options: ReplyQuote
Re: mysql error 2003
Posted by: Andresser17 (190.200.16.---)
Date: August 21, 2019 08:54PM

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

Options: ReplyQuote
Re: mysql error 2003
Posted by: RiggsFolly (Moderator)
Date: August 21, 2019 09:12PM

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.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

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

Options: ReplyQuote
Re: mysql error 2003
Posted by: Otomatic (Moderator)
Date: August 22, 2019 03:09PM

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

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.9/7.2.22/7.1.32/7.0.33/5.6.40 - MySQL 5.7.27 - MariaDB 10.4.7
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.9/7.2.22/7.1.32/7.0.33/5.6.40 - MySQL 5.7.27/8.0.17 - MariaDB 10.4.7
PhPMyadmin 4.9.0.1 - 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 »



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

Options: ReplyQuote
Re: mysql error 2003
Posted by: Andresser17 (190.200.92.---)
Date: August 22, 2019 11:21PM

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.