mysql 忘记root密码怎么办

2012-01-15 YY.K Permalink
如果忘记root密码或其他用户密码，不要急，按下面操作即可。
1. 编辑mysql主配置文件 my.cnf
vim /etc/my.cnf  
在[mysqld]字段下添加参数  skip-grant  
2. 重启数据库服务
service mysqld restart
3. 这样就可以进入数据库不用授权了
mysql -uroot
4. 修改相应用户密码
use mysql;
update user set password=password(your password) where user="root";
flush privileges;
none
本文固定链接mysql 忘记root密码怎么办，你还可以查看Linux目录下的所有文章， 转载请声明文章来自kog.lol。 
database is locked
Typecho\Db\Adapter\SQLException: database is locked in /home/kvmla/htdocs/kvm.la/var/Typecho/Db/Adapter/SQLite.php:88
Stack trace:
#0 /home/kvmla/htdocs/kvm.la/var/Typecho/Db.php(394): Typecho\Db\Adapter\SQLite->query()
#1 /home/kvmla/htdocs/kvm.la/var/Typecho/Db.php(426): Typecho\Db->query()
#2 /home/kvmla/htdocs/kvm.la/var/Widget/Comments/Archive.php(116): Typecho\Db->fetchAll()
#3 /home/kvmla/htdocs/kvm.la/var/Typecho/Widget.php(155): Widget\Comments\Archive->execute()
#4 /home/kvmla/htdocs/kvm.la/var/Typecho/Widget.php(187): Typecho\Widget::widget()
#5 /home/kvmla/htdocs/kvm.la/var/Widget/Archive.php(844): Typecho\Widget::alloc()
#6 /home/kvmla/htdocs/kvm.la/usr/themes/xmchen/comments.php(2): Widget\Archive->comments()
#7 /home/kvmla/htdocs/kvm.la/var/Widget/Archive.php(1308): require('...')
#8 /home/kvmla/htdocs/kvm.la/usr/themes/xmchen/post.php(36): Widget\Archive->need()
#9 /home/kvmla/htdocs/kvm.la/var/Widget/Archive.php(1390): require_once('...')
#10 /home/kvmla/htdocs/kvm.la/var/Typecho/Router.php(88): Widget\Archive->render()
#11 /home/kvmla/htdocs/kvm.la/index.php(23): Typecho\Router::dispatch()
#12 {main}