当前位置: 动力学知识库 > 问答 > 编程问答 >

xampp - What is the difference between MySQL and MariaDB database?

问题描述:

I have been using XAMPP for a long time and was surprised that XAMPP has switched to MariaDB from MySQL.

https://www.apachefriends.org/index.html

How will this change impact on existing developers using MySQL? For example, can existing development tools for MySQL work seamlessly with MariaDB? What are notable difference between MySQL and MariaDB that developers need to take note?

I am not sure if it is advisable to upgrade XAMPP version because of this database change. I am worried of the migration of data from MySQL to MariaDB.

网友答案:

"For example, can existing development tools for MySQL work seamlessly with MariaDB?"

A common development tool for MySQL is MySQL Workbench. MySQL Workbench may not support MariaDB.

See this: MySQL Workbench 6.3.5 crashes when opening XAMPP MySQL local database

Another one here: MySQL Workbench incompatible/nonstandard server

Having said that, there are other options to MySQL Workbench (a good alternative is HeidiSQL for example, which works great by the way with the local MariaDB install by XAMPP).

But all of this is minor I believe, for the most part the move to MariaDB is painless and you won't notice any difference. The great thing is that there always seems to be good information online about anything you might run into anyway. I wouldn't worry much at all about "the migration of data from MySQL to MariaDB."

(Curious if user1824987 made the move and if so if they found any way they were impacted by it.)

分享给朋友:
您可能感兴趣的文章:
随机阅读: