Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

From: James Cooley (jcooley_at_fit.edu)
Date: 03/29/05

  • Next message: Qi, Xlaoyan: "backup software/hardware"
    Date: Tue, 29 Mar 2005 14:48:10 -0500
    To: General Red Hat Linux discussion list <redhat-list@redhat.com>
    
    

    The folder needs to be owned by the user that mysql runs as. In my
    case, that user is the mysql user. The mysql.sock file is created by
    the mysql process that does not run as root.

    --James Cooley

    Brook Hurd wrote:

    >After installing Redhat 3 Enterprise Edition I made sure MySQL was part
    >of the install.
    >
    >When I tried to start MySQL I got the following error:
    >ERROR 2002: Can't connect to local MySQL server through socket
    >'/var/lib/mysql/mysql.sock' (2)
    >
    >The /var/lib/mysql directory did not exist. Even after creating the
    >folder, as suggested by this mailing list archives, it didn't help. The
    >folder permissions are root.root.
    >
    >I tried uninstalling and reinstalling MySQL from the Redhat RPMs and I
    >still got the error. I even read previous e-mails and found little
    >help.
    >
    >Any suggestions on what to do to make this work? I am at a loss.
    >
    >
    >The following packages are installed:
    >
    >[root@W-pai-2077 mysql]# rpm -qa | grep mysql
    >mysql-3.23.58-15.RHEL3.1
    >mysql-bench-3.23.58-15.RHEL3.1
    >php-mysql-4.3.2-19.ent
    >libdbi-dbd-mysql-0.6.5-5
    >mysql-devel-3.23.58-15.RHEL3.1
    >mod_auth_mysql-20030510-1.ent
    >[root@W-pai-2077 mysql]# rpm -qa | grep MySQL
    >MySQL-shared-3.23.58-1
    >perl-DBD-MySQL-2.1021-3
    >qt-MySQL-3.1.2-13.4
    >MySQL-python-0.9.1-6
    >[root@W-pai-2077 mysql]#
    >
    >
    >
    >
    >
    >
    >
    >
    >

    -- 
    --
    James Cooley
    Sr. Systems Analyst
    Information Technology
    Florida Tech
    321-674-7999
    jcooley@it.fit.edu
    -- 
    redhat-list mailing list
    unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
    https://www.redhat.com/mailman/listinfo/redhat-list
    

  • Next message: Qi, Xlaoyan: "backup software/hardware"

    Relevant Pages

    • Re: Trouble getting PHP to use MySQL
      ... put a copy of libmysql.dll in the Windows/System32 folder. ... Now, when I look at the PHPInfo.php page, it does show MySQL as ... It shouldn't be a problem as long as it matches your PHP version ... a WAMP install. ...
      (comp.lang.php)
    • Re: Trouble getting PHP to use MySQL
      ... put a copy of libmysql.dll in the Windows/System32 folder. ... Now, when I look at the PHPInfo.php page, it does show MySQL as being ... They should be compatible - otherwise, someone would have to compile a copy of php_mysql.dll for every combination of PHP and MySQL versions, and users would have a major problem trying to keep things straight. ... And WAMP is ok for someone who doesn't understand how to install and configure the packages - I recommend it to others quite often. ...
      (comp.lang.php)
    • Re: Trouble getting PHP to use MySQL
      ... put a copy of libmysql.dll in the Windows/System32 folder. ... Now, when I look at the PHPInfo.php page, it does show MySQL as ... It shouldn't be a problem as long as it matches your PHP version ... And WAMP is ok for someone who doesn't understand how to install ...
      (comp.lang.php)
    • Re: Trouble getting PHP to use MySQL
      ... put a copy of libmysql.dll in the Windows/System32 folder. ... Now, when I look at the PHPInfo.php page, it does show MySQL as being ... They should be compatible - otherwise, someone would have to compile a copy of php_mysql.dll for every combination of PHP and MySQL versions, and users would have a major problem trying to keep things straight. ... And WAMP is ok for someone who doesn't understand how to install and configure the packages - I recommend it to others quite often. ...
      (comp.lang.php)
    • Re: Trouble getting PHP to use MySQL
      ... properly setup to use MySQL. ... put a copy of libmysql.dll in the Windows/System32 folder. ... Another one said to put the libmysql.dll in the PHP/Ext folder. ... Now, when I look at the PHPInfo.php page, it does show MySQL as being ...
      (comp.lang.php)