When you don’t know the current mysql root password and you want to change it, do this:
/etc/init.d/mysql stop mysqld --skip-grant-tables & mysql -p use mysql; update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; flush privileges; quit; killall mysqld /etc/init.d/mysql start
Recent Comments