mysql change root mysql_native_password
UPDATE
mysql.user
SET
plugin = 'mysql_native_password',
Password = PASSWORD('')
WHERE
User = 'root';
mysql change root mysql_native_password
UPDATE
mysql.user
SET
plugin = 'mysql_native_password',
Password = PASSWORD('')
WHERE
User = 'root';
how to login to mysql as normal user in ubuntu
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us