Let's check how can we recover mysql root password if we lost it
Step # 1: Stop the MySQL server process.
Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password.
Step # 3: Connect to mysql server as the root user.
Step # 4: Setup new mysql root account password.
Step # 5: Exit and restart the MySQL server.
Here are commands you need to type for each step (login as the root user)
# service mysqld stop
# mysqld_safe --skip-grant-tables &
[1] 13964
root@localhost ~]# Starting mysqld daemon with databases from /var/lib/mysql ------------nothing will show just type mysql
mysql ----- typing mysql shows like this
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
Or
ctrl z then
#mysql
mysql> use mysql;
mysql>update user set password=PASSWORD("password@123#") WHERE user="root";
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start
Terima kasih telah membaca artikel tentang How to Recover a Mysql Root Password di blog Tutorial Opensource and Linux jika anda ingin menyebar luaskan artikel ini di mohon untuk mencantumkan link sebagai Sumbernya, dan bila artikel ini bermanfaat silakan bookmark halaman ini di web browser anda, dengan cara menekan Ctrl + D pada tombol keyboard anda.