687
edits
Changes
Jump to navigation
Jump to search
Line 158:
Line 158: − − ====set mariadb root password==== − Since I am managing mariadb using the existing SME mysql client, and since the SME mysql client automatically uses the mysql 'root' password, I chose to set the root password for my mariadb installation to match the mysql root password. − − When running the commands below, press <Enter> when prompted for a password (the default mariadb root password is empty): − <nowiki>CONNECT=--socket=/opt/mariadb-data/mariadb.sock − mysql $CONNECT -p < /var/service/mysqld/set.password</nowiki> − − Now that your mariadb installation is using your SME Server mysql root password, you can easily verify the versions of mysql and mariadb as described in the howto: − <nowiki>#mysql version − mysql -e "SELECT VERSION();"</nowiki> − − <nowiki>#mariadb version − CONNECT=--socket=/opt/mariadb-data/mariadb.sock − mysql -e "SELECT VERSION();" $CONNECT − # OR connect using port 3307 − CONNECT="--protocol=TCP --port=3307" − mysql -e "SELECT VERSION();" $CONNECT − # OR spell out the connection on the command line − mysql -e "SELECT VERSION();" --protocol=TCP --port=3307</nowiki>
→set mariadb root password
If I use the line suggested in the HOWTO, mariadb never starts (although it reports starting on the command line, it records an error in /opt/mariadb-data/<hostname>.err)</strike>
If I use the line suggested in the HOWTO, mariadb never starts (although it reports starting on the command line, it records an error in /opt/mariadb-data/<hostname>.err)</strike>
===Backup & Restore===
===Backup & Restore===