mac use mysql through terminal code example

Example 1: mac install mysql

brew install mysql

sudo chown -R _mysql:mysql /usr/local/var/mysql
sudo mysql.server start

sudo mysql
// set password for root user, or change root to another user
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

exit
mysql -u root -p

Example 2: how to run mysql on terminal mac

sudo sh -c 'echo /usr/local/mysql/bin > /etc/paths.d/mysql'

Tags:

Shell Example

Related