Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Aug 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MDAC Updated - MySQL runs but nothing can connect

    Installing a program to test for my friend (maximizer) the damn thing messed with MDAC. I uninstalled it but obviously it didnt help. I have tried to uninstall mdac (no luck) and update it, update JET drivers, uninstall and reinstall mysql many times
    it just doesnt work.

    I am running windows nt 4 and i installed service pack 6 - still no help

    the server runs fine as i can telnet to the computer and it connects - even the winmysqladmin knows its up

    however everything from mysql.exe to my php pages cannot connect to the server even though its running

    i know its got something to do with that program messing with mdac drivers but i tried reinstalling the newest ones and it just wont work (and the old ones wont uninstall)

    any help is greatly appreciated as I need my database back up and running

    many thanks

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    Hi MySQL will function independantly from MDAC so that is not your problem (assuming you are just using PHP's native mysql functions to connect)

    ctrl-alt-del .. is mysqld-nt.exe showing in your process list ?

    if it is then its a problem with your connection routine in PHP OR you have a firewall that is messing with port 3306 which is the default port MySQL serves to.

    If mysqld-nt.exe is not showing up in your process list (or most network monitors will show its existance) , then open a command prompt and cd to your mysql\bin directory - type `mysql`and tell us what response you get.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    New to the CF scene
    Join Date
    Aug 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Well thats what i figured. I know you can create dsn connections using a mysql driver but my php board doesnt do this. The thing is though, that the errors started happening right after this windows MDAC update took place. Since then I have uninstalled and reinstalled mysql a few times to no avail.

    The winmysqladmin.exe connects to the server fine (yes it is running)
    i have tried stopping and starting it
    no use

    it is running
    just nothing aside from winmysqladmin can connect to it

    i can telnet to port 3306 and get a prompt so i know its working
    but everything else just tells me its not there

    im not running any firewall software


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •