add zsh

2 files changed, 28 insertions, 0 deletions

diff --git a/oh-my-zsh/plugins/mysql-macports/README.md b/oh-my-zsh/plugins/mysql-macports/README.md
new file mode 100644
index 0000000..ff4fb3a
--- /dev/null
+++ b/oh-my-zsh/plugins/mysql-macports/README.md
@@ -0,0 +1,20 @@
+# MySQL-Macports plugin
+
+This plugin adds aliases for some of the commonly used [MySQL](https://www.mysql.com/) commands when installed using [MacPorts](https://www.macports.org/) on macOS.
+
+To use it, add `mysql-macports` to the plugins array in your zshrc file:
+
+```zsh
+plugins=(... mysql-macports)
+```
+
+For instructions on how to install MySQL using MacPorts, read the [MacPorts wiki](https://trac.macports.org/wiki/howto/MySQL/).
+
+## Aliases
+
+| Alias        | Command                              | Description                                |
+| ------------ | ------------------------------------ | ------------------------------------------ |
+| mysqlstart   | `sudo /path/to/mysql.server start`   | Start the MySQL server.                    |
+| mysqlstop    | `sudo /path/to/mysql.server stop`    | Stop the MySQL server.                     |
+| mysqlrestart | `sudo /path/to/mysql.server restart` | Restart the MySQL server.                  |
+| mysqlstatus  | `mysqladmin5 -u root -p ping`        | Check whether the MySQL server is running. |
diff --git a/oh-my-zsh/plugins/mysql-macports/mysql-macports.plugin.zsh b/oh-my-zsh/plugins/mysql-macports/mysql-macports.plugin.zsh
new file mode 100644
index 0000000..c39563f
--- /dev/null
+++ b/oh-my-zsh/plugins/mysql-macports/mysql-macports.plugin.zsh
@@ -0,0 +1,8 @@
+# commands to control local mysql-server installation
+# paths are for osx installation via macports
+
+alias mysqlstart='sudo /opt/local/share/mysql5/mysql/mysql.server start'
+alias mysqlstop='sudo /opt/local/share/mysql5/mysql/mysql.server stop'
+alias mysqlrestart='sudo /opt/local/share/mysql5/mysql/mysql.server restart'
+
+alias mysqlstatus='mysqladmin5 -u root -p ping'