Unable to log in to phpMyAdmin.It may be because of the MySQL configuration, but please let me know.
I downloaded phpMyAdmin 4.4.14.1 and installed it on a web server.
http://pocolog.cocolog-nifty.com/mt/2014/07/vps-phpmyadmin-.html
When I try to log in with user phpmyadmin, I see "#1045 Unable to log in to MySQL server."
I thought I didn't set up a user in MySQL, so I set it to be root for now.
http://www.goofoo.jp/2011/11/1457
http://www.dbonline.jp/mysql/user/index1.html
http://www.dbonline.jp/mysql/user/index2.html
Note: The difference between the sites is that there were multiple users, so I decided not to delete the user, and because root was not in the user, I set the admin password.
So I'm going to show you the phpMyAdmin screen and even if I type user:admin, password:phpMyPassword (password set in mysql), I'm going to show you "#1045 MySQL server can't log in."
mysql phpmyadmin
You may have removed it, but what is the host name setting when you add users?
When displaying phpMyAdmin, you cannot access it if the hostname of the URL is different from the hostname of the user registered in the database.
Even if you point to the same server, aliases that are only registered in the hosts file on your device will not be able to connect and you will often fall in love with them.
© 2024 OneMinuteCode. All rights reserved.