View previous topic :: View next topic |
Author |
Message |
databusx n00b
Joined: 31 Mar 2006 Posts: 27
|
Posted: Sun Sep 03, 2006 9:43 am Post subject: mysql problem |
|
|
Hi !
I have a strange problem with my mysql! i have tryed many things without results.
when i start the service is all fine , no errors.
when i try to change anything in database using the php scripts + mysql i got always this error :
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 133
Warning: mysql_db_query(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 136
Warning: mysql_db_query(): A link to the server could not be established in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 136
Warning: mysql_connect(): Lost connection to MySQL server during query in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 148
Warning: mysql_db_query(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 150
Warning: mysql_db_query(): A link to the server could not be established in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 150
I have this working fine but now give that error. Its update and change the record in database but always give the error.
my.cnf
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v 1.3 2006/02/01 20:25:56 vivo Exp $
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/run/mysqld/mysqld-500.sock
[mysql]
character-sets-dir=utf8
default-character-set=utf8
[mysqladmin]
character-sets-dir=utf8
default-character-set=utf8
[mysqlcheck]
character-sets-dir=utf8
default-character-set=utf8
[mysqldump]
character-sets-dir=utf8
default-character-set=utf8
[mysqlimport]
character-sets-dir=utf8
default-character-set=utf8
[mysqlshow]
character-sets-dir=utf8
default-character-set=utf8
[myisamchk]
character-sets-dir=utf8
[myisampack]
character-sets-dir=utf8
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
character-set-server = utf8
default-character-set = utf8
user = mysql
port = 3306
socket = /var/run/mysqld/mysqld-500.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
#skip-locking
#skip-innodb
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
language = /usr/share/mysql/english
#security:
#using "localhost" in connects use sockets by default
#skip-networking
bind-address = 127.0.0.1
log-bin
server-id = 1
# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
# you need debug use flag enabled to use this ones.
# if needed uncomment them, start the server and issue
# #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
# this will show you *exactly* what's appening in your server
#log = /tmp/mysqld.sql
#gdb
#debug = d:t:i,/tmp/mysqld.trace
#one-thread
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# The following is the InnoDB configuration
# if you wish to disable innodb instead
# uncomment just the next line
#skip-innodb
#
# the rest of the innodb config follows:
# don't eat too much memory, we're trying to be safe on 64Mb boxes.
# you might want to bump this up a bit on boxes with more RAM
innodb_buffer_pool_size = 16M
# this is the default, increase if you have lots of tables
innodb_additional_mem_pool_size = 2M
#
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database
# and upstream wants things to be under /var/lib/mysql/, so that's the route
# we have to take for the moment
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path = ibdata1:10M:autoextend
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size = 5M
# this is the default, increase if you have very large transactions.
innodb_log_buffer_size = 8M
# this is the default, and won't hurt you.
# you shouldn't need to tweak it.
set-variable = innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
#vim: set tabstop=4 :
#vim: set shiftwidth=4 :
I accept any sugestion!
Thanks! |
|
Back to top |
|
|
SinoTech Advocate
Joined: 20 Mar 2004 Posts: 2579 Location: Neunkirchen / Saarland / Germany
|
Posted: Sun Sep 03, 2006 9:54 am Post subject: Re: mysql problem |
|
|
databusx wrote: |
[...]
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 133
[...]
|
databusx wrote: |
[...]
my.cnf
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v 1.3 2006/02/01 20:25:56 vivo Exp $
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/run/mysqld/mysqld-500.sock
[...]
|
Think it is enough to change this line
Code: |
socket = /var/run/mysqld/mysqld-500.sock
|
to this
Code: |
socket = /var/run/mysqld/mysqld.sock
|
Cheers,
Sino _________________ Help to answer the unanswered |
|
Back to top |
|
|
databusx n00b
Joined: 31 Mar 2006 Posts: 27
|
Posted: Sun Sep 03, 2006 11:58 am Post subject: |
|
|
Thanks!
how can i not see that ... i am blind my god!
sorry m8 and thanks again. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|