Topic: I killed my MYSQL database

[Teviot]

Hi

I feel really stupid.  I was having a play with phpBB2 and a few other bits and pieces and totally killed the databases on my server.

Can anyone help me recover from "MY ERROR" ( playing with something I don't understand ) ?

I can't login to phpmyadmin is the first problem and then there is mambo website that i have installed.

Regards
Adrian

[william_syd]

Did you change the MySQL root users password ?

[Teviot]

I don't think so ... but i can't login using it ... so i'm going to assume the it has been changed

Adrian

[william_syd]

At the command prompt what does typing mysql give you ?

[Teviot]

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[william_syd]

Guess you get the same with

Code: [Select]

mysql -uroot?

[william_syd]

It is looking like you messed with the root users password in MySQL.

Code: [Select]

cd /service/mysqld
runsvctrl d .
cat set.password | /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables
runsvctrl u .

The above method may fix it for you.

Code: [Select]

cd /service/mysqld
runsvctrl d .
/etc/e-smith/events/actions/mysql-delete-db-files
signal-event post-upgrade
signal-event reboot

The above method may fix it for you but will erase data in your databases.

Both methods are from here.

I have never tried them myself.

[Teviot]

william_syd

I appreciate your help.  But unfortunately, is still can't login via phpmyadmin.

I'm thinking that the password has been changed and I have no idea how to change that.  Could you or someone else tell me how I can get thing back to normal?  I fear that I may have to resintall from scratch if i can't fix this.

Thanks in advance

[william_syd]

But unfortunately, is still can't login via phpmyadmin.

But you can by just typing mysql at the prompt.

If so, don't panic.

[Teviot]

yes I can

[william_syd]

yes I can

Follow these steps and let me know how you went.

Disregard the last line.

[Teviot]

All went well until i tried to login

I got

Error
#1045 - Access denied for user 'monty'@'localhost' (using password: YES)

as a response

[william_syd]

All went well until i tried to login

I got

Error
#1045 - Access denied for user 'monty'@'localhost' (using password: YES)

as a response

Please list how the individual steps went.

[Teviot]

[root@gateway phpmyadminmulti]# mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 159 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.03 sec)

mysql> quit
Bye
[root@gateway phpmyadminmulti]#

I then did

pico config.inc.php

and edited the file to reflect the changes and then tried to access phpmyadmin

I didn't get any errors but it appeared to just reload the login page

I also noticed that you have version 2.9.0 running.  I would like to upgrade to that when this problem is sorted

[william_syd]

I'm not sure why it's not working.

Do you still have the rpm ?

Uninstall it the way you installed it.

rpm -e name_of_rpm

or

yum remove name_of_rpm

then reinstall with

yum localinstall name_of_rpm

then login with admin/admin