MySQL操作整理

1、cd 到mysql安装目录中的bin目录下

mysql -hlocalhost -uroot -pyourpwd

eg:

2、mysql 局域网访问授权

mysql 8.0版本

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

<mysql8.0版本

GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;