How to start/stop/restart MySQL via terminal commands?

I've tried the following:

sudo /usr/local/mysql/support-files/mysql.server restart
Password:
ERROR! MySQL server PID file could not be found!
Starting MySQL
.Logging to '/usr/local/mysql/data/mycompx.err'.
.................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/data/mycompx.pid).

I've tried:

$ mysql.server start
zsh: command not found: mysql.server

And tried:

$ sudo service mysql stop
Password:
sudo: service: command not found

Here's path variables.

/Users/userName/.rvm/gems/ruby-2.3.0/bin:/Users/userName/.rvm/gems/ruby-2.3.0@global/bin:/Users/userName/.rvm/rubies/ruby-2.3.0/bin:/Users/userName/bin:/usr/local/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/DevDesktop/drush:/Users/userName/.rvm/bin

 

What OS/hosting platform is this running on?

 

Have you already tried just:
#mysql.server restart

 

What is the platform you running on ?

 

I'm running on OS X El Capitan version 10.11.5. I do not use MAMP or WAMP. I'm running it on my local machine at this point for local development only.

 

Yes, I tried that too. It didn't work. The only thing that works is if I restart my MacBook Pro.

 

Try with this one: /etc/init.d/mysqld stop

Here you have some more options: https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/amp/

 

I've the command:
sudo /usr/local/mysql/support-files/mysql.server restart

And I got: command not found

In my .zshrc file, I have the folowing:

export PATH=$HOME/bin:/usr/local/bin:/usr/local/mysql/bin:$PATH

#alias for Drush to know where php and mysql location
export DRUSH_PHP=/usr/local/bin/php
export DRUSH_SQL=/usr/local/mysql/bin/mysql

# Path to your oh-my-zsh installation.
export ZSH=/Users/charlie/.oh-my-zsh

 

I dont know much about mac os systems In your mysql config file (my.cnf) check where its pointed the pid-file. If its not there add it manually and created the dorectory (/var/mkdir /var/run/mysqld) and file ( /var/run/mysqld/mysqld.pid ) and set permission.

pid-file = /var/run/mysqld/mysqld.pid

Permission : chown -R mysql:mysql /var/run/mysqld


Source : http://serverfault.com/questions/480889/mysql-server-pid-file-could-not-be-found

Best Regards !

 

Is there a way to check if I have more than one MySQL installed on my machine? I think I've might have installed MySQL via brew and then I downloaded and manually installed MySQL again from the MySQL website. So, perhaps this may be the root issue of my situation. If I can use brew to manage my MySQL that I manually installed, I like to keep that. If not, then I need to uninstall the MySQL version that was installed by brew. But first, I need to verify if I have two versions or not and how do I do that?

 

You can view list of installed packages with brew by command "brew list" .

Best Regards !

 

/sbin/service mysqld restart