Mariadb mac os install

Installing MariaDB Server on macOS Using Homebrew

Contents

MariaDB Server is available for installation on macOS (formerly Mac OS X) via the Homebrew package manager.

MariaDB Server is available as a Homebrew «bottle», a pre-compiled package. This means you can install it without having to build from source yourself. This saves time.

After installing Homebrew, MariaDB Server can be installed with this command:

After installation, start MariaDB Server:

To auto-start MariaDB Server, use Homebrew’s services functionality, which configures auto-start with the launchctl utility from launchd:

After MariaDB Server is started, you can log in as your user:

Or log in as root:

Upgrading MariaDB

First you may need to update your brew installation:

Then, to upgrade MariaDB Server:

Building MariaDB Server from source

In addition to the «bottled» MariaDB Server package available from Homebrew, you can use Homebrew to build MariaDB from source. This is useful if you want to use a different version of the server or enable some different capabilities that are not included in the bottle package.

Two components not included in the bottle package (as of MariaDB Server 10.1.19) are the CONNECT and OQGRAPH engines, because they have non-standard dependencies. To build MariaDB Server with these engines, you must first install boost and judy . As of December 2016, judy is in the Homebrew «boneyard», but the old formula still works on macOS Sierra. Follow these steps to install the dependencies and build the server:

You can also use Homebrew to build and install a pre-release version of MariaDB Server (for example MariaDB Server 10.2, when the highest GA version is MariaDB Server 10.1). Use this command to build and install a «development» version of MariaDB Server:

Источник

Installing MariaDB Server on Mac OS X with Homebrew

Back in 2016, we blogged about deploying MariaDB 10.1.16 on Mac OS X with Homebrew. Homebrew now includes MariaDB 10.4, 10.3, 10.2, and 10.1 for macOS. We’ve refreshed this blog to reflect the latest technology. If you need the old blog, you can find it here.

1. Install Xcode

Run xcode-select —install .

2. Install Homebrew

Run /bin/bash -c «$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)» .

3. Check Homebrew

Run brew doctor . Follow on-screen instructions to fix warnings if necessary.

4. Update Homebrew

Run brew update .

5. Verify MariaDB version in Homebrew repo

Run brew info mariadb .

6. Install MariaDB

Run brew install mariadb . Follow on-screen instructions to upgrade if necessary to upgrade a previously installed version.

7. Run the database installer

Run mysql_install_db . Follow on-screen instructions to upgrade if necessary to upgrade a previously installed version.

8. Start MariaDB

Run mysql.server start .

9. Secure the installation

If you are installing MariaDB 10.4.6 or later:
Run mariadb-secure-installation .
If you are installing an earlier version of MariaDB:
Run mysql_secure_installation .

NOTE: If you are unsure about using unix_socket, do not enable it when asked.
NOTE: Set a root password even if the on-screen instructions tell you it is safe not to do so.

10. Connect to MariaDB

Run mariadb -u root -p .

If you’ve installed an older version of mariadb you may need to use “mysql -u root -p” in the above command.

Источник

Database.Guide

Categories

Install MariaDB on a Mac

Here’s how to install MariaDB on a Mac via the Homebrew package manager.

Install Homebrew

First, let’s install Xcode and Homebrew. Feel free to skip this step if you’ve already got Homebrew installed.

To install these prerequisites, open a Terminal window and run the following commands.

That’s it. Xcode and Homebrew should be installed once those commands have been run.

But before we move on, here’s how to check Homebrew:

Follow any prompts to fix any problems that may have been encountered.

While we’re at it, here’s how to update Homebrew:

If you’re already up to date, you’ll get a message to that effect.

Install MariaDB

Now that Homebrew is installed, let’s go ahead and install MariaDB.

First, let’s check the MariaDB version in the Homebrew repo:

That will output a bunch of stuff, including the MariaDB version in the repo.

Now here’s the part that actually installs MariaDB:

If you have a previous version of MariaDB, follow the prompts to upgrade to the latest version.

Start MariaDB

Now that we’ve installed MariaDB, let’s start it:

To auto-start MariaDB Server, we can use Homebrew’s services functionality, which configures auto-start with the launchctl utility from launchd :

Connect to MariaDB

Once MariaDB has started, we can connect to it:

Once connected, you should see something like this:

Here’s an example of a quick command you can use to see a list of databases:

Источник

Installing MariaDB with MySQL on Mac

I am trying to install MariaDB on my Mac using brew. However, I am struggling to get this installed due to it conflicting with MySQL. I was wondering whether anyone can advise how to set it up so I have both MariaDB and MySQL as I will need both on my machine as I work on multiple projects which need to use one or the other.

2 Answers 2

If you run brew info, it will even warn you not to install them side by side because they will conflict:

In fact, run brew info mariadb and it will say it is a Drop-in Replacement :

What is a Drop-in Replacement? It refers to the ability to replace one software component with another one without any other code or configuration changes being required and resulting in no negative impacts.

Consequently, both mysql and mariadb run with mysql.server start , both log into mysql using mysql -h localhost -u root -p , both reference the same data directory at /usr/local/var/mysql , both use the same commands such as mysqldump , all of which indicates that the two operate interchangeably. They cannot coincide, unless you install them on different virtual machines like vmware or run them in a docket container (which was suggested in the other answer).

But if you cannot run them on separate virtual machines or in a docket container, then I strongly recommend removing MySQL and using MariaDB, since MariaDB keeps compatibility with MySQL, but also contains other features such as CHECK CONSTRAINTS .

This is how you would remove MySQL and install MariaDB instead. Note in my system I was using mysql@5.7 via HomeBrew so I specify that instead of mysql:

And that’s it. Some guides suggest to remove individual directories such as this:

But on my system, I did not have MySQL in my Preference Pane or in Launch or even auto started. So the only other place I had it was the actual database data in /usr/local/var:

But since MariaDB is a Drop-In Replacement, you don’t need to delete this data and MariaDB will use it once installed.

So to install MariaDB:

So as you can see from the install and also by running brew info mariadb , mariadb has been installed at

And the mysql executable in your $PATH is pointing to that MariaDB binary:

For me, since I already had a data directory with mysql@5.7, MariaDB was able to use it and I still had access to my data (albeit it is still encouraged to back up the database with mysqldump prior to removing mysql):

Источник

Настройка окружения для web-разработки на Mac OS X

Установку необходимого софта будем производить с использованием менеджера недостающих пакетов для macOS — Homebrew. Если он у вас еще не устанолен, сперва ставим Xcode через AppStore либо в терминале набираем команду:

согласившись с лицензионным соглашением.

Установка Homebrew

Открываем терминал (вместо стандартного я использую ITerm2) и запускаем установку командой:

После установки обновляемся, проверяем все ли в порядке:

В качестве сервера баз данных я решил использовать MariaDB.

Cтавим MariaDB:

Выпоним первоначальную настройку сервера:

и проверяем подключение:

Займемся web сервером nginx:

Настройка nginx и создание структуры директорий.

Для виртуальных хостов я использую следующую структуру (вы можете использовать другую, удобную вам но не забудьте исправить пути в конфигах!):

Конфигурационные файлы вирутальных хостов.

Я использую следующую схему:

После установки nginx, в директории /usr/local/etc/nginx/ имеется стандартный конфигурационный файл nginx.conf. Приведем его к следуюущему виду:

Далее пишем конфигурацию виртуального хоста в директории /usr/local/etc/nginx/sites-available/

Создаем символьную ссылку:

Установка PHP

Если используете zsh то:

либо (в зависимости от того какой используется шел)

Версии должны быть одинаковыми!

Далее создадим файл index.php для проверки:

В адресной строке браузера набираем localhost и смотрим результат. Чтобы сервисы автоматически запускались после перезагрузки:

Вот вроде бы и все. Если возникнут вопросы, пишите в комментариях либо через форму обратной связи на странице контактов.

Источник