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

3 votes163 views1 answer
Sql server version query
SQL
5 votes161 views1 answer
Sqlite alter table add column
SQL
3 votes215 views2 answers
How to open postgresql in windows
SQL
5 votes162 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote161 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote161 views1 answer
Shrink database file in sql server
SQL
8 votes164 views1 answer
Oracle search source code
SQL
0 vote164 views1 answer
Sql quary intervewi question
SQL
1 vote178 views1 answer
Mysql return if it contains
SQL
1 vote186 views1 answer
Mysql find tables with column name
SQL