Linux下Mysql常见问题解答

1.ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)--授权问题

    1）修改配置文件：

        如果没有/etc/my.cnf或/etc/mysql/my.cnf文件不存在，则在/usr/share/mysql目录下找到默认配置文件，别问我文件夹下面名字，可能会不一样，反正你找到那个.cnf就对了，我的是my-default.cnf文件

        [mysqld]

        skip-grant-tables #skip-grant-tables加上去即可

    2） 重启服务即可 

        [root@ezreal init.d]# mysql -u root -p
        Enter password: 
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        [root@ezreal init.d]# service mysqld restart
        Restarting mysqld (via systemctl):                         [  OK  ]
        [root@ezreal init.d]# mysql -u root -p
        Enter password: 
        Welcome to the MySQL monitor.  Commands end with ; or \g.
        Your MySQL connection id is 2
        Server version: 5.6.39 MySQL Community Server (GPL)


            Copyright (c) 2000, 2018, 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>