Тёмный

mysql ERROR 1698 (28000): Access denied for user 'root'@'localhost' in ubuntu 

osfy user1
Подписаться 42
Просмотров 34 тыс.
50% 1

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

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
Далее
🦊🔥
00:16
Просмотров 308 тыс.
Вопрос Ребром - Серго
43:16
Просмотров 1,4 млн
SHORT: Wilkinson Fire Alarm
5:41
Просмотров 5 тыс.
How to Reset MySQL Root Password on Windows
5:56
Просмотров 680 тыс.
🦊🔥
00:16
Просмотров 308 тыс.