688
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 66:
Line 66: + + + + + + + + + + + + + + + + + + + + + + + +
→move password reset and version check
<nowiki>cd /opt/mariadb
<nowiki>cd /opt/mariadb
scripts/mysql_install_db --defaults-file=/opt/mariadb-data/my.cnf</nowiki>
scripts/mysql_install_db --defaults-file=/opt/mariadb-data/my.cnf</nowiki>
====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.
<nowiki>CONNECT=--socket=/opt/mariadb-data/mariadb.sock
mysql $CONNECT -password="" < /var/service/mysqld/set.password</nowiki>
====Testing====
If you set the mariadb root password as shown above you can verify the versions of mysql and mariadb as described in the howto:
<nowiki># show mysql version
mysql -e "SELECT VERSION();"</nowiki>
<nowiki># show mariadb version
CONNECT=--socket=/opt/mariadb-data/mariadb.sock
mysql -e "SELECT VERSION();" $CONNECT</nowiki>
Here are alternative ways to show the mariadb version:
<nowiki># show mariadb version using TCP on port 3307
CONNECT="--protocol=TCP --port=3307"
mysql -e "SELECT VERSION();" $CONNECT
# command lines to check mariadb versions
mysql -e "SELECT VERSION();" --protocol=TCP --port=3307
mysql -e "SELECT VERSION();" --socket=/opt/mariadb-data/mariadb.sock</nowiki>
====Configure to start at boot====
====Configure to start at boot====
