PHP群:95885625 Hbuilder+MUI群:81989597 站长QQ:634381967
    您现在的位置: 首页 > 数据库 > MySQL教程 > 正文

    mysql 运行报错: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

    作者:admin来源:网络浏览:时间:2020-11-12 12:55:45我要评论
    导读:mysql 运行报错: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock&...
    mysql 运行报错: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’

    最终方案(来自大佬的教学):

    首先创建以下目录,可以先看一下自己有没有该目录,有的话,说明和我出现的问题不安全一致

    mkdir /usr/local/mysql/data \
    /usr/local/mysql/var \
    /usr/local/mysql/var/lib \
    /usr/local/mysql/var/log \
    /usr/local/mysql/var/run
    第二步:看着像是初始化的一个操作

    /usr/local/mysql/bin/mysqld --initialize --datadir=/usr/local/mysql/data
    第三步:

    在/etc下创建my.cnf文件,内容如下:

    # 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=/usr/local/mysql/data
    # socket=/usr/local/mysql/var/lib/mysql.sock

    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0

    log_error=/usr/local/mysql/var/log/mysqld.log
    pid_file=/usr/local/mysql/var/run/mysqld.pid
    最后一步:猜测是将mysqld设置为后台运行

    /usr/local/mysql/bin/mysqld --daemonize


    转载请注明(B5教程网)原文链接:https://b5.mxunkeji.com/content-35-6421-1.html
    相关热词搜索: