I have set up a new back up server on which I have configured LAMP configuration. My web application connects to mysql and stores/fetches the data from mysql. When accessing the web app, it shows me this error:
Access denied for user 'root'@'xyz.com' (using password: YES)
on checking the access details on mysql, it shows
Also, I restarted the server, but not sure what authentication needs to be provided to make it working.
In addition, this is what I see when I use ELECT USER(),CURRENT_USER();
root@localhost
|root@localhost
the details on mysql is "xyz", not "xyz.com", update the host and try again~