{linux} Can't connect to local MySQL server through socket '/tmp/mysql.sock'

川长思鸟来 2022-05-10 04:08 149阅读 0赞

安装mysql成功后,登陆mysql -uroot -p输入密码发生

mysql -uroot -p
    Enter password: 
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

两个可能1.确实连接找不到该mysql.sock 2.初次安装密码问题

[mysqld]
    #skip-grant-tables  2,问题解决方式 免密登陆
    
    datadir=/var/lib/mysql
    #socket=/var/lib/mysql/mysql.sock
    **socket=/tmp/mysql.sock**   将配置修改
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mariadb according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d
    
    ~                                                                                                                        
    ~                                                                                                                        
    ~                                                                                                                        
    ~                                                                                                                        
    "/etc/my.cnf" 22L, 614C

让后重启服务再次登陆  
service mysql restart  
参考:[https://blog.csdn.net/hjf161105/article/details/78850658][https_blog.csdn.net_hjf161105_article_details_78850658]

[https_blog.csdn.net_hjf161105_article_details_78850658]: https://blog.csdn.net/hjf161105/article/details/78850658