687
edits
Changes
Jump to navigation
Jump to search
Line 71:
Line 71: − In order to easily manage mariadb using the SME mysql client set the root password for mariadb to match the SME mysql root password.+ + + +
→set mariadb root password
====set mariadb root password====
====set mariadb 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>