July Liam - I hate to say this, but you didn't answer the question - Is it the case that not only phpMyAdmin can't talk to MySQL, but also any data driven websites you have are also impaired??? July Hi Sorry, Been pulling my hair out here.
July I have managed to fix the problem i was having. After main attempts at altering files, test firewall etc etc. I reverted back to 1. This seemed to fix the problem of not ben able to login to phpMyAdmin. July Xampp 1. With the connection enabled phpMyAdmin works just fine. Now phpMyAdmin works whether the PC is connected to its local network or not. I can't find any ressource on the internet which is saying that it would help in some way. Can you please explain why you think it would solve that issue best wishes, Altrea.
It's like porn for programmers. Add a comment. Active Oldest Votes. Try this. Improve this answer. Sanketh Sanketh 1, 10 10 silver badges 18 18 bronze badges.
I've got xampp and phpmyadmin working without problems for months But my computer at the office had a lot of windows 10 updates this morning. Since then I've had the error as descibed above. Aditya Achar Aditya Achar 1 1 gold badge 1 1 silver badge 12 12 bronze badges. This works for me. I have too many installation of mysql installed so have to terminate it before starting the xampp instance. Sadik Sadik 3, 6 6 gold badges 49 49 silver badges 85 85 bronze badges. I would recommend for others to change the permissions of xampp folder right click and select "give access to" select security tab click on the edit, new popup will be opened click on the allow check boxes and apply.
Apache Friends Support Forum Skip to content. Advanced search. Forum rules. Post a reply. This can also occur if you try to change the directory where the database is stored, but imput the wrong directory in the configuration file like a typo. Instead of telling you the typo directory does not exist, it will tell you that you lack permission to access it.
As a first step I would recommend an attempt to restart the server process see other's distinctions of server v. Usually, re-installation isn't necessary. I would recommend you to first check the log files.
Show 4 more comments. Try this: mysql -h Peter Mortensen Yannick Yannick 2, 1 1 gold badge 10 10 silver badges 6 6 bronze badges. I'm getting the same error. And I've checked and the default bind in both the main and my. However using your command above allowed me to connect.
Will have to keep hunting to see why just doing "mysql" is giving the error. I get telnet: Unable to connect to remote host: Connection refused as a result of telnet command. However apache still runs as I'm able to open localhost — Rishi Dua. But when I wanted to connect to my db thru an iOS app by using ssh tunnel, I got this error. Then I could connect. After this, I realized I was getting now this error which took me to this answer and now it's working again.
Definitely I agree with you by getting an explanation about why just typing mysql without -h throws an error. Note: mysql -h localhost does not work.
Make sure to use mysql -h How can I solve this if I get to login with the command in this answer? Jimenez Holmquist. Show 2 more comments. Billal Begueradj In MySQL 5. This worked great for me, but I first had to implement this solution: stackoverflow. JoeKreydt, in v.
For me, it was localhost or Come back to terminal and execute sudo service mysql start And it worked for me. From this, I just ran sudo service mysql restart and it worked. SilvioDelgado Not if you ever want to connect through ssh tunneling.
Explanation here — Pathros. Add a comment. In my case it was that the disk was full and mysqld couldn't start anymore. Try to restart mysql service. Betty 5 5 silver badges 15 15 bronze badges. Martin Schultz Martin Schultz 1, 2 2 gold badges 18 18 silver badges 29 29 bronze badges. The same thing happened to me - full disk. Cleaned up some space, rebooted and problem went away.
Cleaned space and start service ok — Hugo. I fixed this problem by executing the following command: mysql.
0コメント