Changes

From SME Server
Jump to navigationJump to search

User talk:Mmccarn (view source)

Revision as of 23:32, 11 January 2014

158 bytes added ,  23:32, 11 January 2014
→‎set mariadb root password
Line 71: Line 71:     
====set mariadb root password====
 
====set mariadb root password====
−
In order to easily manage mariadb using the SME mysql client set the root password for mariadb to match the SME mysql root password.
+
A freshly installed mariadb server has no password set for the root user.
    +
In order secure your mariadb server yet easily manage mariadb set the root password for mariadb to match the SME mysql root password.
 +
 +
SME has a template-driven sql command specifically for setting the root password:
 
  <nowiki>CONNECT=--socket=/opt/mariadb-data/mariadb.sock
 
  <nowiki>CONNECT=--socket=/opt/mariadb-data/mariadb.sock
 
mysql $CONNECT -password="" < /var/service/mysqld/set.password</nowiki>
 
mysql $CONNECT -password="" < /var/service/mysqld/set.password</nowiki>
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/23221"

Navigation menu