主页 / dba / 问题 / 214883
Accepted
Lee
Asked: 2018-08-15 04:50:05 +0800 CST

Homebrew MariaDB 服务器启动错误，带有“mysql.server start”

  • 772

在 MacOS 10.13.6 上启动 MariaDB 10.3.8 时，会出现以下奇怪行为：

mac:~user$ mysql.server start

Starting MariaDB

.180813 17:50:11 mysqld_safe Logging to '/usr/local/var/mysql/mbp.local.err'.

180813 17:50:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql.. ERROR!

ERROR 之前的输出中实际上还有很多点！被展示; 该过程需要几分钟。奇怪的是服务器确实运行。并且关机看起来很正常：

mac:~user$ mysql.server stop

Shutting down MariaDB.. SUCCESS!

知道如何确定是什么导致启动时出现错误消息并修复它吗？

mariadb mac-os-x

2 个回答

  1. Best Answer

    我可以重现你的问题。不要mysql.server start在 macOS中使用。

    如果您使用 安装 MariaDB ，请homebrew使用brew services来启动和停止数据库。它只需要一秒钟并且不会将奇怪的错误写入标准输出。

    brew services stop mariadb
Stopping `mariadb`... (might take a while)
==> Successfully stopped `mariadb` (label: homebrew.mxcl.mariadb)

brew services start mariadb
==> Successfully started `mariadb` (label: homebrew.mxcl.mariadb)

    自制服务概述：

    brew services list
Name     Status  User     Plist
logstash stopped
mariadb  started Kim /Users/Kim/Library/LaunchAgents/homebrew.mxcl.mariadb.plist
mysql    stopped

    一般帮助

    brew services --help
brew services command:
    Integrates Homebrew formulae with macOS' launchctl manager.

    [sudo] brew services list
    List all running services for the current user (or root)

    [sudo] brew services run formula|--all
    Run the service formula without starting at login (or boot).

    [sudo] brew services start formula|--all
    Start the service formula immediately and register it to launch at login (or boot).

    [sudo] brew services stop formula|--all
    Stop the service formula immediately and unregister it from launching at login (or boot).

    [sudo] brew services restart formula|--all
    Stop (if necessary) and start the service immediately and register it to launch at login (or boot).

    [sudo] brew services cleanup
    Remove all unused services.

    If sudo is passed, operate on /Library/LaunchDaemons (started at boot).
    Otherwise, operate on ~/Library/LaunchAgents (started at login).
    • 5

  2. 我通过将 .my.cnf 更改为：

    [client]
user=myname
password=mypwd
database=mydb

    至：

    [client]
user=myname
password=mypwd

[mysql]
database=mydb
    • 0

相关问题