SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2002
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MSQL cmdline fails, but works with phpMyAdmin

    This may be a bit off-topic for this group, but, I've had no luck in the MySQL forums / newsgroups.

    I can access MySQL on my WinME (phpTriad) install no problem from PHP scripts & phpMyAdmin. However, when I try (now -- worked before) from a DOS commandline it fails:
    Code:
    >mysqladmin -p status
    Enter password: ******
    C:\APACHE\MYSQL\BIN\MYSQLA~1.EXE: connect to server at 'localhost' failed
    error: 'Can't connect to MySQL server on 'localhost' (10050)'
    Check that mysqld is running on localhost and that the port is 3306.
    You can check this by doing 'telnet localhost 3306'
    So, I tried telnet localhost 3306, but it displays some garbage, then tells me, 'bad handshake' error.

    Obviously something is mis-configured for TCP/IP? Any idea on what I need to check?

    If it helps, I've looked at c:\windows\my.ini to see if there is anything obvious there -- tried uncommenting the port=3306:
    Code:
    [WinMySQLAdmin]
    Server=C:/APACHE/MYSQL/bin/mysqld-opt.exe
    user=root
    password=*****
    
    [mysqld]
    basedir=C:/APACHE/MYSQL
    #bind-address=24.52.28.166
    datadir=C:/APACHE/MYSQL/data
    #language=C:/APACHE/MYSQL/share/your language directory
    #slow query log#=
    #tmpdir#=
    port=3306
    #set-variable=key_buffer=16M
    WinMySQLAdmin runs and reports no errors, but also shows no useful information (never did):

    TIA
    http://davidvancamp.com
    http://patterndigest.com

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to a more appropriate forum

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


Bookmarks

Posting Permissions

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