okiwan/alterRootPassword.md

Created December 16, 2018 10:45

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/okiwan/b3c95561da6eb66a7e2d3934e5aa4a21.js"></script>
Save okiwan/b3c95561da6eb66a7e2d3934e5aa4a21 to your computer and use it in GitHub Desktop.

Download ZIP

Alter root password on MariaDB instance startup

Raw

alterRootPassword.md

sudo systemctl stop mariadb
mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root -p
set password for 'root'@'localhost' = password('')
Exit, stop server (kill -9) and start normally using systemctl

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment