I have a major problem where my privilege system is totally messed up. I am able to start the mysqld but not as root only as another user on my system. I am getting access denied errors all over the place. Is there a way that I can reset up mysql, even the access to start mysqld as root. I have been trying now for the past 3 hours no luck. I just want mysql as it was when it was first installed.
The other option I believe is re-installing mysql. Is this feesable?
Marcus
try running the mysql_install_db script as root, that will re-initilize your grant tables.
Make sure to backup your data before you do it.
Check the manual for more info.
I am now getting the error:
Fatal error: Please read "Security" section of the manual to find out how to run
mysqld as root!
010709 13:24:43 Aborting
when I try to start the mysql server. I am logged in as root
And did you read the mysql manual to find out how to run the mysql as root?
(if you want to run it as root that is...)
hi, i'm also having problems when trying to connect to mysql. I have installed MySQL and i want to start off by setting a password for the root user. I tried this by using:
/usr/bin/mysqladmin -u root -h www.domain.com -p password 'new-password'
After i executed this i get to typ in a password, i first tried the admin password (used to connect to the server, cobalt raq4) and after that i tried to leave it open, so i did not insert a password. With both methods i get the following error:
/usr/bin/mysqladmin: connect to server at 'www.domain.com' failed
error: 'Host 'www.domain.com' is not allowed to connect to this MySQL server'
I a little bit stuck with this problem, hope one of you can help me out here.
(i've installed Mysql 3.23.37 on a cobalt raq4)
Thnx in advance.
Greets Dennis
And did you read the mysql manual to find out how to run the mysql as root?
(if you want to run it as root that is...)