mysql/mariadb root user get ERROR 1045 (28000): Access denied without sudo

http://ubuntuforums.org/showthread.php?t=2275033


Thanks for sergerod & nerdtron
I had fixed my problem.
What I did is to combine their commands.
Do nerdron's answer first.

Here's what I did and saved my MariaDB.
Stop mysql:
1. /etc/init.d/mysql stop and killall -9 mysqld
Make sure no mysqld is exist.
Run mysql with skip grants to be able to login without any password
2. mysqld_safe --skip-grant-tables &
Login as root
3. mysql -u root
then is sergerod's.
[mysql] use mysql;

[mysql] update user set password=PASSWORD("NEW-ROOT-PASSWORD-HERE") where User='root';           # first reset root password, in case you set root password before
[mysql] update user set plugin='' where User='root';                  # then set plugin as null
[mysql] flush privileges;
[mysql] \q or exit
and then:
/etc/init.d/mysql stop (or service mysql stop) andkillall -9 mysqld
and start the mysql thru
service mysql start or /etc/init.d/mysql restart
and all is done!

Also I made a script, please go to http://zhxq.io/?p=99

and I tested my script, it is functional.

It's hard to stop mysqld by the script...... so the script sometimes doesn't work (rarely).

All in all, thanks dude!

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值