80
edits
Changes
Jump to navigation
Jump to search
Line 76:
Line 76: + + + + + + + + + + + + + + + + + + + + + + + + Line 87:
Line 111: + + Line 127:
Line 153: − + − + Line 141:
Line 167: − + − sv t /service/mysqld + − + + + − + − + − + + +
Wrong path for expand-template (
===Restoring accidentally deleted MySQL root user===
===Restoring accidentally deleted MySQL root user===
<tabs container style="display: inline-block;"><tab name="For SME 10">
mariadb 5.5 and up to 10.5
systemctl stop mariadb
echo "GRANT ALL PRIVILEGES ON *.* TO 'root'@'`config get DomainName`' WITH GRANT OPTION;">/var/lib/mysql/set.rootuser
echo "GRANT PROXY ON ''@'' TO 'root'@'`config get DomainName`' WITH GRANT OPTION;">>/var/lib/mysql/set.rootuser
echo "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;">>/var/lib/mysql/set.rootuser
echo "GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;">>/var/lib/mysql/set.rootuser
expand-template /root/.my.cnf
expand-template /var/lib/mysql/set.password
/usr/libexec/mysqld --socket=/var/lib/mysql/mysql.sock --bootstrap --user=mysql --skip-grant-tables <( cat /var/lib/mysql/set.rootuser /var/lib/mysql/set.password)
exit
systemctl start mariadb
</tab><tab name="For SME 8 and up to 9">
for MySQL 5.1.73
cd /var/service/mysqld
sv d .
echo 'use mysql;'>set.rootuser
echo "INSERT INTO `user` VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);">>set.rootuser
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < set.rootuser
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < set.password
sv u .
</tab><tab name="For SME 7.3">
Note: The following is only applicable on SME 7.3 and MySQL 4.1
Note: The following is only applicable on SME 7.3 and MySQL 4.1
cd /var/service/mysqld
cd /var/service/mysqld
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < set.password
sv u .
sv u .
</tab>
</tabs>
==MariaDB/MySQL fails to start==
==MariaDB/MySQL fails to start==
Considering your table dump is now in a file called /home/e-smith/db/mysql/mysql.user.dump, do
Considering your table dump is now in a file called /home/e-smith/db/mysql/mysql.user.dump, do
mysql mysql < /home/e-smith/db/mysql/mysql.user.dump
mysql mysql < /home/e-smith/db/mysql/mysql.user.dump
expand-template /var/service/mysqld/set.password
expand-template /var/lib/mysql/set.password
mysql mysql < /var/service/mysqld/set.password
mysql mysql < /var/lib/mysql/set.password
mysqladmin shutdown
mysqladmin shutdown
systemctl start mariadb
systemctl start mariadb
{{Warning box|Keep in mind that by default MariaDB/MySQL is not using any kind of encryption unless you did work on that yourself, so any access to the port from the LAN will be as clear text and anyone on the LAN will be able to access to the password and all the data transferred between your server and the client. Refers to the manual of your database version.}}
{{Warning box|Keep in mind that by default MariaDB/MySQL is not using any kind of encryption unless you did work on that yourself, so any access to the port from the LAN will be as clear text and anyone on the LAN will be able to access to the password and all the data transferred between your server and the client. Refers to the manual of your database version.}}
For SME 10:
<tabs container style="display: inline-block;"><tab name="For SME 10">
config setprop mariadb LocalNetworkingOnly no
config setprop mariadb LocalNetworkingOnly no
expand-template /etc/my.cnf
expand-template /etc/my.cnf
systemctl restart /service/mysqld
For SME 9 and below:
</tab><tab name="For SME 9.2 and before">
config setprop mysqld LocalNetworkingOnly no
config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
expand-template /etc/my.cnf
sv t /service/mysqld
sv t /service/mysqld
</tab>
</tabs>
==Access MySQL from a remote network==
==Access MySQL from a remote network==
If you wish to enable access to MariaDB/MySQL databases from remote networks, then in addition to the LocalNetworkingOnly db setting mentioned above, you will need to execute the following commands:
If you wish to enable access to MariaDB/MySQL databases from remote networks, then in addition to the LocalNetworkingOnly db setting mentioned above, you will need to execute the following commands:
For SME 10
<tabs container style="display: inline-block;"><tab name="For SME 10">
config set mariadb service access public status enabled TCPPort 3306
config set mariadb service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event remoteaccess-update
signal-event reboot
signal-event smeserver-mysql-update
For SME9 and below
</tab><tab name="For SME 9 and below">
config set mysqld service access public status enabled TCPPort 3306
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event remoteaccess-update
signal-event reboot
signal-event reboot
</tab>
</tabs>
Keep in mind this enables access to your MariaDB/MySQL database for ANYONE, so make sure you have strong passwords on ALL your MariaDB/MySQL databases.
Keep in mind this enables access to your MariaDB/MySQL database for ANYONE, so make sure you have strong passwords on ALL your MariaDB/MySQL databases.