Changes

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.

For SME 10 (note for SCLO version see respective contrib page):

<tabs container style="display: inline-block;"><tab name="For SME 10">

  systemctl stop mariadb

  systemctl stop mariadb

  expand-template /root/.my.cnf

  expand-template /root/.my.cnf

  exit

  exit

  systemctl start mariadb  

  systemctl start mariadb  

For SME Server 7.3 and up to SME 9.2:

</tab><tab name="For SME 7.3 and up to SME 9.2">

 

  cd /var/service/mysqld

  cd /var/service/mysqld

  sv d .

  sv d .

  /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password

  /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password

  sv u .

  sv u .

 

For SME Server 7.2 and earlier releases do the following (they use the runsvctrl command instead of the sv command):

For SME Server 7.2 and earlier releases do the following (they use the runsvctrl command instead of the sv command):

  /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password

  /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password

  runsvctrl u .

  runsvctrl u .

===Restoring accidentally deleted MySQL root user===

===Restoring accidentally deleted MySQL root user===