|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
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
February 3rd, 2005, 05:48 PM
|
|||
|
|||
|
Mysql password problems
Hi this is my first time on this forum. hope sombody can help me
Basically I have mysql installed on my machine and it works fine
On installation I was prompted for a user name and password
which I entered. But if I go to the command line and enter the
command "mysql -u root -p" I 'am asked for my password, so I
enter the one I gave to the mysqladmin. On doing this I get an
error 1045 stating "access denied for user:'root@127.0.0.1'
(using password: yes)". How can Iget mysql to log me on by
using the password I provided on installation?
Would be very greatful for any help on this issue as it is driving
me mad...thanks...Paul
|
|
#2
February 4th, 2005, 07:41 AM
|
||||
|
||||
|
Try using root with no password....
similarly, try using no username and no password... sometimes both of these logins are setup by defualt.
|
|
#3
February 4th, 2005, 09:07 AM
|
|||
|
|||
|
Thanks for the reply
Yes I can enter root with no password and it works, or with both root and password removed. The thing is though, I want to use a root name and password for security reasons. On installation of mysql, i entered a root user name and password in the mysqladmin section. But these values are not accepted from the command line of mysql How can I set up root user and password details?
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Mysql password problems |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
