Women in Technology

Hear us Roar



Subject:   error 1044 and 1045...BINGO!
Date:   2002-04-27 23:02:35
From:   gaga1
Response to: error 1044 and 1045...ok..but no CREATE

Figured this error 1044 & 1045 out and would like to share it:


at the shell key in


>mysql -u(username) -p mysql


//*you'll be prompted to give your password.
Key it in (you won't see anything).


Bingo! You are in and can start creating!


Here's what it looked like from my iBook terminal:
~~~~~~
Welcome to Darwin!
[localhost:~] gaga% mysql -uroot -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 28 to server version: 3.23.49-entropy.ch


Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql>


~~~~~~~~

Full Threads Oldest First

Showing messages 1 through 8 of 8.

  • error 1044 and 1045...BINGO!
    2003-07-24 17:25:53  anonymous2 [View]

    maybe this will help someone...

    when i type:
    " ./mysql -uroot -p mysql"

    i get:
    Enter password:
    ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

    what fixed it was
    doing this:

    " ./mysqladmin -u root password [type a password here]"

    then i log on doing this:

    "./mysql -uroot -p"

    from there i can finally log on and create databases... this is using the latest osx update (10.2.6) and the latest version of mysql (4.0.14-standard)

    good luck
  • usernameerror 1044 and 1045...BINGO!
    2003-06-25 21:41:34  anonymous2 [View]

    >>> from Alex
    >>>

    Thanks for that gagal, it was a real help

    /~\Alex/~\
    Detective Sergeant
    Computer Crime Squad
    Victoria Police
  • access denied errors
    2003-05-24 22:36:14  anonymous2 [View]

    Thank You gaga1 for posting your fix that you found totally on your own with no help of the author, mysql.com tutorial, etc.
    It's nice to follow a tutorial like this and do things but sometimes the authors don't think it too important to tell us about little syntax idiosyncrasies like the difference between -u root and -uroot. with the former I spent hours trying to figure out why I couldn't connect. with the latter of which you provided It worked. I'm in as root user. and I am realatively comfortable with unix but was totally unaware of the whitespace issue in using mysql. I hope everyone else that had this problem can fix it here. It worked for me and others. once again. a big thanks for the trial and error method of gaga1 and not the help of the author.
  • error 1044 and 1045...BINGO!
    2003-05-02 17:03:09  anonymous2 [View]

    I am trying to do as you've instructed but I get a message that says ERROR 1049: Unknown database 'mysql'. Any clues?
    • error 1044 and 1045...BINGO!
      2003-05-20 19:59:26  anonymous2 [View]

      I appreciate everbody's advice but i am still getting the dreaded 1044 message even after i keyed this in...
      Last login: Tue May 20 20:09:51 on ttyp2
      Welcome to Darwin!
      You have new mail.
      [localhost:~] mdhowes% mysql -umdhowes -p mysql
      Enter password:
      ERROR 1045: Access denied for user: 'mdhowes@localhost' (Using password: YES)
      [localhost:~] mdhowes% mysql -uroot -p mysql
      Enter password:
      ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
      [localhost:~] mdhowes%

      Any Ideas? Personally I think it was a bum install on my behalf
      Thanx in advance
      Mitch
      • error 1044 and 1045...BINGO!
        2003-05-24 22:42:24  anonymous2 [View]

        I don't know but maybe you had my problem. I just posted a thank you to gaga1. his advice helped me. I had to try it 2 times as I had run mysqladmin at one time trying to fix up my problem and had changed the password to my system admin password on my machine. so the second time I tried that and I found that it had been changed. if that don't work I'm at a loss. check through the online documentation at http://www.mysql.com/doc/en/

        Good Luck.
  • error 1044 and 1045...BINGO!
    2002-07-13 13:03:07  msimoes@umich.edu [View]

    I was having the same problem myself and your instructions worked like a charm, thanks!
    • error 1044 and 1045...BINGO!
      2002-10-02 19:24:57  anonymous2 [View]

      First, I want to give a "BIG THANKS!" to gaga1. I finally got mysql working!

      And, to morbus: If all you have to say is a patronizing "RTFM," please don't bother posting. With all of the flavors of UNIX there are, Mac OS X is probably one of the strangest. And most of the users, like Venste and me, are used to a GUI and are having a difficult time already. One of the things we also got used to is finding help. We are constantly reminded that we make up a small percentage of personal computers out there, and we have to try 10 times harder just to get help-- going to the local computer store does no good. So, in general, I agree, read the manual first. But don't assume everyone else is lazy and did not bother looking for answers before posting. We are all just trying to learn.