Changes

From SME Server
Jump to navigationJump to search

SME Server on Scientific Linux (view source)

Revision as of 16:38, 27 February 2013

31 bytes added ,  16:38, 27 February 2013
m
no edit summary
Line 83: Line 83:  
  Upgrade      38 Package(s)
 
  Upgrade      38 Package(s)
 
  Total size: 67 M
 
  Total size: 67 M
 +
 +
 +
==== 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:
 +
cd /var/service/mysqld
 +
sv d .
 +
/sbin/e-smith/expand-template /root/.my.cnf
 +
/sbin/e-smith/expand-template /var/service/mysqld/set.password
 +
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
 +
sv u .
 +
    
==== Post-upgrade/reboot ====
 
==== Post-upgrade/reboot ====
Line 97: Line 108:       −
==== 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:
  −
cd /var/service/mysqld
  −
sv d .
  −
expand-template /root/.my.cnf
  −
expand-template /var/service/mysqld/set.password
  −
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
  −
sv u .
      
==== Adjust yum repositories ====
 
==== Adjust yum repositories ====
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/19265"

Navigation menu