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:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 7:54 PM To: [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]