View previous topic :: View next topic |
Author |
Message |
corey_ n00b
Joined: 30 Nov 2002 Posts: 49
|
Posted: Thu Mar 13, 2003 1:14 am Post subject: SQL problem |
|
|
Anytime I try doign anything with SQL, I get this problem...
Code: |
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
|
thanks in advnace =/ |
|
Back to top |
|
|
slartibartfasz Veteran
Joined: 29 Oct 2002 Posts: 1462 Location: Vienna, Austria
|
Posted: Thu Mar 13, 2003 7:55 am Post subject: |
|
|
did u already set a root account for mysql? the mysql 'root@localhost' is not the same as your unix root - u have to add the username(root) the box (localhost) and optionally a password (very recommended) in mysql
detailed instructions on how to do that are in the MySQL manual, which can be downloaded at the mysql homepage... _________________ To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be. |
|
Back to top |
|
|
corey_ n00b
Joined: 30 Nov 2002 Posts: 49
|
Posted: Fri Mar 14, 2003 5:23 am Post subject: |
|
|
slartibartfasz wrote: | did u already set a root account for mysql? the mysql 'root@localhost' is not the same as your unix root - u have to add the username(root) the box (localhost) and optionally a password (very recommended) in mysql
detailed instructions on how to do that are in the MySQL manual, which can be downloaded at the mysql homepage... |
It says that when I try to set the password =/ |
|
Back to top |
|
|
slartibartfasz Veteran
Joined: 29 Oct 2002 Posts: 1462 Location: Vienna, Austria
|
Posted: Fri Mar 14, 2003 9:33 am Post subject: |
|
|
hmm - thats strange - i think there is a password recovery procedure in the manual - u could try that...
and u can try to do it via the mysql shell directly not via mysqladmin...perhaps u can find details on the error in the logs... _________________ To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be. |
|
Back to top |
|
|
|