| 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"
|
||
Showing messages 1 through 9 of 9.
-
error 1044 and 1045...BINGO!
2002-04-27 23:02:35 gaga1 [View]
-
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.



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