DB-Mysl-忘记root密码&解决

首先，你必须要有操作系统的root权限了。
类似于安全模式登录系统，有人建议说是pkill mysql，但是我不建议哈。因为当你执行了这个命令后，会导致这样的状况：

/etc/init.d/mysqld status
mysqld dead but subsys locked

这样即使你是在安全模式下启动mysql都未必会有用的，所以一般是这样/etc/init.d/mysqld stop，如果你不幸先用了pkill，那么就start一下再stop咯。

#在/etc/my.cnf中的[mysqld]字段下添加如下

[mysqld]
#misc
user = mysql
basedir = /usr/
datadir = /home/mysql
#tmpdir = /home/tmp
port = 3306
socket =/var/lib/mysql/mysql.sock
max_allowed_packet = 64M
ft_min_word_len = 1
event_scheduler = 0
character-set-server=utf8
performance_schema = 0
#lower_case_table_names=1
net_read_timeout = 120
open_files_limit = 8192
back_log = 1000
#skip-networking
max_connections = 100
max_connect_errors = 100000
external-locking = FALSE
#binlog_cache_size = 4M
#max_binlog_cache_size = 2G
#performance_schema = 1
#timed_mutexes = 1
#locked_in_memory = 1
skip-grant-tables  #新增字段在这里

然后再起来/etc/init.d/mysqld start

#修改密码
mysql
mysql> use mysql;
mysql> update user set password=password("test123") where user='root';   
mysql> flush privileges;
mysql> exit;