XAMPP will not connect to MySQL. Problems with the Windows version of XAMPP, questions, comments, and anything related. 6 posts. Page 1.
- Dpacadmin wrote:Try running the Post Assistant on your site you seem to have a MySQL server problem or a Host server issue. Both Register Globals and Display Errors should be off for security reasons, if you Host will not set them to off you may be able to set them off on your site with a.htaccess file.
- Usually when you install XAMPP for the first time or so, you are told that you server is not secured give a password to your server user. Then you switch to the Users tab and and gave the “root” user a password.
Firstly: I am cannot entering PHPMYADMIN at “localhost:80/phpmyadmin/”. Because when I install MySQL server mysql-5.5.36 with Username :root and Password : HamdunSoft . After that when I enter localhost:80/phpmyadmin/ it show me a message like below .
“Error MySQL said: Documentation
1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.”
Now I want enter my Phpmyadmin though I have setup two MySQL server one in xampp, another mysql-5.5.36. I have searched it in net but the content was not helpful sufficiently. How can I set the password in xampp before login in phpmyadmin .
Another different issue is: XAMPP Apache server was saying : port 80 is being used by some one. I solved it by stopping Skype. But again having this types of problem. I think like Skype another software is using port 80. I want to use any port with Apache as I wish. It may be port 80 or 81 or 82. If any other process is using my desired port I want to replace that and give that port to Apache.
Find the below code in xampp/phpmyadmin/config.inc.php
Replace each statement above with the corresponding entry below:
Doing this caused localhost/phpmyadmin in the browser and the MySQL command prompt to work properly.
You want to run Mysql server from Mysql and from Xampp also want to browse phpmyadmin so that you can operate database.Then follow the rules:
From “Xampp/phpmyadmin” directory in config.inc.php file find the below code. And follow the given instructions below. I have tried like this and I was successful to run both localhost/phpMyAdmin on browser, MySQL Command prompt as well as MySQL query browser.
And replace the above each statement with the below each corresponding code.
Way 1 : You can quit Skype first. And when Apche server is started then again you can run Skype. If you want to run Apache in another port then replace in xampp/apache/conf/httpd.conf “ServerName localhost:80” by “ServerName localhost:81” At line 184. After that even it may not work. Then replace
at line 45
Way 2 : If you want to use port 80. Then follow this. In Windows 8 “World Wide Publishing Service is using this port and stopping this service will free the port 80 and you can connect Apache using this port. To stop the service go to the “Task manager –> Services tab”, right click the “World Wide Publishing Service” and stop. If you don’t find there then go to “Run > services.msc” and again find there and right click the “World Wide Publishing Service” and stop.
If you didn’t find “World Wide Publishing Service” there then go to “Run>>resmon.exe>> Network Tab>>Listening Ports” and see which process is using port 80.
And from “Overview>>CPU” just Right click on that process and click “End Process Tree”. If that process is system that might be a critical issue.
1.open your xampp dir ( c:/xampp )
2.to phpMyadmin dir [C:xamppphpMyAdmin]
3.open [ config.inc.php ] file with any text editor
last : save the file .
here is a video link in case you want to see it in Action [ click Here ]
If you can not authenticate via the web interface (localhost/phpmyadmin/) then try change authentication type to cookie.
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
MySQL multiple instances present on Ubuntu.
step 1 : if it’s listed as installed, you got it. Else you need to get it.
sudo ps -A grep mysql
step 2 : remove the one MySQL
sudo apt-get remove mysql
sudo service mysql restart
step 3 : restart lamp
sudo /opt/lampp/lampp restart
If all the other answers do not work for you check the
config.inc.php for the following:
…and add the port of MySQL set in your XAMPP as shown below:
Stop MySQL from XAMPP and restart MySQL.
Open a fresh page for
http://localhost:8012/phpmyadmin/ and check.
Tags: mysql, php, sql
Date: March 01, 2021 11:47AM
Xampp With Mysql
Xampp Not Connecting To Mysql Download
Xampp Connect To Mysql Workbench
Xampp Not Connecting To Mysql Client
Xampp Mysql Not Starting
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.