Run the following command on the Cloud server (this works only on Linux servers):
|
1 |
UUID=`uuidgen`; xenstore-write data/host/$UUID '{"name":"resetnetwork","value":""}'; sleep 10; xenstore-read data/guest/$UUID; unset UUID |
If completed successfully it will return something like this:
|
1 |
{"message": "", "returncode": "0"} |
1) Create file /var/lib/mysql/mysql.init with contents:
|
1 |
SET PASSWORD FOR 'root'@'localhost'=PASSWORD('mynewpassword'); |
2) Add this line to /etc/my.cnf in the [mysqld] section:
|
1 |
init_file=/var/lib/mysql/mysql.init |
3) Restart the MySQL service
4) At your leisure, delete the mysql.init file and remove the init_file line
from /etc/my.cnf
Source: https://stroobants.io/reset-a-root-password-in-mariadb-on-linux/
|
1 2 3 4 5 6 7 8 9 10 |
service mysql stop mysqld_safe --skip-grant-tables --skip-networking & # mysql use mysql; update user set password=PASSWORD("<PASSWORD>") where User='root' flush privileges; exit service mysql restart |