Bsrgvty

Why should I invest so much in 401(k)?

Novel about alien species made of gas rings?

Make me speak L33T

Substitute Unprintable ASCII Characters

What is the difference between chemical equilibrium and dynamic equilibrium?

Why is there potato in meatballs?

How would medieval/Renaissance-era castles protect themselves from air raids?

Mistakenly agreed with a scammer’s term of use

Patent Agreement in Order to Graduate

How was the Luftwaffe able to destroy nearly 4000 Soviet aircraft in 3 days of operation Barbarossa?

CEO says not to expect pay increases unless you do something really exceptional. Is this counter-productive?

Can I stay beyond the "must enter before" date on an Australian ETA?

I need to draw this picture in LaTeX. How do I do that? Boxes with arrows

Is it possible to protect saved games on Nintendo Switch from being played by other users?

How can I convince my child to write?

Wifi near the speed of light

Is there a reason to have 2 or more witnesses at the same time during the current impeachment hearings

How to explain to traditional people why they should upgrade their old Windows XP device?

Is 'lay lady lay' grammatical?

Is military allowed to wear civilian clothes when testifying in Congress?

Displaying vertex indices in Blender 2.8 using debug mode

Could dinosaurs breathe modern air?

How can I reflect a StreamPlot object?

What antenna is this in an Apollo 15 LM photo?

Unable to access MySQL database in browser

mysql error 1045(280000) access denied for user 'debian-sys-maint '@' localhost using password 'yes'Mysql Error SQLSTATE[HY000] [1045] Access denied for user. While installing Drupal 7 in localhostaccess phpmyadmin on localhost & reconfigure phpmyadmin: ERROR 1045 (28000): Access denied for user 'root'@'localhost'Mysql error when running Laravel php migrationsi have mysql 8.0.2 installed on my ubuntu 16.04.can not open it through terminal. so what to do now?Problem in accessing to MysqlHow to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

1

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 | % |
+------------------+------------+

mysql phpmyadmin localhost

share|improve this question

edited Sep 12 at 5:59

tweety

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Has the user phpmyadmin the right to access MySQL from localhost? It also depends on the protocol, I guess phpMyAdmin uses TCP, unlike the mysql command. Also please always include error messages as text in your questions, see meta.askubuntu.com/questions/8713/…, idownvotedbecau.se/imageofanexception.
  
  – Melebius
  Sep 11 at 7:49
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  By accessing the server through ssh I can able to login mysql -u phpmyadmin -p root123 With the same username and password when i try to access ipaddress/phpmyadmin/ it throws the error which I have mentioned above.
  
  – tweety
  Sep 12 at 5:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This supports my hypothesis about having different privileges for different protocols. Please edit your question to add the output for the select user, host from mysql.user order by user; query. Don’t forget to apply code formatting to pasted terminal text. And also add the error message as text, as I requested earlier.
  
  – Melebius
  Sep 12 at 5:27
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have edited the question with the ouput you have asked for.
  
  – tweety
  Sep 12 at 5:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry. Now i have added the error message in text.
  
  – tweety
  Sep 12 at 5:59
  

  
  
  
  

add a comment
 | 

1

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 | % |
+------------------+------------+

mysql phpmyadmin localhost

share|improve this question

edited Sep 12 at 5:59

tweety

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Has the user phpmyadmin the right to access MySQL from localhost? It also depends on the protocol, I guess phpMyAdmin uses TCP, unlike the mysql command. Also please always include error messages as text in your questions, see meta.askubuntu.com/questions/8713/…, idownvotedbecau.se/imageofanexception.
  
  – Melebius
  Sep 11 at 7:49
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  By accessing the server through ssh I can able to login mysql -u phpmyadmin -p root123 With the same username and password when i try to access ipaddress/phpmyadmin/ it throws the error which I have mentioned above.
  
  – tweety
  Sep 12 at 5:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This supports my hypothesis about having different privileges for different protocols. Please edit your question to add the output for the select user, host from mysql.user order by user; query. Don’t forget to apply code formatting to pasted terminal text. And also add the error message as text, as I requested earlier.
  
  – Melebius
  Sep 12 at 5:27
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have edited the question with the ouput you have asked for.
  
  – tweety
  Sep 12 at 5:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry. Now i have added the error message in text.
  
  – tweety
  Sep 12 at 5:59
  

  
  
  
  

add a comment
 | 

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 | % |
+------------------+------------+

mysql phpmyadmin localhost

share|improve this question

edited Sep 12 at 5:59

tweety

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges

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

share|improve this question

edited Sep 12 at 5:59

tweety

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges

share|improve this question

edited Sep 12 at 5:59

tweety

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges

asked Sep 10 at 10:43

tweetytweety

1366 bronze badges