How to fix non-root login to MySQL in Ubuntu?

mysql
ubuntu
(Dmitry Fedyuk) #1
mysql -u root
DROP USER 'root'@'localhost';
CREATE USER 'root'@'%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

askubuntu.com/a/784347

0 Likes

How to set a non-empty password to the `root` MySQL user in Ubuntu?
(Dmitry Fedyuk) #2

See also: How to set a non-empty password to the root MySQL user in Ubuntu?

0 Likes