Скачать или смотреть MYSQL Install in UBUNTU 18.04 | Dumb Minds

Prerequisites:
1.sudo/root privilages

INSTALLING
step 1 : sudo apt update
step 2 : sudo apt install mysql-server

CONFIGURING MYSQL
stpe 3 : sudo mysql_secure_installation


ADJUSTING USER AUTHENTICATION AND PRIVILAGES
step 4 : sudo mysql
step 5 : SELECT user,authentication_string,plugin,host FROM mysql.user;
step 6 : ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
step 7 : FLUSH PRIVILEGES;
step 8 : SELECT user,authentication_string,plugin,host FROM mysql.user;
step 9 : exit

ACCESSING ROOT
step 10 : mysql -u root -p

CREATE ANOTHER USER
step 10 : CREATE USER 'sukresh'@'localhost' IDENTIFIED BY 'password123';
step 11 : GRANT ALL PRIVILEGES ON . TO 'sukresh'@'localhost' WITH GRANT OPTION;
step 12 : exit;

TESTING MYSQL
step 13 : systemctl status mysql.service





Thank you for watching 😁️


Dumb Minds is a pack of Knowledge and practice. That gives you legitimate and exact info in a short period of time.

Blogger : https://dumbmindsblog.blogspot.com/
Facebook :   / dumb-minds-111038576909235  
Quora : https://www.quora.com/profile/Manda-S...
Instagram :   / dumbminds01