mysql数据库文档详解

创建用户并授权： GRANT privileges ON databasename.tablename TO 'username'@'host' IDENTIFIED BY 'password'; 例: GRANT all ON estore.* TO 'itcast'@'localhost' IDENTIFIED BY 'itcast'; 查看数据库默认字符集： show variables like '%char%'; root用户改密码 格式：mysql> set password for 用户名@localhost = password('新密码'); 例子：mysql> set password for root@localhost = password('123'); 查看连接（Threads） DOS>mysqladmin -uroot -proot status mysql>show status like '%Threads_connected%';