|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: 'Can't connect to local MySQL server....' error
From: bruce (bedouglas
earthlink.net)
Date: Tue Mar 29 2005 - 06:48:09 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
after more examination, it appears that i have different versions of mysql,
installed in different locations
an #/rpm -q mysql says that i have mysql-3.23, which is the FC2 versionof
mysql.
given that i apparently have mysql files in /usr/bin, and /usr/local/bin,
i'd like to first clean out the system, so i have the mysql files in the
correct location, and then i'd like to upgrade mysql to the latest stable
mysql version...
can anyone provide pointers as to how to do this...
or, can anyone tell me how to clean up my mysql duplicates?
or, can i simply delete the mysql files under the /usr/local/bin dir, and
somehow 'point' the system to the '/usr/bin' dir for the mysql files?
it seems my environment path has both '/usr/local/bin' and '/usr/bin'. also,
how do i change the environment path??
thanks
bruce
-----Original Message-----
From: Tom Crimmins [mailto:mysql2
pottcounty.com]
Sent: Monday, March 28, 2005 7:54 PM
To: bedouglas
earthlink.net
Cc: mysql
lists.mysql.com
Subject: RE: 'Can't connect to local MySQL server....' error
On Monday, March 28, 2005 21:36, bruce wrote:
> hi...
>
> a server went from RH8 to FC2. it appears that the guy who did the
> upgrade didn't perfrom any backups...
>
> i get a 'Can't connect to local MySQL server through socket...' error.
>
> i've tried to 'fix' the tables 'mysql_fix_privilege_tables' with no
> luck... i've tried to start/restart with no luck. i've lloked through
> google/mysql with no luck...
>
> any ideas as to what might be causing the problems... if i can get the
> daemon started, i'll (hopefully) be ok...
Is there anything in the error log? You could try starting it from the
command line to see what errors you get. The following will work assuming
you installed using the rpm's. Otherwise the location of mysqld and the
user may differ.
#su - mysql
#/usr/sbin/mysqld
Run this and see what errors are reported.
> thanks
>
> bruce
> bedouglas
earthlink.net
--
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]