-1

Wampserver is installed on my Windows 10 machine and suddenly, at the bottom it says "No Default DBMS" with a red caution triangle (as in the screenshot below). In the same left-click window you can clearly see that MySQL is installed and selected as the default.

In my research I read some bits about changing the port, but that doesn't seem to be relevant to my situation. The "W" in the system tray is green and all services (apache, php, and mysql) are started.

What is going on here? Why is this message appearing all of a sudden and none of my virtual hosts are working? Phpinfo() page is working fine, so I know that php, mysql, and apache are all working.

"No default DBMS message at bottom of Wampserver, screenshot (c) Eric Hepperle, 2021

MY DETAILS:

Following are specs and answers to question I suspect you might ask for clarity.

  • Windows 10 Version 10.0.19042 Build 19042
  • Wampserver 3.2.5 - 64 bit
  • MySQL 5.7.14
  • PHP 7.0.10
  • phpMyAdmin 4.6.4
  • "W" indicator is GREEN

Let me know if you need any other specific info.

REFERENCES:

Here are posts and pages I looked at that were informative, but didn't offer any concrete solution to this issue:

8
  • 1
    Your first link suggest that you click on "/!\ No Default DBMS"; did you try that?
    – mustaccio
    Oct 7 at 20:47
  • Yep. It just gives me this seemingly erroneous error msg: Sorry, There is an error. Neither MariaDB nor MySQL is configured as the default SGDB. See Right-Click -> Help -> MariaDB - MySQL. The instructions in help say to change the port, but the port was fine before, so what changed? I appreciate your help Oct 7 at 21:44
  • ... And the instructions are somewhat specific, yet don't contain enough context for me to be sure that changing my port number is the right response. I'd like somebody to explain why I all of a sudden have to do this, if that is the case. I haven't been able to use my webserver since April. I'd really like to try to get this solved tonight if possible. @riggsFolly has weighed in on other issues I've had since the turn of the year. It will probably be, since I work a day job not in computers that I won't even be able to test any suggestions for weeks ... there has got to be a better way Oct 7 at 21:48
  • This is what mariadb_mysql.txt says on point 5: This means that none of the database managers (MariaDB and/or MySQL) use port 3306 and it is therefore imperative to specify the port number in connection requests since this is not the default port 3306. It is then essential that you choose which DBMS you want to use by default; to do this, use the built-in tools (Right-click -> Tools) to assign port 3306 (Use a port other than xxxx) to the DBMS (MariaDB or MySQL) you want to set as default. Oct 7 at 21:50
  • @mustaccio Finally, this is mysql port test Test for TCP Your port 3308 is used by a processus with PID = 1760 The processus of PID 1760 is 'mysqld.exe' Session: Services The service of PID 1760 for 'mysqld.exe' is 'wampmysqld64' This service is from Wampserver - It is correct Test for TCPv6 Your port 3308 is used by a processus with PID = 1760 The processus of PID 1760 is 'mysqld.exe' Session: Services The service of PID 1760 for 'mysqld.exe' is 'wampmysqld64' This service is from Wampserver - It is correct Oct 7 at 21:51

Your Answer

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

Browse other questions tagged or ask your own question.