This is actually a good restriction. As a general thumb of rule, you should not use the root account for the applications.
Although not recommended, you can allow root user to connect via a password (and not auth_socket) by using the command:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpassword';
A better solution would be to create a new user, set the privileges accordingly and use that account from your application.
First you should connect to the database (type the password accordingly):
sudo mysql -u root -p
Then create the user:
CREATE USER 'bob'@'localhost' IDENTIFIED BY 'bobpasswd';
Then grant desired privileges:
GRANT ALL PRIVILEGES ON * . * TO 'bob'@'localhost';
Then use the new account in your application.
This blog looks comfortable to read, where did you find a template like this?
Good article, thanks for sharing, please visit
our website
Nice article, Thank for your share. Please visit
Visit Us