Changes

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

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

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.