|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Hello,
I haven't used MySQL for while and I am trying to use it again for my project. I already have my user name and password set up from previous usage. When I type the following: shell> mysql -u my_username -h localhost -p Enter password: mypassword the following error appears Error 1045: Access denied for user my_username@localhost (Using password: YES) How can I fix this problem? I also want to know where I can find my.ini or my.cnf file. Thank you in advance. Cheers. Young P.S: I almost forgot, my OS is Windows XP professional and the version of MySQL is 4.0.20a Last edited by Young : December 14th, 2004 at 11:48 PM. Reason: forgot to add versions of OS and MySQL |
|
#2
|
||||
|
||||
|
You might want to try taking the spaces out between -u and -h
I've had similar things happen before. mysql -uusername -hlocalhost -p (you can ommit -h if its localhost) You could even try omitting everything and simply calling mysql.exe Some people forget to apply passwords to root@localhost, and some people leave the noname/nopassword account active... Otherwise, perhaps reinstalling MySQL is a solution? my.ini and my.cnf could be in your Windows directory... Again, all this depends on how you originally set mysql up. |
|
#3
|
|||
|
|||
|
Thank you
Hello,
Sorry for replying so late, I just read the message now. Thank you very much for your help again. It happens to be that when I type in the root (the default user name) along with -h localhost -u root -p, then everything perfectly works. Could it be that when I first set up MySQL I might not have set up my username? Anyhow, I will look further into this. Read more documents, and ask questions. Anyhow, thank you very much and merry Christmas. Young |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Database Development > Trouble with MySQL error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|