It is mainly due to security setup that allows to connect to “root” from specific IP address or localhost
In this scenario, ask your admins to create a new user account and setup the required access instead of using “root”
If the root account is not configure to authenticate with a password, you may need below command
MySQL> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
If user need to login as root, you they can follow the steps to grant access to local host and or IP Address
MySQL> GRANT ALL ON [DB_Name].* to 'root'@'127.0.0.1' IDENTIFIED BY '[PASSWORD]';
MySQL> GRANT ALL ON [DB_Name].* to 'root'@ ‘IP Address’ IDENTIFIED BY '[PASSWORD]';
Instead of using “GRANT ALL ON”, use required privileges only.
Thanks & Regards
http://oracleracexpert.com, Oracle ACE
Love to read it, waiting for More New Update and I Already Read your Recent Post it's Great. Thank you for sharing useful information. If you like to Know Azerbaijan Medical Journal Visit our website for More Medical Science Information.
ReplyDelete