MySQL Forums
Forum List  »  Newbie

Cannot connect to MySQL setup for replication
Posted by: David Wynter
Date: July 06, 2005 04:21AM

I installed 4.1.12 on WBEL4 Linux. I followed the instructions for replication (InnoDb). I try to connect to my Slave Db and get "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ". This file had not been present so I added one that is empty. Since I copied the entire ibdata1 file and all other log files and database directories to /var/lib/mysql I assume the passwords will be the same as on the Master (4.1.12 on W2003Server Std).

Not sure where to go from here to find out what is happening. None of the file timestamps are changing so my login attempts on the Linux machine (localhost) are not being logged anywhere.

Here is the content of my.cnf ( I cut out all the commented sections to save space in this post) as it is in /var/lib/mysql

[client]
# password = your-password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2

# binary logging - not required for slaves, but recommended
log-bin

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 128M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# 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


What I am trying to do now is run the CHANGE MASTER TO .... command but cannot log in.

Thx.

David

Options: ReplyQuote


Subject
Written By
Posted
Cannot connect to MySQL setup for replication
July 06, 2005 04:21AM


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.