How to install ubuntu in maria-db ;
sudo apt update
sudo apt install mariabd-server
sudo mysql_secure_installation
GRANT ALL ON *.*TO'admin'@'localhost' IDENTIFIED BY 'passwd' WITH GRAND OPTION;
FLUSH PRIVILEGES
EXIT
ROOT TO USER ; SUDO SU
MYSQL LOGIN FOR SUDO SU
MYSQL TO USER CREATE
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'identifiedby "PASSWORD";
ROOTUSER-ADMIN
CREATEUSER-NAME
MYSQL LOGIN CREATE USER ;
mysql -u karthik -p
HOW TO ROOT USER MARIA DB LOCAL HOST PASSWORD ;
mysql -u root -p
CREATE USER FOR PERMISSION ACCESS ;
grant all on mysql_tuts.*to'mysql_user'@'localhost';
flush privileges ;
Comments