Тёмный

MySQL Forgotten Root password reset 

InfoAlias
Подписаться 1,9 тыс.
Просмотров 18 тыс.
50% 1

In this video, I have explained the process for resetting the root password for MySQL. for resetting the root password I have used a txt file where I have mentioned the command
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Yournewpassword';
and executed the below command on CMD with run as administrator on My sql installation path C:\Program Files\MySQL\MySQL Server 8.1\bin\
Command
mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.1\my.ini" --init-file=C:\
eset.txt
after few seconds just press Ctrl + c and try to access your MySQL with new password which is written in your txt file.
Post changing your password you can delete the reset.txt file for security reason.
#windows11
#windows10
#windows
#windows11mix
#mysql
#mysqldba #databasemanagementsystem
#windows

Опубликовано:

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 70   
Далее
Qalpoq - Amakivachcha (hajviy ko'rsatuv)
41:44
Просмотров 312 тыс.
How to Change MySQL root Password
3:38
Просмотров 106 тыс.
The Home Server I've Been Wanting
18:14
Просмотров 159 тыс.
Disable These 3 Windows Settings Now! (For Security)
12:26