3,254
edits
Changes
From SME Server
Jump to navigationJump to search→Resetting the MySQL root password
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user.
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user.
#SME9
service mysql57-mysqld stop
service mysql57-mysqld stop
expand-template /root/.my.cnf
expand-template /root/.my.cnf
exit
exit
service mysql57-mysqld start
service mysql57-mysqld start
#SME10
systemctl stop mysql57-mysqld
expand-template /root/.my.cnf
expand-template /var/opt/rh/rh-mysql57/lib/misc/set.password
scl enable rh-mysql57 bash
/opt/rh/rh-mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/opt/rh/rh-mysql57/lib/misc/set.password
exit
systemctl start mysql57-mysqld
=== Bugs ===
=== Bugs ===
