Skip navigation links

MySQL Forums :: General :: my.cnf bind-address problem


Advanced Search

my.cnf bind-address problem
Posted by: zhann g ()
Date: March 11, 2011 11:20PM

Let me start by saying that I am a developer and not so much a systems guy. I know how to use MySql, but configuration is unfortunately out of my scope ... but, I am learning.

I am running a small site that had everything contained on a single server for a while, but it has grown to the point where we now need two servers. I plan on using the smaller one as the webserver and the larger as the DB. While I am having many problems so far, the most difficult seems to be the DB. I can't seem to get the webserver to connect to the DB. It seems like the first step is to modify the my.cnf file, adding a line just below the [mysqld]:

bind-address=xxx.xxx.xxx.xxx ...

however, when i put my webservers address there, starting mysql simply gives me the following message:

Timeout error occurred trying to start MySQL Daemon.

I am trying to find the problem, but so far no luck. Maybe someone has some tips? Here is my entire my.cnf file (primarily stolen off a site online, not too good at the optimizing bit).

[mysqld]
bind-address=xxx.xxx.xxx.xxx
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=200
max_user_connections=30
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=8
myisam_sort_buffer_size=64M
log-bin
server-id=1

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

[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

(for the most part, I only know about what half of that does, so if you have any pointers on improvement, it would be immensely appreciated)

Options: ReplyQuote


Subject Written By Posted
my.cnf bind-address problem zhann g 03/11/2011 11:20PM
Re: my.cnf bind-address problem Rick James 03/12/2011 10:41AM
Re: my.cnf bind-address problem zhann g 03/12/2011 06:11PM
Re: my.cnf bind-address problem Rick James 03/13/2011 01:00AM
Re: my.cnf bind-address problem zhann g 03/13/2011 07:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.