Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jul 2011
    Location
    North East, Maryland
    Posts
    91
    Thanks
    16
    Thanked 1 Time in 1 Post

    Are MariaDB and MySQL compatible?

    I’m a server side newbie, but I have worked with other databases, just not on the web.

    I’m starting work on a project that will use MySQL to backfeed data to a series of php web pages. I am about to install XAMPP 7.1.11 on my local Windows 7 CPU and when I looked at the documentation on the Apache Friends download page I noticed that MySQL was not included, but there was a note on the FAQ page:

    Since XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. The commands and tools are the same for both.

    7.1.11 includes MariaDB 10.1.28

    I don’t plan to upload the actual database to the server after testing. Their FAQ comment seems to indicate that the PHP that I create will be compatible with the MariaDB on my local CPU and also the MySQL database on my host’s web server, GoDaddy.

    Should I also install MySQL? Or should I just rely on their FAQ comment they created for previous versions?
    Last edited by PapaGeek; 11-22-2017 at 12:32 PM.
    My favorite quote is by Andrew S. Tanenbaum in Computer Networks, 2nd ed., p. 254 published in 1988, The nice thing about standards is that you have so many to choose from.

  2. #2
    Senior Coder benanamen's Avatar
    Join Date
    Oct 2015
    Posts
    1,377
    Thanks
    3
    Thanked 137 Times in 132 Posts
    Use MariaDB. It is a drop in replacement for MySQL and is actually better. It was developed by the same guys that built MySQL and the development is more ongoing than MySQL.
    To save time, lets just assume I am almost never wrong.

    The XY Problem
    The XY problem is asking about your attempted solution (X) rather than your actual problem (Y). This leads to enormous amounts of wasted time and energy, both on the part of people asking for help, and on the part of those providing help.

    "This text has been encoded with ROT26. If you can read this you must have found a backdoor. Congratulations!"


 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •