SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Minnesota, USA
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Changing Password - Not Working!

    Hello,

    I have Apache2, PHP5, and mySQL4 installed on this Windows XP SP1 machine (testing only). I want to change the mySQL password, but when I type:

    cd C:\Server\mySQL4\bin
    mysqladmin -u root password 'my-password';

    It says:

    mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to database on MySQL server on 'localhost' <10061>' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306'

    So I type:

    telnet localhost 3306

    And it says:

    Connecting To localhost...Could not open connection to the host, on port 3306: Connect failed

    Anyone know what is wrong or how I might go about fixing this?

    Thanks!

  2. #2
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    mysqld is not running.

    try the following:

    C:\Server\mySQL4\bin\mysqld

    You will have to open another command prompt window and type your mysql password commands.

    Hope that helps!

  3. #3
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Minnesota, USA
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Hartmann
    mysqld is not running.

    try the following:

    C:\Server\mySQL4\bin\mysqld

    You will have to open another command prompt window and type your mysql password commands.

    Hope that helps!
    Well, I was in a PHP chat room and someone said something like this. I tried it and it opened a window. Now when I do it, it doesn't do anything. But if I go into the folder and double click, the screen pops up and then goes away really quick.

    Any ideas? Thanks..

  4. #4
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Well if the screen comes up and goes away then mysqld is probably running so you can try your change password commands in a new prompt.

  5. #5
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Minnesota, USA
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay, so first I execute C:\Server\mySQL4\bin\mysqld.exe and the black command prompt window pops up and goes away.

    Then I enter the command prompt and type:

    cd C:\Server\mySQL4\bin
    mysqladmin -u root password 'my-password';

    It still does the same thing as in the first post! When I type "mysqladmin" the list of commands comes up (I don't know if that is of any significance).

    Any ideas? Thanks...

  6. #6
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Minnesota, USA
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I figured it out -- I created a shortcut to mysqld.exe. Thanks!

  7. #7
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Glad to hear you got it working!

  8. #8
    SitePoint Member
    Join Date
    Aug 2004
    Location
    Abuja
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Where are the .cnf files in Windows installation?

  9. #9
    Non-Member
    Join Date
    Jan 2004
    Location
    Planet Earth
    Posts
    1,764
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I figured it out
    I had the exact same problem earlier today, though I couldn't figure it all out, even though I followed the steps suggested here

    Nothing important was on the server, so I just uninstalled it, and reinstalled it again

    Now working as it was, perfect.

    Off Topic:


    Slightly off topic, though I was about to start another thread, may I impose myself on your thread instead ?


    How do I prevent someone accessing the database server via

    Code:
    c:\mysql>mysql
    Doing that allows anyone to basically to do what ever they want with the server, as far as I know ?

    What do I need to do, so MySQL returns an error message, asking for a username and password. This has been bugging me for a while now, and I'd like to know if there is a solution.

    Looked at the on line docs though nothing suggests a solution yet


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
  •