3,704
edits
Changes
Jump to navigation
Jump to search
mLine 118:
Line 118: − − − ==== 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 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 − 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 . Line 152:
Line 142: + + + + + + + + + + +
SME Server on Scientific Linux (view source)
Revision as of 08:20, 28 February 2013
, 08:20, 28 February 2013no edit summary
Upgrade 38 Package(s)
Upgrade 38 Package(s)
Total size: 67 M
Total size: 67 M
Now one can remotely ssh in to the server, which makes it easier to execute the remaining steps.
Now one can remotely ssh in to the server, which makes it easier to execute the remaining steps.
==== 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 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
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 .