- Richard Feynman -
Difference between revisions of "Mariadb on cygwin"
(→Preparations) |
|||
| Line 7: | Line 7: | ||
Launch the [[cygwin]] setup program and install the package <code>mysql</code>. | Launch the [[cygwin]] setup program and install the package <code>mysql</code>. | ||
| + | |||
| + | == Using MariaDB client == | ||
[[File:Mysql-mamp.png|thumb|400px|MariaDB client connecting to MySQL]] | [[File:Mysql-mamp.png|thumb|400px|MariaDB client connecting to MySQL]] | ||
| Line 14: | Line 16: | ||
</source> | </source> | ||
| + | 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: | ||
| + | <source lang="bash"> | ||
| + | mysql -p -u root -h 127.0.0.1 --password="password" | ||
| + | </source> | ||
| + | ''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: | ||
| + | <source lang="bash"> | ||
| + | mysqlc() { echo "$*" | mysql -p -u root -h 127.0.0.1 --password="password" ; } | ||
| + | </source> | ||
| + | |||
| + | With the function above you can execute SQL commands like this: | ||
| + | <source lang="bash"> | ||
| + | mysqlc "SELECT * FROM members" | ||
| + | </source> | ||
= MariaDB Server = | = MariaDB Server = | ||
Latest revision as of 13:36, 27 June 2017
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
