peshka.org – WP site

peshka.org – WP site

peshka's reminder site – ver. 2.0

peshka.org – WP site RSS Feed
 
 
 
 

RECOVER Mysql root password

Here is a good link to change mysql root password if you have root access to the machine:

The fastest way to change it (debian based):

create sql that changes the password – sometginh like this:

file= “/tmp/file-$$.sql”
echo “SET PASSWORD FOR root@localhost = PASSWORD(‘NEW ROOT PASS’);” > $file
/etc/init.d/mysql stop
mysqld_safe –init-file=$file &
killall -9 mysqld_safe
/etc/init.d/mysql start

Some additional links:

recoever mysql root pass
recoever mysql root pass (long explanation)

recoever 3 choice – more variants