errror : cant connect local mysql server

[Anon]

hi,

i got an error while i am trying to connect php with mysql ..

error message is like this :

"can not connect to local mysql by using socket ..."

how could i eliminate this error ?

pls write me the whole sequence of configuration of php --with-mysql and so ..

thanks
siddharth

[Anon]

do you have root access to the server or are you hosting on a web server from a hosting company?

What have you done thus far? Have you installed MySQL? Did you just set this server up from scratch or was it already running and this problem just now occurred?

R

[Anon]

hello sir ,
I have all access of root. MySQL is also
working. first mysql,php3,apache are correctly working. due to problem in linux
i installed again php3 & apache & also configure with mysql but error is comming like:-->

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /usr/local/etc/httpd/htdocs/icreate/home.php3 on line 29

error in connection to host --

what should i do ??

thank you
siddharth

[Anon]

Did you change any of the PHP.ini settings for MySQL? What version of MySQL are you running? version of PHP? version of Linux?

Give me a copy of these files in your etc/ directory:
PHP.ini
my.cnf

R

[Anon]

hello sir,
version of MySQL is 3.22.25 , php version is 3.0.16 and linux is red-hat 6.1 .

i am sending php3.ini file with this but i cant find my.cnf on machine ..

here is a php3.ini file ...

engine = On ; enable PHP 3.0 parser
short_open_tag = On ; allow the <? tag. otherwise, only <?php and <script> tags are recognized.
asp_tags = Off ; allow ASP-style <% %> tags
precision = 14 ; number of significant digits displayed in floating point numbers
y2k_compliance = Off ; whether to be year 2000 compliant (will cause problems with non y2k compliant browsers)

; Safe Mode
safe_mode = Off
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP ; Setting certain environment variables
; may be a potential security breach.
; This directive contains a comma-delimited
; list of prefixes. In Safe Mode, the
; user may only alter environment
; variables whose names begin with the
; prefixes supplied here.
; By default, users will only be able
; to set environment variables that begin
; with PHP (e.g. PHP_FOO=BAR).
; Note: If this directive is empty, PHP
; will let the user modify ANY environment
; variable!
safe_mode_protected_env_vars = LD_LIBRARY_PATH
; Colors for Syntax Highlighting mode. Anything that's acceptable in <font color=???> would work.
highlight.string = #DD0000
highlight.comment = #FF8000
highlight.keyword = #007700
highlight.bg = #FFFFFF
highlight.default = #0000BB
highlight.html = #000000

expose_php = On

; charset = iso-8859-1

max_execution_time = 30

memory_limit = 8388608

error_reporting = 7
display_errors = On
log_errors = Off
track_errors = Off
;error_prepend_string = "<font color=ff0000>"

;error_append_string = "</font>"

;error_log = filename
;error_log = syslog
warn_plus_overloading = Off

magic_quotes_gpc = On
magic_quotes_runtime= Off
magic_quotes_sybase = Off
track_vars = On
; automatically add files before or after any PHP 3.0 document
auto_prepend_file =
auto_append_file =

include_path =

doc_root =
user_dir =
;upload_tmp_dir =

upload_max_filesize = 2097152

extension_dir = ./

[Syslog]
define_syslog_variables = Off

[mail function]
SMTP = localhost
sendmail_from = [e-mail]
sendmail_path =

[Debugger]
debugger.host = localhost
debugger.port = 7869
debugger.enabled = False

[Logging]

[SQL]
sql.safe_mode = Off

[ODBC]
;uodbc.default_db = Not yet implemented
;uodbc.default_user = Not yet implemented
;uodbc.default_pw = Not yet implemented
uodbc.allow_persistent = On
uodbc.max_persistent = -1
uodbc.max_links = -1
uodbc.defaultlrl = 4096
uodbc.defaultbinmode = 1

[MySQL]
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =

mysql.default_host =
mysql.default_user =
mysql.default_password =

[mSQL]
msql.allow_persistent = On
msql.max_persistent = -1
msql.max_links = -1

[PostgresSQL]
pgsql.allow_persistent = On
pgsql.max_persistent = -1
pgsql.max_links = -1

[Sybase]
sybase.allow_persistent = On
sybase.max_persistent = -1
sybase.max_links = -1
;sybase.interface_file = "/usr/sybase/interfaces"
sybase.min_error_severity = 10
sybase.min_message_severity = 10
sybase.compatability_mode = Off

[Sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10

[bcmath]
bcmath.scale = 0

[browscap]
;browscap = extra/browscap.ini

[image]
;ps.default_encoding = "/etc/t1lib/enc/IsoLatin1.enc"

[Informix]
ifx.default_host =
ifx.default_user =
ifx.default_password =
ifx.allow_persistent = On
ifx.max_persistent = -1
ifx.max_links = -1
ifx.textasvarchar = 0
ifx.byteasvarchar = 0
ifx.charasvarchar = 0

ifx.blobinfile = 0

ifx.nullformat = 0

[Anon]

Well, there is your problem! MySQL can't be running if you don't have the MySQL set up file!!!

OK, you need to configure MySQL, so look for these files within the "/usr/share/mysql" directory:

my-small.cnf, my-medium.cnf, my-large.cnf, my-huge.cnf

• If they aren't in that directory, then find them in the MySQL directory (wherever yours is)

then decide which one you want to use and follow the instructions within the file itself. If you have a small system (64 megs of RAM or less, you want to use the my-small.cnf..etc...)

Once you do that, then you have to turn on the MySQL server. If you want it to start up automatically upon boot-up, then you have to go into LinuxConf and change the settings.

[Anon]

hello sir,
i tried to find files
my-small.cnf, my-medium.cnf, my-large.cnf, my-huge.cnf but no in my harddisk.
what should I do next? please reply immediatel if possible.
siddharth

[Anon]

Sir, if you can't find those files, then MySQL is NOT INSTALLED on your Server, and I suggest you talk to your web hosting company. I can't help you.