mysql root password

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

mysql root password

Postby speedmaker » Thu Nov 18, 2021 7:16 pm

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
speedmaker
 
Posts: 34
Joined: Wed Sep 02, 2020 10:46 am

Re: mysql root password

Postby carpenox » Sat Nov 20, 2021 7:39 am

What version of mysql/mariadb are you running?
Alma Linux 9.4 | SVN Version: 3890 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2428
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: mysql root password

Postby callcentertech » Fri Dec 17, 2021 10:37 am

Hey, are you still experiencing the same issue..??
Email: kaushal@callcentertech.net, Phone/WhatsApp: +1 (636)-556-0022
Web: https://www.callcentertech.net, Skype: live:52956f35f3283f55
Fully Automated VICIdial Installer https://www.callcentertech.net/vicifast/
callcentertech
 
Posts: 48
Joined: Sat Jul 17, 2021 2:01 pm
Location: Ahmedabad, India


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 120 guests