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

0 vote150 views1 answer
Mysql random number between 1 and 100
SQL
0 vote139 views1 answer
Exclude last comma separated string mysql
SQL
0 vote144 views1 answer
We are intrested to work with your organization
SQL
1 vote153 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
13 votes199 views3 answers
Mysqldump structure only
SQL
40 votes210 views6 answers
Update table mysql
SQL
2 votes159 views3 answers
How do I add a user to a postgres database? cli
SQL
-1 vote140 views1 answer
Ssql to lowercqse
SQL
0 vote181 views4 answers
Rownum in sql
SQL
0 vote166 views1 answer
How to get parent and child record in single query using sql
SQL