M BUZZ CRAZE NEWS
// general

Unable to access MySQL database in browser

By Mia Morrison

I am accessing a database remotely. I can access the database through the terminal with user name and password but in the browser, it gives the following error message.

Cannot log in to the MySQL server mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

Output of the command select user, host from mysql.user order by user;

| user | host |
+------------------+------------+
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| phpmyadmin | localhost |
| root | localhost |
| root | Ipaddress of remote system |
| root | % |
+------------------+------------+
5 Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy