mysql常见命令

 mysql>show variables like 'character_set_%';//查看变量 mysql>source d:/mysql.sql;//引人外部sqlmysql>flush privilegesmysql>update user set password=password('123456') where user='root'; //修改密码