LinkBack URL
About LinkBacks
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
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
Reply With Quote
