Changes

From SME Server
Jump to navigationJump to search
76 bytes added ,  02:29, 19 August 2022
Line 48: Line 48:  
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
Line 55: Line 55:  
  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 .
Line 62: Line 63:  
  /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 .
 
+
</tab><tab name="For SME 7.2 and earlier">
 
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):
   Line 71: Line 72:  
  /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 .
 +
</tab>
 +
</tabs>
    
===Restoring accidentally deleted MySQL root user===
 
===Restoring accidentally deleted MySQL root user===
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,254

edits

Navigation menu