MySQL: Accidently Removed Both root users

Impotence

Impotence

May the source be with u!
:notme: Never underestimate the power of a motivated idiot!!! :notme:​

I managed accidentally remove both BOTH root MySQL using phpMyAdmin (You should have seen my face when it printed out the commands it sent... :/)

oh :swear:!
Click to expand...

i tried using /usr/bin/mysqld_safe --user=root but phpmyadmin still wont let me login...

help!

Note: I am using Ubuntu, but i CAN login as root!
 
:notme: Never underestimate the power of a motivated idiot!!! :notme:​
:doh: too true:doh:​
[ot]i've done some idiotic thing too, i only realize how stupid i was after the event[/ot]
 
Success :D

Thanks Addis, doubt i would have found "--init-file=temp" without that.

If anybody else manages this, then here's how you can sort it...

1. create a text file called "temp" containing the following line and put it in your home folder.
Code: 
GRANT ALL PRIVILEGES ON *.* TO 'bob'@'%'
2. Kill mysql (You will need to do this as root or with sudo)
Code: 
/etc/init.d/mysql stop
3. start mysql with the following command, replace 'impotence' with the name of your home folder.
Code: 
mysqld --init-file=/home/impotence/temp

congrats, you created a fully privileged user called bob (with no password) that can be logged into from anywhere!

get everything back the way it was and then delete bob!
 
You must log in or register to reply here.
Back
Top