MySQL connection lost on local PC install (Error #2003)
-
“Error MySQL said: #2003 – Can’t connect to MySQL server on ‘localhost’ (10061)
Connection for controluser as defined in your configuration failed.”I’m looking to run WP local on desktop machine…
1. Download/unzip/install Xamp – SUCCESSFUL
> No problems2. MODIFY CONFIG FILE – POSSIBLY SUCCESSFUL
Modified c:\xampplite\htdocs\wordpress\wp-config.php several ways:
> leaving all at “default” values
>> define(‘DB_NAME’, ‘wordpress’);
>> also tried with … define(‘DB_NAME’, ‘Iputmydomainhere’);>> define(‘DB_USER’, ‘root’);
>> define(‘DB_PASSWORD’, ”);
>> also tried with define(‘DB_PASSWORD’, ‘mypasswordhere’);>> define(‘DB_HOST’, ”);
>> also tried with define(‘DB_HOST’, ‘127.0.0.1’);3. START Apache – SUCCESSFUL
Successfully getting “Running” when click START button for Apache4. Status on XAMPP for Windows – FAILS
MySQL dtabase – Deactivated*** ???
PHP activated
HTTPS activated
CGI activated
SSI activated5. phpMyAdmin – FAILS
“Error MySQL said: #2003 – Can’t connect to MySQL server on ‘localhost’ (10061)
Connection for controluser as defined in your configuration failed.”6. START MySQL — FAILS
In XAMPP when click START button for MySQL it displays “Running” for 7 seconds then not running (“Running” disappears). Window below shows “MySQL started” then “Busy…”7. phpMyAdmin – FAILS
When open browser to :https://localhost/phpmyadmin/NOTES:
I’m guessing I either don’t have MySQL installed, installed correctly, or can’t get to it correctly, or other. Running XP SP3. Downloaded WP 2.8.4 – not upgrading just yet.I do not see IIS in Administrative Services — but I understood from the notes that IIS should be disabled anyway.
Also I do not see a MySQL service… if there’s supposed to be one?
Thanks – any help appreciated
LINKS I’VE CHECKED AGAINST:
https://www.ads-software.com/support/topic/335778?replies=5
https://www.ads-software.com/support/topic/246026?replies=25
https://www.ads-software.com/support/topic/338580?replies=6https://www.makeuseof.com/tag/building-your-own-local-wordpress-blog/
https://weblogtoolscollection.com/archives/category/how-to/
https://codex.www.ads-software.com/Resetting_Your_Password#Through_phpMyAdmin
https://www.puremango.co.uk/2009/01/wamp_97/
- The topic ‘MySQL connection lost on local PC install (Error #2003)’ is closed to new replies.