The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by kerm1t, May 6, 2005.

  1. kerm1t

    kerm1t Member

    Joined:
    May 6, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    I am currently running FreeBSD 5.3-


    mysqld is know where to be found on the system, currently mysql is not functioning, I tried resetting the root password ffor mysql from cpanel but I receive:

    Mysql password change failed!!
    A forced reset will now be attempted.
    Reset Mysql Password

    Waiting for mysql to restart.....Done
    Changing Password....Done
    Fixing Mysql Privilege Table....This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.

    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

    You can safely ignore all 'Duplicate column' and 'Unknown column' errors
    because these just mean that your tables are already up to date.
    This script is safe to run even if your tables are already up to date!

    Got a failure from command:
    /usr/local/bin/mysql --no-defaults --force --user=root --host=localhost --password=mypassword --database=mysql
    Please check the above output and try again.

    If you get an 'Access denied' error, you should run this script again and
    give the MySQL root user password as an argument with the --password= option
    Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....

    Restarting mysql....Done

    The Mysql Root Password has been changed
    Password changed for root to mypassword






    I looked around the system and decided to make deinstall on mysql41-server and mysql-41client then reinsall both. This did not help at all since I received the same /tmp/mysql.sock error from cpanel. I then went into the scripts directory and ran /scripts/mysqlup

    Package mysql-server-4.1.5 registered in /var/db/pkg/mysql-server-4.1.5
    Running post install scripts for mysql-server-4.1....Done
    Using package directory: packages-5.3-release
    mysql-client-4.1 (4.1.5) is already installed.
    mysql-client-4.1 (4.1.5) is newer then requested version 4.1.5. (no installed needed)
    /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
    mysql has failed
    This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.

    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

    You can safely ignore all 'Duplicate column' and 'Unknown column' errors
    because these just mean that your tables are already up to date.
    This script is safe to run even if your tables are already up to date!

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    Got a failure from command:
    /usr/local/bin/mysql -f --user=root --host=localhost --password=mypassword --database=mysql
    Please check the above output and try again.

    If you get an 'Access denied' error, you should run this script again and
    give the MySQL root user password as an argument with the --password= option
    Install Complete





    . Additionally, I tried /scripts/fixmysqlbsd and received the following error:
    /scripts/fixmysqlbsd
    Ports are out of date.. updating....
    receiving file list ... done

    wrote 76 bytes read 1820322 bytes 134844.30 bytes/sec
    total size is 120821240 speedup is 66.37
    ===> Deinstalling for databases/mysql41-client
    pkg_info: package bsdpan-GDGraph-1.43 has no origin recorded
    pkg_info: package bsdpan-GDTextUtil-0.86 has no origin recorded
    pkg_info: package bsdpan-Net_SSLeay.pm-1.25 has no origin recorded
    pkg_info: package bsdpan-PathTools-3.06 has no origin recorded
    pkg_info: package bsdpan-ShadowHash-0.07 has no origin recorded
    pkg_info: package bsdpan-Term-ReadLine-Perl-1.0203 has no origin recorded
    pkg_info: package bsdpan-TermReadKey-2.30 has no origin recorded
    pkg_info: package bsdpan-Tree-MultiNode-1.0.10 has no origin recorded
    pkg_info: package bsdpan-libwww-perl-5.803 has no origin recorded
    ===> mysql-client not installed, skipping
    ===> Deinstalling for databases/mysql41-server
    pkg_info: package bsdpan-GDGraph-1.43 has no origin recorded
    pkg_info: package bsdpan-GDTextUtil-0.86 has no origin recorded
    pkg_info: package bsdpan-Net_SSLeay.pm-1.25 has no origin recorded
    pkg_info: package bsdpan-PathTools-3.06 has no origin recorded
    pkg_info: package bsdpan-ShadowHash-0.07 has no origin recorded
    pkg_info: package bsdpan-Term-ReadLine-Perl-1.0203 has no origin recorded
    pkg_info: package bsdpan-TermReadKey-2.30 has no origin recorded
    pkg_info: package bsdpan-Tree-MultiNode-1.0.10 has no origin recorded
    pkg_info: package bsdpan-libwww-perl-5.803 has no origin recorded
    ===> mysql-server not installed, skipping
    Using package directory: packages-5.3-release
    Cannot find package mysql40-server ...
    Using package directory: packages-5.3-release
    Cannot find package mysql40-client ...
    receiving file list ... done

    wrote 83 bytes read 241 bytes 216.00 bytes/sec
    total size is 5396 speedup is 16.65
    -------


    I am a cpanel novice and I am looking for some direction on how to repair mysql. One of my fears is damaging the relationship between apache, php, phpadmin and anything else which talks to mysql.

    Cheers,
    -Kerm1t
     
  2. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    same problem here , darkorb ?! Please ........
     
Loading...

Share This Page