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

1 vote187 views1 answer
Oracle sql listagg
SQL
1 vote198 views2 answers
Reset mysqli fetch_arra
SQL
11 votes217 views2 answers
Set default column value sql
SQL
1 vote226 views1 answer
Ubuntu access database from terminal
SQL
1 vote218 views1 answer
Mysql select and count left join
SQL
0 vote291 views1 answer
Having all mysql
SQL
0 vote198 views1 answer
Mysql root permission denied lost
SQL
0 vote227 views1 answer
Renommer schema sql
SQL
0 vote191 views1 answer
Char varchar nvarchar sql
SQL
0 vote197 views1 answer
Postgres in operator with comma separated values
SQL