- install
google instal mysql community mac - start server
cd /usr/local/mysql-8.0.25-macos11-x86_64/support-files
sudo ./mysql.server start
sudo killall mysqld
cd /usr/local
sudo chown -R mysql mysql-8.0.25-macos11-x86_64
cd mysql-8.0.25-macos11/support-files
sudo ./mysql.server start - log in
cd /usr/local/mysql-8.0.25-macos11-x86_64/bin
./mysql -u root -p - log out
mysql> exit - list databases
mysql> show databases; - create database
mysql> create database test_db; - change/switch database
mysql> use test_db; - list tables
mysql> show tables; - create user
-- login as root user
mysql> create user 'test'@'localhost' identified by 'test0'; - grant privileges to user
mysql> grant all privileges on test_db.* to 'test'@'localhost';
mysql> flush privileges;
mysql> exit;
./mysql -u test -p
mysql> show databases; -- should be able to see test_db but not sys
网友评论