linux之运行mysql -h 127.0.0.1报错：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using pa

刚申请的阿里云服务器，建好实例，安装完mysql，终端运行

mysql -h 127.0.0.1

报错：
 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

这是因为需要你的mysql的登录密码，顺手加上密码就好了：

mysql -h 127.0.0.1 -uroot -pLz_123456

-p后面的Lz_123456是mysql的密码。我这里是提前已经重置过了mysql的密码了，如果没有重置你的密码，可以先重置你的密码。

然后就进入了mysql了

此时终端结果：

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

如何重置你的mysql密码：

/etc/mysql.conf.d/ 文件夹下有一个mysqld.cnf文档，在这个文档里可以找到【mysqld】字段

添加过skip-grant-table了，作用是可以免密登录

保存即可。