How to Install Maria db on EC2 Instance;
Sudo apt update
sudo apt install apache2
sudo ap install mariadb-server
sudo apt installation
sudo mysql
mysql -u root -p
HOW TO INSTALL MYSQL IN UBUNDU:
MYSQL
CREATE DATABASE Student
show databases ;
HOW TO CREATE USER MARIA DB IN LOCAL HOST PASSWORD;
sudo mysql_secure_installation
sudo mysql -u root -p
create user 'USERNAME'@'localhost' identified by "PASSWORD";
CREATE USER FOR PERMISSION ACCESS :
grant all on databasename.*to 'username'@'localhost';
flush privileges;
EXIT
Backup server mariadb command;
mysqldump -u username -p database_name > database_dump.sql
Comments