MYSQL_USER@localhost



  • Traditional ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysqld/mysqld.sock' (2)

    There's a seat on the drive. Mysqld's service is running.

    In leagues UNKNOWN_MYSQL_USER@localhost as on SET NAMES Quit

    What is it?

    How can you see what's causing this? UNKNOWN_MYSQL_USER? How can you change it?

    Yeah. I've been looking a lot. I didn't start at all. mysqld The server and the tables were fixed, and the rights to the folders were also slaughtered.

    Updating

    The problem didn't go, but I didn't know what to do. The only place I see is something. UKNOWN_MYSQL_USER - That's it.

    /etc/init.d/mysqld -start(){
    [ -x $exec ] || exit 5
    # check to see if it's already running
        RESPONSE=`/usr/bin/mysqladmin --socket="$socketfile" --      user=UNKNOWN_MYSQL_USER ping 2>&1`
         if [ $? = 0 ]; then
        # already running, do nothing
        action $"Starting $prog: " /bin/true
        ret=0
           elif echo "$RESPONSE" | grep -q "Access denied for user"
    


  • Try this:

    mysql -h 127.0.0.1 -P 3306 -u root -p <database>
    

    Also (to make sure he works):

    telnet 127.0.0.1 3306
    

    If there's no file. mysqld.sock The following crews can be performed.

    # sudo mkfifo /var/run/mysqld/mysqld.sock 
    # sudo chown -R mysql /var/run/mysqld
    

    If he's already making a mistake when he starts.

    # mysql start
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
    

    That mysql start isn't exactly a start attempt. ♪

    /etc/init.d/mysql [re]start
    

    And, yes, if the server works, the address socket-a can be seen in a .cnf file in the catalogue /etc/mysql/

    It's probably just a reconfiguration in my.cnf file, /etc/somewhere https://stackoverflow.com/a/11658142/6120970 ♪

    http://searchengines.guru/showthread.php?t=727959




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2