Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
SQL problem
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
corey_
n00b
n00b


Joined: 30 Nov 2002
Posts: 49

PostPosted: Thu Mar 13, 2003 1:14 am    Post subject: SQL problem Reply with quote

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
View user's profile Send private message
slartibartfasz
Veteran
Veteran


Joined: 29 Oct 2002
Posts: 1462
Location: Vienna, Austria

PostPosted: Thu Mar 13, 2003 7:55 am    Post subject: Reply with quote

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
View user's profile Send private message
corey_
n00b
n00b


Joined: 30 Nov 2002
Posts: 49

PostPosted: Fri Mar 14, 2003 5:23 am    Post subject: Reply with quote

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
View user's profile Send private message
slartibartfasz
Veteran
Veteran


Joined: 29 Oct 2002
Posts: 1462
Location: Vienna, Austria

PostPosted: Fri Mar 14, 2003 9:33 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum