I wanted to check the following: if I install mariaDB via
brew install mariadb
will it allow me to access by phpmyadmin? since I have Xammp on my Mac and when I run apache and turn off mysql from xampp I don't have access to phpmyadmin,
They would help me if they give me a manual on how to install mariadb and how to have the phpmyadmin environment. I'm not sure if it's possible when running xampp, hope you can help me.
The thing is, as far as I can remember, phpMyAdmin creates its own tables in a DB in that mysql. Turning off the DB causes no access to phpMyAdmin configuration data and such.
I don't know if it's that transparent (because I don't know what version of mysql and mariadb you have), but you could solve it by doing something like:
stop mariadb, start xampp mysql
in the xampp/mysql/data folder copy the subfolder
phpmyadmin
inside the folderdata
in mariadb. Find this source folder by starting mysql, entering phpmyadmin and executing SELECT @@datadir` 1.5) Stop mysql from xamppIn the file
xampp/phpadmin/config.inc.php
(rough lines) edit the following:line 21 set password lines 31-32 set user
restart xampp and confirm that xampp's mysql is stopped
start mariadb
Please backup everything before moving things. This can damage your xampp installation.