**1.初次启动**#mysqlmysql> update mysql.user set authentication_string='newpass',plugin='mysql_native
**1.初次启动**#mysqlmysql> update mysql.user set authentication_string='newpass',plugin='mysql_native_password ' where user='root';mysql> flush privileges;mysql> exit;$ mysql -u root -p //本地登陆$ mysql -u love -p -h ip //远程登陆**2.用户操作**mysql> use mysql;mysql> create user 'love'@'localhost' identified by 'love'; //创建用户mysql> flush privileges;mysql> grant all on mysql.user to love@localhost; //授权mysql> show grants for love@localhost; //查看授权mysql> revoke all on mysql.user from love@localhost; //取消授权mysql> update user set authentication_string='newpass' where user='love'; //修改密码 mysql> delete from user where user='love'; //删除用户 mysql> drop user love@localhost; //删除用户**3.查询** mysql> show databases; //查询数据库（根据用户权限） mysql> show tables; //查询当前数据库有哪些表 mysql> show columns from user; //查询user表所有列的列名和属性 mysql> select count(*) from user; //查询有多少条记录4.DDL数据定义mysql> create database abc; //创建数据库abcmysql> create table user_info( //创建user_info表 >> id int primary key, //id列int类型, 主键 >> name varchar(255) unique， // name列字符串类型，唯一约束 >> family text not null); //family列text类型，非空mysql> alter table user_info rename to info; //改表名mysql> alter table info add phone int; //增加列mysql> alter table info change column phone pho int; //改列名mysql> alter table info drop column phone; //删除列5.DML数据操作mysql> insert into t1mysql> delete from t1mysql> update t1 set mysql> select id from t1