Changes

From SME Server
Jump to navigationJump to search

User talk:Mmccarn (view source)

Revision as of 22:44, 11 January 2014

1,073 bytes removed ,  22:44, 11 January 2014
→‎set mariadb root password
Line 158: Line 158:     
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>
−
  −
====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>
      
===Backup & Restore===
 
===Backup & Restore===
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/23218"

Navigation menu