{{warning box| be careful that mariadb will be running without any user auth, if it is open to outside of your server, then you might want to close this access first, and keep this session as short as possible }}
then use mysql command line
then use mysql command line
mysqlcheck mysql
mysqlcheck mysql
Line 125:
Line 125:
mysql mysql < /home/e-smith/db/mysql/mysql.user.dump
mysql mysql < /home/e-smith/db/mysql/mysql.user.dump
{{warning box| the line dumping the table mysql.user to the mariadb server will delete any existing entries in the table if you are using the default SME dump as it has a DROP TABLE IF EXISTS line. So do this only if you know what you are doing.}}
==Access MariaDB/MySQL using port from the localhost and local network==
==Access MariaDB/MySQL using port from the localhost and local network==