1、安装数据库
2、登录mysql数据库
mysql -uusername -ppassword
修改密码:2.1 登录即可修改,set password = password('newpassword')
2.2 sql语句修改,update mysql.user set password = password('newpassword') where user = 'root' and host = 'localhost';
flush privileges;
2.3 mysqladmin修改,mysqladmin -uroot -poldpassword password 'newpassword';
3、查看字符集:select variables like '%charac%';
4、查看版本:select version();
5、查看登录用户:select user();
5.1 用户授权:grant select,insert,delete,update on tableName.* to userName@'hostName' identified by 'password' ;
5.2 回收权限 revoke select on tableName from userName@'hostName';
6、查看数据库:show databases;
7、选择数据库:use databaseName;
8、查看表单:show tables;
待续。。。