Changes

From SME Server
Jump to navigationJump to search
m
Line 86: Line 86:     
==== Reset MySQL root password ====
 
==== Reset MySQL root password ====
SME Server uses a secure random password for the MySQL root user. A new MySQL root password has to be generated to overwrite the SL root MySQL password. There should be no reason to change or use the MySQL password, so we '''strongly''' advise you '''never''' to change or use the MySQL root password, even though many how-to's or (web)applications will tell you they 'require' this'. You can grant permissions to a (new) MySQL user for a certain database as system root. How to do this is explained [[MySQL#Resetting_the_MySQL_root_password|here]]. As root issue the following commands:
+
SME Server uses a secure random password for the MySQL root user. A new MySQL root password has to be generated to overwrite the SL root MySQL password so that it is compliant with SME Server inner workings. There should be no reason to change or use the MySQL password, so we '''strongly''' advise you '''never''' to change or use the MySQL root password, even though many how-to's or (web)applications will tell you they 'require' this'. You can grant permissions to a (new) MySQL user for a certain database as system root. How to do this is explained [[MySQL#Resetting_the_MySQL_root_password|here]]. As root issue the following commands:
 
  cd /var/service/mysqld
 
  cd /var/service/mysqld
 
  sv d .
 
  sv d .
Line 93: Line 93:  
  /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 .
      
==== Post-upgrade/reboot ====
 
==== Post-upgrade/reboot ====

Navigation menu