![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
開発環境はMacOSでHomebrewを使ってMySQLをインストールしています。
2021-06-20T02:22:59.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql dyld: Library not loaded: /usr/local/opt/protobuf/lib/libprotobuf-lite.26.dylib Referenced from: /usr/local/opt/mysql/bin/mysqld Reason: image not found
$ ls /usr/local/Cellar/protobuf/3.17.3/lib libprotobuf-lite.28.dylib libprotoc.28.dylib libprotobuf-lite.a libprotoc.a libprotobuf-lite.dylib libprotoc.dylib libprotobuf.28.dylib pkgconfig libprotobuf.a python3.9 libprotobuf.dylib
$ ls /usr/local/Cellar/protobuf/3.15.8/lib libprotobuf-lite.26.dylib libprotoc.26.dylib libprotobuf-lite.a libprotoc.a libprotobuf-lite.dylib libprotoc.dylib libprotobuf.26.dylib pkgconfig libprotobuf.a python3.9 libprotobuf.dylib
$ brew unlink protobuf $ brew tap-new foo/taps $ brew extract protobuf foo/taps --version 3.15.8 $ brew install foo/taps/protobuf@3.15.8 $ brew info protobuf@3.15.8
$ touch /tmp/mysql.sock
mysql.sockファイルを作成する（この段階で動くことが大半） sudo touch /tmp/mysql.sock
2024-03-15T10:43:52.290000Z 0 [ERROR] [MY-012153] [InnoDB] Trying to access page number 1768842507 in space 4294967278, space name innodb_undo_002, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, LOCK TABLES if the --single-transaction option is not used, and (as of MySQL 8.0.21) PROCESS if the --no-tablespaces option is not used. Certain options might require other privileges as noted in the option descriptions.
$ mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
$ unset MYSQL_PWD
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1006) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
