Mariadb on cygwin

MariaDB client

Preparations

1. Start a cygwin terminal (running bash).

Launch the cygwin setup program and install the package mysql.

Using MariaDB client

MariaDB client connecting to MySQL

To connect to Mamp's MySQL:

mysql -p -u root -h 127.0.0.1

If you want the command to be non-interactive you can supply the password on the command line. It is important to understand that this is not a secure solution:

mysql -p -u root -h 127.0.0.1 --password="password"

Note: in the command line above we assume your password is "password"

If you want to take this one step further you can write a bash function:

mysqlc() { echo "$*" | mysql -p -u root -h 127.0.0.1 --password="password" ; }

With the function above you can execute SQL commands like this:

mysqlc "SELECT * FROM members"

MariaDB Server

Preparations

1. Start a cygwin terminal (running bash).

Procedure

Launch the cygwin setup program and install the package mysqld. Now we need to install the MariaDB software with the following command.

mysql_install_db

Note: This command may take some minutes to complete.

Now, we start the MariaDB server.

mysqld_safe &

Note: You might get a firewall notice if the firewall is up and running!

To finish things off we secure the installation:

mysql_secure_installation

When this script is executing you will get a couple of questions.

aslklasdj