Mysql.sock disappeared.

Asked 1 years ago, Updated 1 years ago, 42 views

When I updated my Mac to High Sierra, the mysql.sock under /tmp disappeared.
I thought it would be fixed after uninstalling and reinstalling, but the sock file was not generated.
That's why I can't use mysql. What should I do?

Additional
homebrew may be bad.brew info mysql received the following error:

 mysql: stable 5.7.20 (bottled), develop 8.0.3-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.20 (324 files, 233.7MB)*
  Pouled from bottle on 2017-11-25 at 09:34:57
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
== > Dependencies
Build: cmake✘
Required: openssl✔
==>Requirements
Required: macOS>=10.7✔
== > Options
--with-archive-storage-engine
    Compile with the ARCHIVE storage engine enabled
--with-blackhole-storage-engine
    Compile with the BLACKHOLE storage engine enabled
--with-debug
    Build with debug support
--with-embedded
    Build the embedded server
--with-local-infile
    Build with local info loading support
--with-test
    Build with unit tests
--develop
    Install development version 8.0.3-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 macos

2022-09-30 20:20

1 Answers

I solved myself.
If it is root, mysql server could not be started.
Resolved after all permissions have been changed to my username.


2022-09-30 20:20

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.