|
Subject:
|
Setting up the root account
|
|
Posted By:
|
najib
|
Post Date:
|
11/18/2003 7:38:59 AM
|
I have completed MySQL installation on my windows machine .I can navigate to C:\mysql\bin directory .When I use " >mysqladmin -uroot password abcdef " ,to set up admin user name and password this error is shown:
mysqladmin: connecting to server at'localhost' faild
error: access denied for user: 'root@localhost' (Using password: NO)'
But I can connect to the data base by usinig only username and not any password .And the result is that I can not USE the mysql data base ,however I can use the test database.
Note that I am the administrater of this machine and both the server and the client are installed on my machine.
Thanks in advance.
|
|
Reply By:
|
happygv
|
Reply Date:
|
11/18/2003 9:11:11 PM
|
najib
You need to do...
mysqladmin -u root -p command
then enter the mysql password when prompted.
Note: you _can_ specifiy the password on the command line, but then anyone running 'top' or otherwise watching the processes on the box will see the password in the command arguments displayed.
-Vijay G
|
