- Richard Feynman -
Mariadb on cygwin
Contents
MariaDB client
Preparations
Launch the cygwin setup program and install the package mysql
.
Using MariaDB client
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
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