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!
Watch video Fix MySQL Installation Error: SET PASSWORD has no significance for user 'root'@'localhost' online without registration, duration hours minute second in high quality. This video was added by user Sultan Kautsar 08 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 426 once and liked it 5 people.