Answers for "ubuntu connect mysql as root"

SQL
1

mysql change root mysql_native_password

UPDATE
	mysql.user
SET
	plugin = 'mysql_native_password', 
	Password = PASSWORD('')
WHERE
	User = 'root';
Posted by: Guest on December-11-2020
0

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';
Posted by: Guest on August-23-2020

Code answers related to "ubuntu connect mysql as root"

Code answers related to "SQL"

Browse Popular Code Answers by Language