mysql root password

[speedmaker]

Hello ,

I forgot the password from the mysql root ,,

and that old exponation is not working anymore

> 1 : stop the mysql

/etc/init.d/mysql stop

=> 2 : starting the mysql in safemode

=> run the below command to start mysql in safe mode

mysqld_safe --skip-grant-tables &

=> 3 : logging to mysql

mysql -u root

mysql>


=> 4 : updating new password for mysql root

use mysql
update user set password=PASSWORD("xxxxxxxxxx") where user='root';
flush privileges
quit

=> 5 : Stop and Start the mysql

/etc/init.d/mysql stop
/etc/init.d/mysql start


=> 6 : login to mysql with new password

mysql -u root -p yournewpassword


does anyone know how to do that with that version ,,

VERSION: 2.14-718a
BUILD: 190902-0839
© 2019 ViciDial Group

thx Speedmaker

[carpenox]

What version of mysql/mariadb are you running?

[callcentertech]

Hey, are you still experiencing the same issue..??