README.md 1.15 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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 /opt/local/share/mysql5/mysql/mysql.server start`   | Start the MySQL server.                    |
| mysqlstop    | `sudo /opt/local/share/mysql5/mysql/mysql.server stop`    | Stop the MySQL server.                     |
| mysqlrestart | `sudo /opt/local/share/mysql5/mysql/mysql.server restart` | Restart the MySQL server.                  |
| mysqlstatus  | `mysqladmin5 -u root -p ping`                             | Check whether the MySQL server is running. |