DEV Community

Cover image for All you need to know about mysql
Sudip Bhujel
Sudip Bhujel

Posted on

All you need to know about mysql

Discover and Learn CRUD (Create, Read, Update, Delete) operation and the concept behind database.

Installation

sudo mysql -u root -p
PASSWORD: yourpassword
Enter fullscreen mode Exit fullscreen mode
use mysql;
UPDATE user SET plugin='mysql_native_password' WHERE user='root'
UPDATE mysql.user set authentication_string=PASSWORD('yourpassword') where user='root';
FLUSH PRIVILEGES;
quit;
Enter fullscreen mode Exit fullscreen mode

Top comments (0)