mysql命令速成

1.访问MySQL

dos> mysql --version
dos> mysql -u root -h 127.0.0.1 -P 3306 -p 
******root

2. 创建查看数据库

//创建、查看数据库
mysql> SELECT VERSION();
mysql> SHOW GLOBAL VARIABLES LIKE 'port';
mysql> CREATE DATABASE bugs;                //创建一个数据库bugs
mysql> SHOW DATABASES;
mysql> USE bugs;                            //访问数据库

3. 创建用户、密钥，并授权

//创建用户、密钥，并授权
mysql> USE bugs;
mysql> CREATE USER  bugs@localhost IDENTIFIED BY '123456' ;       //高版本8.0以上,创建一个用户bugs
mysql> SELECT host,user,plugin FROM mysql.user;
mysql> SELECT PASSWORD('bugs');                 //高版本8.0以上版本,去掉了select password()函数,bu再支持
mysql> GRANT ALL ON bugs.* TO bugs@localhost;   //为用户bugs授权 
//低版本5.7以下：mysql> GRANT select,insert,update,delete,index,alter,create,lock tables,drop,references ON bugs.* TO bugs@localhost IDENTIFIED BY '123456';
mysql> ALTER USER 'bugs'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
mysql> SELECT host,user,plugin FROM mysql.user;  
mysql> FLUSH PRIVILEGES;                        //刷新用户权限

root@ubuntu:/home/vmuser#    mysql -u root -e "GRANT ALL PRIVILEGES ON bugs.* TO bugs@localhost IDENTIFIED BY '123456'"

4. 用户密钥变更

//密码变更,：
mysql> ALTER USER 'bugs'@'localhost' IDENTIFIED BY '新密码'; 
mysql> ALTER USER 'bugs'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
mysql> FLUSH PRIVILEGES;                        //刷新用户权限

bugzilla: Bugzilla installation error with MySQL version 8.0 - Stack Overflow