I used the script in :
http://mirror.contribs.org/smeserver/contribs/dmusty/SME6.0/scripts/and it completely fucked up my mysql database : I noticed, but too late, that one of the files that was to be downloaded by the script pointed to a 404 error.. now it has modified the root account in mysql database and I've spent the las 4 hours to try to fix it without any success..
I downloaded the lastes stable 4.1.7 rpms, updated with them.. launched the fix_privileges script as well.. does strictly nothing..
I tried this :
- service mysqld stop
- safe_mysqld --skip-grant-tables &
- mysql -h localhost mysql
then :
- update user set password=password('new_password') where user='root';
- flush privileges;
- exit;
- service mysqld stop
- service mysqld start
and all I get when i try a 'mysal -u root -p 'new_password' is :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
So I looked at all the hints I found on the net and tried this :
- service mysqld stop
- safe_mysqld --skip-grant-tables &
- mysql -h localhost mysql
then :
- Grant all on * to root@localhost identified by '1234';
and I get :
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
(although this is the method which is supposed to be used on the mysql.org webserver...)
So I'm completely stuck... what can I do to delete this darned password which comes from nowhere ???
Please.. heeeeeelp!!!! I've a lot of thinhs on this server and I'd really like to avoid reinstalling...
9 Replies
3353 Views