Wrox Programmer Forums
|
BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5
This is the forum to discuss the Wrox book Beginning PHP4 by Wankyu Choi, Allan Kent, Chris Lea, Ganesh Prasad, Chris Ullman; ISBN: 9780764543647
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2005, 02:18 AM
Registered User
 
Join Date: Jul 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't connect to local MySQL server through socket

Hi,

I bought Beginning MySQL, Beginning PHP5 and I'm eager to start building dynamic websites, but I can't get MySQL to work on my Fedora Core 4 system.

I get the following messages:

[root@c-280be253 bin]# mysqladmin versions
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@c-280be253 bin]#


[root@c-280be253 bin]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@c-280be253 bin]#

[root@c-280be253 bin]# mysqld_safe &
[1] 21511
[root@c-280be253 bin]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050719 00:08:53 mysqld ended

My my.cnf look like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld]
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I can't locate the mysql.sock and I can't start mysql? What to do???

Regards
//Vito Salieri






Similar Threads
Thread Thread Starter Forum Replies Last Post
couldn't connect to mysql thru socket-help me annumol MySQL 1 May 13th, 2008 08:58 AM
Can't connect to mySql server using localhost RobinR MySQL 3 January 30th, 2006 10:07 PM
Can't connect to SQL server 2000 in local PC shalim SQL Server 2000 1 November 24th, 2005 01:09 AM
Can't connect to local MySQL server through socket Salieri MySQL 2 September 14th, 2005 03:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.