修改密码
update user set password=password("") where user="root";
update user set password=password("password") where user="root" and host="localhost";
flush privileges;
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('passwd');
增加用户
grant all on dbname.* to 'root'@'localhost' identified by 'password' WITH GRANT OPTION;
数据导出导入
mysqldump database table -uroot -p > b.sql
mysql database < b.sql
mysql 修复优化数据库
#mysqlcheck -A -o -r -uroot -p** //-a alldatabase -o optimize -r repair
#myisamchk -r -s *.MYI
mysqladmin -uroot -p -i 3 proc -S /tmp/mysql.sock
忘记root密码的修改方法
停掉mysql,重新起动,加参数:--skip-grant-tables,这样就可以不用密码进去了.进去后就可以用上面的命令修改root密码.
mysqladmin ext -r -i 30 是采集30秒间隔的差值
mysqladmin ext -r -i 5 | grep hand
mysqladmin extend-status --relative --sleep=1 | grep handler