@
当前状态
目前已经启动好mysql服务:
systemctl start mysqld
systemctl status mysqld
生成临时密码
grep 'temporary password' /var/log/mysqld.log
报错
出现了报错:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
解决办法:
修改 /etc/my.cnf文件,在最后加入skip-grant-tables
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-grant-tables
实现无密码登录
最后,刷新权限,修改root密码
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
就可以使用密码登录了
- localhost password 密码 Access deniedlocalhost password access denied localhost password密码access 39 password access denied localhost ubuntu access denied 39 localhost access denied 39 localhost password access localhost方法access denied localhost password方法access 39 localhost password密码 39 sqlexception localhost password