| Bug #39018 | mysql_secure_installation doesn't find non-default mysql.sock file. | ||
|---|---|---|---|
| Submitted: | 25 Aug 2008 18:21 | Modified: | 23 Dec 2009 10:21 |
| Reporter: | Buck Golemon | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S4 (Feature request) |
| Version: | 5.0.60sp1-enterprise-gpl-log | OS: | Linux (Red Hat Enterprise Linux AS release 4 (Nahant Update 6) 2.6.9-67.ELsmp x86_64) |
| Assigned to: | CPU Architecture: | Any | |
[16 Oct 2009 23:25]
Ricardo M
I'm getting same issue after installing 5.1.39 in non default directories.
[23 Dec 2009 10:21]
Sveta Smirnova
Thank you for the reasonable feature request. Can be related to bug #27671
Description: This program is looking for '/var/lib/mysql/mysql.sock' when there's no mention of such a file in my configuration. A quick fix for me is to create a symlink, but this become problematic with more than one mysqld process. $/usr/bin/mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) How to repeat: Run with a my.conf with these values: [client] socket = /apps/backed_up/var/lib/mysql/mysql.sock [mysqld] socket = /apps/backed_up/var/lib/mysql/mysql.sock Suggested fix: Use the my.cnf client socket parameter to connect to the mysql server.