In this video we describe "mysql -u root
ERROR 1698 (28000): Access denied for user 'root'@'localhost' "
we give three solution to solve this error
Steps involved in this process are given below
HOW TO SOLVE THIS ERROR
SOLUTION 1:
sudo mysql -u root
SOLUTION 2:
STEP 1:
LOGIN USING: sudo mysql -u root
STEP 2:
CREATE A NEW USER WITH ALL PRIVILEGES FOR ALL DATABASES OR THE PARTICULAR DATABASE
A. create database subject
B. grant all on subject.* to user1@localhost identified by 'secret';
STEP 3:
CHECK THE USER IS CREATED OR NOT
select user,host,plugin from mysql.user;
user1 | localhost | mysql_native_password
STEP 4:
TRY TO LOGIN USING mysql -u user1 -p
working
SOLUTION 3:
HOW TO LOGIN USING mysql -u root without using sudo
STEP 1:
sudo mysql -u root
STEP 2:
select user,host,plugin from mysql.user ;
STEP 3:
UPDATE auth_socket BY mysql_native_password
STEP 4:
update mysql.user set plugin='mysql_native_password' where user='root' and host='localhost';
STEP 5:
flush privileges;
STEP 6:
LOGIN USING mysql -u root without sudo
NOW WORKING
THANK U FOR WATCHING MY VIDEOS
IF U LIKE MY VIDEOS
PLS SUBSCRIBE
THANK U
2 окт 2024