mySQL 操作语句

获取临时密码
mysqld --initialize --user=mysql --console

启动MySQL
net start mysql

下载
mysqld --install

删除
mysqld --remote

登录
mysql -uroot -p

修改密码
mysqladmin -u root -p password root

更改加密方式
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;

更改密码
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;

刷新
mysql> FLUSH PRIVILEGES;