Women in Technology

Hear us Roar



Subject:   error 1044 and 1045...ok..but no CREATE
Date:   2002-04-26 14:46:01
From:   venste
Response to: error 1044 and 1045...ok..but no CREATE

i have the same problems also. the test.php file cant even find the db "test"


How the hell do i create db's


this is why i hate unix, if there was a gui, i wouldnt be complaining

Full Threads Oldest First

Showing messages 1 through 9 of 9.

  • error 1044 and 1045...BINGO!
    2002-04-27 23:02:35  gaga1 [View]

    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>

    ~~~~~~~~
    • 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.