Display default MySQL root password

Questions LEMP Stack Q & ADisplay default MySQL root password
lempstack asked 3 months ago

Display default MySQL root password

1 Answers
lempstack answered 3 months ago

NOTE:
Use following URL to open phpMyAdmin page:
http://<Public net IP>/phpMyAdmin
phpMyAdmin is an application for MySQL databases management. With it you can create, alter, drop, delete, import and export MySQL database tables. You can also run MySQL queries, optimize, repair and check tables, change collation.

Display default MySQL root password

cd /root/oneinstack #Must enter the directory execution under oneinstack
grep dbrootpwd options.conf #Display MySQL root password

As shown below:
《Answer for Display default MySQL root password》

Change MySQL root password

cd  /root/oneinstack  # Must enter the directory execution under oneinstack
./reset_db_root_password.sh

As shown below:
《Answer for Display default MySQL root password》