MACのホームディレクトリでmysqlをスタートできません。 mysql.server start -bash: mysql.server: command not found

Question

MACでmysqlをスタートできません。

ホームディレクトリに、
①$ brew update
②$ brew install mysql
③$ brew info mysql
mysql: stable 5.7.22 (bottled), devel 8.0.4-rc
Open source relational database management system
https://dev.mysql.com/doc/refman/5.7/en/
Conflicts with:
mariadb (because mysql, mariadb, and percona install the same binaries.)
mariadb-connector-c (because both install plugins)
mysql-cluster (because mysql, mariadb, and percona install the same binaries.)
mysql-connector-c (because both install MySQL client libraries)
percona-server (because mysql, mariadb, and percona install the same binaries.)
/usr/local/Cellar/mysql/5.7.22 (317 files, 234.2MB)
Poured from bottle on 2018-05-19 at 15:57:41
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✔
Required: openssl ✔
==> Requirements
Required: macOS >= 10.7 ✔
==> Options
--with-debug
Build with debug support
--with-embedded
Build the embedded server
--with-local-infile
Build with local infile loading support
--with-memcached
Build with InnoDB Memcached plugin
--with-test
Build with unit tests
--devel
Install development version 8.0.4-rc
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
mysql -uroot

To have launchd start mysql now and restart at login:
brew services start mysql
Or, if you don't want/need a background service you can just run:
mysql.server start

④mysql.server start
-bash: mysql.server: command not found

接続させる方法を教えて下さい。
宜しくお願い致します。

Comments

[fiwa]

brew doctor で symlink が張られているか確認してみることをお勧めします。https://qiita.com/ryochang/items/38dcec0fb3f4dcbee2e1

[black-to]

ありがとうございます。

[black-to]

brew link mysql Linking /usr/local/Cellar/mysql/5.7.22... Error: Could not symlink include/mysql /usr/local/include is not writable.

[black-to]

sudo mkdir /usr/local/include Password: mkdir: /usr/local/include: File exists
$ sudo chmod g+w
$ sudo chown :admin /usr/local/include
$ brew link mysql
Linking /usr/local/Cellar/mysql/5.7.22... Error: Could not symlink lib/libmysqlclient.20.dylib

まだエラーが出てしまいます。
宜しくお願い致します。

Answer 1

homebrew が使用する /usr/local 内のサブディレクトリの権限がうまく設定されていない感じですので、以下のコマンドをお試し下さい。

cd /usr/local && sudo chown -R $(whoami) bin etc include lib sbin share var Frameworks

Troubleshooting — Homebrew Documentation

Answer 2

Pathが通ってないんじゃないですか？