Never confuse education with intelligence, you can have a PhD and still be an idiot.
- Richard Feynman -



Difference between revisions of "Mariadb on cygwin"

From Juneday education
Jump to: navigation, search
(Created page with " = Installation = == Preparations == # Disable your windows firewall. # Start a cygwin terminal (running bash). == Procedure == First, we need to install the Mar...")
 
(Preparations)
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
  
= Installation =
+
= MariaDB client =
 +
 
 +
== Preparations ==
 +
 
 +
# Start a [[cygwin]] terminal (running [[bash]]).
 +
 
 +
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]]
 +
To connect to Mamp's MySQL:
 +
<source lang="bash">
 +
mysql -p -u root -h 127.0.0.1
 +
</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 =
  
 
== Preparations ==  
 
== Preparations ==  
  
# Disable your windows firewall.
 
 
# Start a [[cygwin]] terminal (running [[bash]]).
 
# Start a [[cygwin]] terminal (running [[bash]]).
  
 
== Procedure ==  
 
== Procedure ==  
  
First, we need to install the MariaDB software. This command may take some minutes to complete.
+
Launch the [[cygwin]] setup program and install the package <code>mysqld</code>. Now we need to install the MariaDB software with the following command.
 
<source lang="bash">
 
<source lang="bash">
 
mysql_install_db
 
mysql_install_db
 
</source>
 
</source>
 +
''Note: This command may take some minutes to complete.''
  
 
Now, we start the MariaDB server.  
 
Now, we start the MariaDB server.  
Line 18: Line 50:
 
mysqld_safe &
 
mysqld_safe &
 
</source>
 
</source>
 
 
''Note: You might get a firewall notice if the firewall is up and running!''
 
''Note: You might get a firewall notice if the firewall is up and running!''
  
Line 26: Line 57:
 
</source>
 
</source>
 
When this script is executing you will get a couple of questions.
 
When this script is executing you will get a couple of questions.
 +
<source lang="text">
 +
aslklasdj
 +
</source>

Latest revision as of 13:36, 27 June 2017

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