hey guys,
I have been testing out mandrake for our offices web server.I have just installed the machine and have finished configuring apache,samba and PHP.
I am now stuck at mysql.
I download the rpms from mysql's site and install them using rpm -Uvh
after installing the mysql server the installer gives me this message:
Code:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.
After installing the client(and starting the deamon) i issue this command:
Code:
mysqladmin -u root password mandrake
and i get an error message like this:
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
I have tried many different version of this using mysql -u root -p and then enetering this password and some other ways too(i have tried so many id otn remember them now).
I checked the running processes and saw that mysqd was running under user mysql and so i did:
mysql -u mysql -p
that did not work either.
I am really frustrated now.I have been on this case for the last 5 hours and have entered probably all the possible combination of searches in google.
my my.cnf file has the password i am trying to put(just so that is clear too).
my final aim is to use mysql through phpmyadmin.
can someone please help me with this.
thanks
