Fix MySQL Installation Error: SET PASSWORD has no significance for user 'root'@'localhost'
Command (Copy & Paste):
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'your-password';
mysql_secure_installation is a shell script available on Unix systems, and enables you to improve the security of your MariaDB installation in the following ways:
You can set a password for root accounts.
You can remove root accounts that are accessible from outside the local host.
You can remove anonymous-user accounts.
You can remove the test database, which by default can be accessed by anonymous users.
So, How to Fix mysql_secure_installation error?
Chapters:
00:00 - Connecting to Ubuntu Server
00:22 - Installing mysql-server package
00:46 - Executing mysql_secure_installation
01:09 - Error Message (Problem)
01:20 - Exiting The Error Loop Message
01:31 - Fixing The mysql_installation Error
02:37 - Opening MySQL With root Using Password
Music by:
YouTube Audio Library
Thanks for watching!
Смотрите видео Fix MySQL Installation Error: SET PASSWORD has no significance for user 'root'@'localhost' онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Sultan Kautsar 08 Ноябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 426 раз и оно понравилось 5 людям.