Using the command:Originally Posted by mysql server
mysqladmin version
from a command prompt gives me the above error. How do I sort it out?
Using the command:Originally Posted by mysql server
mysqladmin version
from a command prompt gives me the above error. How do I sort it out?
Are you sure the data link dosn't require a username and password?
To err is human. To really foul things up ... you need a computer.
1.) put detail in the post of the subject not stuff like "help" or "error" etc etc
2.) read the warning message after you've done a "mysql_install_db" - whats mysql_install_db I hear you ask, perhaps read a few pages of the documentation before jumping in
3.) specify what the host OS and mysql version is
Now the answer
what you need to do is verfiy mysql is running, which I assume it is
my fist questiion is have you set the root users password with mysqladmin ? if the answer to that question is yes then
mysql -h $hostname -u root -p
replace hostname with either local host, or a network alias for your host
you'll then be prompter for a password, enter the root users password input that
then.....now that your in sql prompt
update user
set host ='%' where user !='root'
;
commit
;
flush privileges
;
this will allow any user other than root to connect from any host
or you can - as you suggested use mysqladmin -p password 'newpassword' replace 'newpassword' with password
It is Inevitable.....
There are currently 1 users browsing this thread. (0 members and 1 guests)