mariadb服务器：我不能用'mysql.server stop'停止服务器

Question

OSX 10.13.6

$ mysql.server start

$ brew update

$ brew uprade mariadb

$ mysql.server start

$ mysql.server stop

并且（在另一个终端窗口中）：

$ mysql.server status

根据mysql.server的MariaDB文档，这两个命令都应该工作。

目前，我正在像这样杀死服务器：

$ killall mysqld mysqld_safe

$ ps aux | grep mysqld

7stud 4544 0.0 0.0 4267752 880 s000 s+1:41 pm 0:00.00
grep mysqld

关闭mariadb服务器的正确方法是什么？

mysql> SHOW VARIABLES LIKE '%vers%';
+---------------------------------+------------------------------------------+
| Variable_name                   | Value                                    |
+---------------------------------+------------------------------------------+
| innodb_version                  | 10.3.15                                  |
| protocol_version                | 10                                       |
| slave_type_conversions          |                                          |
| system_versioning_alter_history | ERROR                                    |
| system_versioning_asof          | DEFAULT                                  |
| thread_pool_oversubscribe       | 3                                        |
| version                         | 10.3.15-MariaDB                          |
| version_comment                 | Homebrew                                 |
| version_compile_machine         | x86_64                                   |
| version_compile_os              | osx10.13                                 |
| version_malloc_library          | system                                   |
| version_source_revision         | 07aef9f7eb936de2b277f8ae209a1fd72510c011 |
| version_ssl_library             | OpenSSL 1.0.2r  26 Feb 2019              |
| wsrep_patch_version             | wsrep_25.24                              |
+---------------------------------+------------------------------------------+
14 rows in set (0.01 sec)

Answer 1

详情见https://stackoverflow.com/a/59938033/4579271。

若要修复，请运行：

cp /usr/local/bin/mysql.server /usr/local/bin/mysql.server.backup
sed -i "" "s/user='mysql'/user=\`whoami\`/g" /usr/local/bin/mysql.server