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

Similar codes

11 votes327 views2 answers
Sql between date range
SQL
3 votes348 views1 answer
Mysql set field unique
SQL
0 vote404 views1 answer
Sql check if field is not null
SQL
5 votes391 views3 answers
Sql server utc to local
SQL
0 vote291 views0 answer
How to connect to datbase in springboot
SQL
13 votes353 views2 answers
Sqlite rename table
SQL
1 vote346 views1 answer
Can not connect to mysql server
SQL
1 vote347 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote379 views1 answer
How to map sql column to custom names
SQL
0 vote342 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL