Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 6 of 6
  1. #1
    Senior Member toadeny's Avatar
    Join Date
    May 2003
    Location
    Wellington, New Zealand
    Posts
    188
    Member #
    1426
    I have a weird problem with mysql

    I have a server running in my house that hosts the net and has apache, php and mysql running on it. I have been having some problems with mysql of late.

    This problem I have only happens when I restart the server, has happened twice.

    I type in the ip and I get

    Code:
     Warning: mysql_connect(): Can't connect to MySQL server
     on 'localhost' (10061) in c:\apache\htdocs\links\functions.php
     on line 14
    Could Not Connect To Database
    I try to connect to mysql via command prompt and when I start the service it says its fine. I stop the service and it says it wasn’t started to begin with.

    I try from \mysql\bin\ to connect:

    Code:
    mysql –u root
    I get error 2003 Can't connect to MySQL server on 'localhost' (10061)

    Can anyone shed some light on this ?!

    I have restarted the server twice in 4 weeks, and have since forgotten if I did something to fix it ??? I dunno

  2.  

  3. #2
    JR
    JR is offline
    Senior Member JR's Avatar
    Join Date
    Nov 2002
    Location
    UK
    Posts
    4,354
    Member #
    257
    No Idea. Maybe try doing a clean install and follow filburt's tutorial.
    JR

  4. #3
    Senior Member rosland's Avatar
    Join Date
    Jul 2003
    Location
    Norway
    Posts
    1,944
    Member #
    2096
    I did a search on Google and found a similar post somwhere else. The reply that fixed his problem (this was a windows installation though, don't know if you can access the files like this on linux if that's your OS).
    I am running mysql on windows XP and fixed this error by going into
    c:\mysql\bin and rightclicking the "mysqld" file and choosing run as.
    Choose the first option (current user etc..) and hit ok
    If that doesn't work, there were some additional info here
    S. Rosland

  5. #4
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,656
    Member #
    1234
    Liked
    137 times
    Originally posted by toadeny
    Code:
     Warning: mysql_connect(): Can't connect to MySQL server
     on 'localhost' (10061) in c:\apache\htdocs\links\functions.php
     on line 14
    Could Not Connect To Database
    Yep, he's running Windows
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com

  6. #5
    Senior Member rosland's Avatar
    Join Date
    Jul 2003
    Location
    Norway
    Posts
    1,944
    Member #
    2096
    Of course he is. :dead:
    S. Rosland

  7. #6
    Senior Member toadeny's Avatar
    Join Date
    May 2003
    Location
    Wellington, New Zealand
    Posts
    188
    Member #
    1426
    None of that worked.

    I can install the service, and start it, it then stops on its own after about 5 secs...

    I get the error Cannot connect to mysql server on localhost port 10061 when i try mysql -u root in the \mysql\bin directory.

    This is fully annoying me no end. i have uninstalled and installed mysql over and over.

    I feel the only remedy is to format my server....
    any ideas


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:53 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com