设置mysql密码或者登录错误提示

error: 'Access denied for user 'root'@'localhost' (using password: NO)'
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

# /opt/bin/mysqladmin -u root password 123456789aqz
/opt/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

方法一

修改my.cnf文件

[mysqld]
skip-grant-tables

添加到最后重启mysql
这样可以免账号密码登录

方法二
/opt/bin/mysqld --skip-grant