首先,你必须要有操作系统的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;