MySQL8.0ほど糞な代物はない
5.x系に比べて速度が２倍になったとかほざいているけど
動作しなかったら意味ないよね・・・
/usr/local/var/mysql内の
MacBook-puro.local.errを
開いたらこんな感じのエラー
本当にエラーをトレースしてもトレースしても・・・
次々に不具合が出てくる。もうやっつけるのに疲れました。
ダウングレードすることにしました。
socketやらユーザー認証やら・・・etc
リリースしたばかりの時は、やはり互換性があるのかどうか慎重に検討しなくてはいけない。
StackOverFlow界隈でもハマってる人ばかりでダウングレードする人が多かったのもギブアップする要因になりました( ・∇・)
2018-07-18T14:17:41.209694Z 0 [System] [MY-010931] [Server] /usr/local/Cellar/mysql/8.0.11/bin/mysqld: ready for connections. Version: '8.0.11' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
2018-07-20T13:51:22.6NZ mysqld_safe Logging to '/usr/local/var/mysql/macbookpuro.err'.
2018-07-20T13:51:23.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
2018-07-20T13:51:23.651744Z 0 [System] [MY-010116] [Server] /usr/local/Cellar/mysql/8.0.11/bin/mysqld (mysqld 8.0.11) starting as process 10283
2018-07-20T13:51:23.685666Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2018-07-20T13:51:23.867461Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:24.867879Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:25.869374Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:26.869812Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:27.870095Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:28.871659Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:29.874531Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:30.876362Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:51:31.876658Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:53:04.174389Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35
2018-07-20T13:53:04.174526Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 35 in a file operation.
2018-07-20T13:53:04.174595Z 1 [ERROR] [MY-012596] [InnoDB] InnoDB: Error number 35 means 'Resource temporarily unavailable'
2018-07-20T13:53:04.174661Z 1 [ERROR] [MY-012215] [InnoDB] InnoDB: Cannot open datafile './ibdata1'
2018-07-20T13:53:04.174732Z 1 [ERROR] [MY-012959] [InnoDB] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
$ php artisan migrate
Illuminate\Database\QueryException : SQLSTATE[HY000] [1044] Access denied for user 'laravel'@'localhost' to database 'test' (SQL: select * from information_schema.tables where table_schema = test and table_name = migrations)
at /Users/potato/test/test/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
660| // If an exception occurs when attempting to run a query, we'll format the error
661| // message to include the bindings with SQL, which will make this exception a
662| // lot more helpful to the developer instead of just the database's errors.
663| catch (Exception $e) {
> 664| throw new QueryException(
665| $query, $this->prepareBindings($bindings), $e
666| );
667| }
668|
Exception trace:
1 PDOException::("SQLSTATE[HY000] [1044] Access denied for user 'laravel'@'localhost' to database 'test'")
/Users/potato/test/test/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
2 PDO::__construct("mysql:unix_socket=/tmp/mysql.sock;dbname=test", "laravel", "laravel", [])
/Users/potato/test/test/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
Please use the argument -v to see more details.
