title: mariadb server: I can't stop the server with `mysql.server stop`
body: <p>OSX 10.13.6</p>
  
  <p>I installed mariadb sever with homebrew a few years ago, and I use it infrequently.  Today, I tried to start mariadb using the command:</p>
  
  <pre><code>$ mysql.server start
  </code></pre>
  
  <p>and I got a bunch of errors.  So, I did:</p>
  
  <pre><code>$ brew update
  </code></pre>
  
  <p>then:</p>
  
  <pre><code>$ brew uprade mariadb
  </code></pre>
  
  <p>That completed fine, and now I can start mariadb with:</p>
  
  <pre><code>$ mysql.server start
  </code></pre>
  
  <p>and I can access all my old db's.  </p>
  
  <p>The problem I'm having is that I cannot stop mysql.  Both these commands hang:</p>
  
  <pre><code>$ mysql.server stop
  </code></pre>
  
  <p>and(in another terminal window):</p>
  
  <pre><code>$ mysql.server status
  </code></pre>
  
  <p>According to the MariaDB docs for <a href="https://mariadb.com/kb/en/library/mysqlserver/" rel="nofollow noreferrer">mysql.server</a>, both those commands should work.</p>
  
  <p>Currently, I'm killing the server like this:</p>
  
  <pre><code>$ killall mysqld mysqld_safe
  </code></pre>
  
  <p>then checking that the server was killed with this:</p>
  
  <pre><code>$ ps aux | grep mysqld
  </code></pre>
  
  <p>When I run the ps command when mysql is running, I get:</p>
  
  <blockquote>
    <p>~$  ps aux | grep mysqld<br>
    7stud   3707   0.0  1.0  4808208 79948 s005  S     1:26PM   0:00.47<br>
    /usr/local/Cellar/mariadb/10.3.15/bin/mysqld
    --basedir=/usr/local/Cellar/mariadb/10.3.15 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mariadb/10.3.15/lib/plugin --log-error=/usr/local/var/mysql/My-MacBook-Pro-2.local.err --pid-file=/usr/local/var/mysql/My-MacBook-Pro-2.local.pid </p>
    
    <p>7stud   3643   0.0  0.0  4287792   1460 s005  S     1:26PM   0:00.02 /bin/sh
    /usr/local/Cellar/mariadb/10.3.15/bin/mysqld_safe
    --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/My-MacBook-Pro-2.local.pid </p>
    
    <p>7stud   4544   0.0  0.0  4267752    880    s000  S+    1:41PM   0:00.00<br>
    grep mysqld</p>
  </blockquote>
  
  <p>What is the proper way to shut down the mariadb server?</p>
  
  <pre><code>mysql&gt; 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)
  </code></pre>