Professional Web Applications Themes

Lost ability to logon .. how can I recover (revised)? - MySQL

Hi All, I've been running WinXP-Pro/SP2 with MySQL 5.0.15-nt for at least six months. I'm running under an Administrator account on my own machine at home and have sole access to it. I've had K:\_Utilities\MySQL\MySQL Server 5.0\My.cnf set up for all that time as: [client] host=localhost port=3306 user=root password=[snip] Today, I was setting up Ruby-on-Rails stuff so I could change, in just one line, the base-name for a suite of development/test/production databases and then: (1) generate a proper .yml file to tell a Rails app the database names/attributes (2) generate a set of drop/create/grant SQL statements for those databases (3) ...

  1. #1

    Default Lost ability to logon .. how can I recover (revised)?

    Hi All,

    I've been running WinXP-Pro/SP2 with MySQL 5.0.15-nt for at least six
    months. I'm running under an Administrator account on my own machine
    at home and have sole access to it.

    I've had K:\_Utilities\MySQL\MySQL Server 5.0\My.cnf set up for all
    that time as:

    [client]

    host=localhost
    port=3306
    user=root
    password=[snip]

    Today, I was setting up Ruby-on-Rails stuff so I could change, in just
    one line, the base-name for a suite of development/test/production
    databases and then:

    (1) generate a proper .yml file to tell a Rails app the database
    names/attributes
    (2) generate a set of drop/create/grant SQL statements for those
    databases
    (3) use a one-line command to direct MySQL to create the suite of
    databases.

    It all worked great except MySQL now refuses to grant access to root
    using my password.
    I didn't change nor forget my password ... its my same developer
    password I've used for decades.
    Rebooting Windows didn't improve the situation.

    - Control Panel Services says MySQL is started.
    - Task Manager Applications says MySQL Server 5.0 is running
    - The vanilla command "mysql" (which used to work) reports:
    ERROR 1045 (28000): Access denied for user 'root''localhost'
    (using password: YES)
    - Ditto for the command "mysql -uroot -p" with my subsequently entered
    password(which used to work)

    The only thing unusual this time is that I fired up MySQL Front and
    fumbled around with it (because I hardly ever use it). It didn't seem
    to do anything flaky and hasn't ever caused any problem heretofore.

    Is un/re-install of MySQL likely to get it working again. Is safe to
    copy into a new installation some saved database directories from my
    current configuration.

    Any ideas would be greatly appreciated.

    Regards,
    Richard

    Richard Guest

  2. #2

    Default Re: Lost ability to logon .. how can I recover (revised)?

    Hi again,

    I should add that I cannot open any database using MySQL Front, as I
    had earlier in this session. In all cases, I now get
    "Zugriffsverletzung", German for "access violation".

    Regards,
    Richard

    Richard Guest

  3. #3

    Default Re: Lost ability to logon .. how can I recover (revised)?


    Hi again,

    I finally got a new instance installed and running. I don't know why I
    had so much trouble doing it, but I'm a happy camper now.

    Regards,
    Richard

    Richard Guest

Similar Threads

  1. Why we lost ability to edit one page
    By emzee5 in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: October 7th, 02:50 PM
  2. recover lost password
    By Jean-Pierre Radley in forum SCO
    Replies: 3
    Last Post: July 29th, 05:25 PM
  3. lost ability to drag icons
    By Kevin McMurtrie in forum Mac Applications & Software
    Replies: 4
    Last Post: July 3rd, 11:55 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139