Problem with MySQL and MariaDB

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Problem with MySQL and MariaDB

Postby tshivas23 » 25. March 2017 02:11

I want to use XAMPP as the server for my Moodle CMS.

Initially wasn't able to load Moodle because I need to load the latest version of MariaDB

Name Information Report Plugin Status
database mysql (5.5.5-10.1.21-MariaDB)
version 5.5.31 is required and you are running 5.5.5.10.1.21
Check

I received this error when trying to load Moodle. I downloaded the latest version of mariaDB but now XAMPP is giving me

The following errors. Thank you in advance for your help.


MySQL Service detected with wrong path
5:25:16 PM [mysql] Change XAMPP MySQL and Control Panel settings or
5:25:16 PM [mysql] Uninstall/disable the other service manually first
5:25:16 PM [mysql] Found Path: "C:\Program Files\MariaDB 10.1\bin\mysqld.exe" "--defaults-file=C:\Program Files\MariaDB 10.1\data\my.ini" "MySQL"
5:25:16 PM [mysql] Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
5:25:16 PM [mysql] Problem detected!
5:25:16 PM [mysql] Port 3306 in use by ""C:\Program Files\MariaDB 10.1\bin\mysqld.exe" "--defaults-file=C:\Program Files\MariaDB 10.1\data\my.ini" "MySQL""!
5:25:16 PM [mysql] MySQL WILL NOT start without the configured ports free!
5:25:16 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
5:25:16 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

Best,
Tricha
tshivas23
 
Posts: 4
Joined: 25. March 2017 02:04
XAMPP version: 5.6.30
Operating System: Windows 10

Re: Problem with MySQL and MariaDB

Postby Nobbie » 25. March 2017 11:31

You cannot start both MariaDB servers, you already started your own installed newer version and are now trying to start Xampps MariaDB as well, that does not work and that is exactly what the above error messages are telling you. Simply do not start Xampps MariaDB.
Nobbie
 
Posts: 9689
Joined: 09. March 2008 13:04

Re: Problem with MySQL and MariaDB

Postby tshivas23 » 27. March 2017 15:23

Thank you, Nobbie:

How do I stop XAMPPS older version of XAMPP so I can use this newer version in XAMPP?

Thank you.

Tricha
tshivas23
 
Posts: 4
Joined: 25. March 2017 02:04
XAMPP version: 5.6.30
Operating System: Windows 10

Re: Problem with MySQL and MariaDB

Postby Nobbie » 27. March 2017 16:33

Do not start Xampps MariaDB, neither manually nor as a service. And do not start it automatically. You dont need to stop it, if you even dont start it.
Nobbie
 
Posts: 9689
Joined: 09. March 2008 13:04

Re: Problem with MySQL and MariaDB

Postby tshivas23 » 27. March 2017 17:38

I opened the config box when I first opened XAMPP I do not have it set to have any of the modules starting automatically. And I haven't started any modules, but I am still getting this error. I am not sure how to stop it from starting automatically.

Thanks for your guidance
tshivas23
 
Posts: 4
Joined: 25. March 2017 02:04
XAMPP version: 5.6.30
Operating System: Windows 10

Re: Problem with MySQL and MariaDB

Postby Nobbie » 27. March 2017 19:47

tshivas23 wrote:And I haven't started any modules, but I am still getting this error.


As this error shows up in the Xampp Dialog - how can this happen, if you do not start anything? Dont start Xampp Dialog, if unsure.

Please explain precisely, where you can see these error messages. And why do they show up?
Nobbie
 
Posts: 9689
Joined: 09. March 2008 13:04

Re: Problem with MySQL and MariaDB

Postby tshivas23 » 27. March 2017 22:10

I am sorry, I really am not following.

Are you suggesting that I don't use XAMPP as my server?

All I am doing is opening the control panel. When I open the control panel I get these errors. I assume these means that both of these programs are running automatically but I can figure out how to stop one of them. I am thinking MySQL because the MariaDB is the most up to date version.

Thank you.
tshivas23
 
Posts: 4
Joined: 25. March 2017 02:04
XAMPP version: 5.6.30
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests