Page 1 of 1

Problem with MySQL and MariaDB

PostPosted: 25. March 2017 02:11
by tshivas23
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

Re: Problem with MySQL and MariaDB

PostPosted: 25. March 2017 11:31
by Nobbie
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.

Re: Problem with MySQL and MariaDB

PostPosted: 27. March 2017 15:23
by tshivas23
Thank you, Nobbie:

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

Thank you.

Tricha

Re: Problem with MySQL and MariaDB

PostPosted: 27. March 2017 16:33
by Nobbie
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.

Re: Problem with MySQL and MariaDB

PostPosted: 27. March 2017 17:38
by tshivas23
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

Re: Problem with MySQL and MariaDB

PostPosted: 27. March 2017 19:47
by Nobbie
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?

Re: Problem with MySQL and MariaDB

PostPosted: 27. March 2017 22:10
by tshivas23
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.