1-编辑mysql的配置文件/etc/mysql/my.cnf,在[mysqld]段下加入一行“skip-grant-tables”。2-重启mysql服务 @ubuntu:~$ sudo service mysql restart 3-用空密码进入mysql管理命令行,切换到mysql库。 @ubuntu:~$ mysql&n...【阅读全文】
MySQL在Ubuntu设置自启动的一个故障解决在解决MySQL自启动,执行命令:点击(此处)折叠或打开# chkconfig --listThe program 'chkconfig' is currently not installed. You can install it by typing:apt-get install chkconfig...【阅读全文】
1.如果您没有忘记密码的情况下,可以通过UPDATE直接编辑user表来修改密码:进入数据库mysql -u rootmysql> use mysql;mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';mysql> FLUSH PRIVILEGES;2.如果您已经忘记密码:# /etc/init.d/mysql stop &nbs...【阅读全文】