close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How do I get MySQL to work so my testing site can be set up?

Thread began 1/28/2015 1:36 am by anonymous | Last modified 1/29/2015 11:09 pm by Wolfie | 793 views | 4 replies |

anonymous

How do I get MySQL to work so my testing site can be set up?

Hey there,

I followed your tutorial for installed XAMPP to the letter. I also followed the instructions at this URL to modify the ports since I was getting ports in use errors:

http://www.zeeronsolutions.com/fix-xampp-apache-not-starting-because-port-80-in-use-issue/

I changed Apache's ports to 1234 & 1443 and MySQLs port to 3307
I'm accessing localhost via this URL: http://localhost:1234

But I still can't get MySQL to work.

1. In the XAMPP Control Panel, Service for MySQL is checked green and I can click Start and it goes to "Status change detected: running..." I thought this meant all was good BUT

2. I go to this URL: http://localhost:1234/xampp/index.php and I get erros trying to acces security and phpMyAdmin

I get this error with phpMyAdmin:

Error
MySQL said:
#2002 - No connection could be made because the target machine actively refused it.
The server is not responding (or the local server's socket is not correctly configured).

I get this error with security:

MYSQL SECTION: "ROOT" PASSWORD
MySQL SuperUser:
root
The MySQL server is not running or is blocked by a firewall! Please check this problem first ...

So the control panel shows green and running but the localhost interface is throwing errors. I've checked my Windows Firewall and the Apache and MySQL apps are allowed.

I've searched for hours and read dozens of websites for a solution and nothing is working. I have no idea what to do. Please help!

Sign in to reply to this post

Jason ByrnesWebAssist

First thing to look at is any fire wall you have set up, it may be that there is a fire wall setting blocking communication on the ports you are trying to use.

if you still have a problem after disabling your fire wall, I would go to the Apache friends forum. They are more geared to troubleshooting XAMPP than this forum is.

I found this similar thread over there:
https://community.apachefriends.org/f/viewtopic.php?f=16&t=47645

Sign in to reply to this post

anonymous

Hey jason,

As I noted above, I already validated that my firewall wasn't causing the issue, using that exact link too lol. I changed all of the ports to very random ones so there would be no conflicts. And read almost every article in that forum and tried every suggestion. I'm at a total wall now w this though I was going to try to uninstall and reinstall everything. Just not able to give that a try til the WA extension error I posted on another ticket/blog is figured out since I can't use WA at the moment. Any other thoughts?

Sign in to reply to this post

Jason ByrnesWebAssist

the apache friends forum i linked to is the best place to get help troubleshooting issues with XAMPP.

I suggest posting your issue over there.

Sign in to reply to this post

Wolfie

ok. thanks

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...