How to install mariadb server ;
sudo apt update
sudo apt install mariadb-server
sudo mysql_secure_installation
sudo mariadb
create database;
show databases;
create user 'user name'@'localhost' identified by "password";
select host, user from mysql.user;
database permission;
grant all on databasename .*to datauser'@'localhost';
Backup Database in from mysqldump ;
mysqldump -u username -p databasename > database dump.sql;
Root access ;
sudo su
mysql -u root -p
Comments