Replication With MySQL 5 On Debian Etch problems

trying to follow this tutorial to setup replication on two cpanel vps's running centos. my first problem.

if i add

Code:

bind-address           = 127.0.0.1

to my.cnf

then run:

Code:

mysqladmin -h a1.dccni.com -u root password XXXXX

i get this error:

Code:

mysqladmin: connect to server at 'a1.dccni.com' failed
error: 'Lost connection to MySQL server during query'

If i run mysql withough the
bind-address = 127.0.0.1 line, then i get this error:

Code:

mysqladmin: connect to server at 'a1.dccni.com' failed
error: 'Access denied for user 'root'@'a1.dccni.com' (using password: YES)'

any ideas why this could be?

 

Do you mean this tutorial? http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
It says that you must comment out the

Code:

bind-address           = 127.0.0.1

line.

Regarding the other error: please try the procedure outlined in chapter 8 on http://www.howtoforge.com/perfect_server_opensuse10.3_p4 (works for any distribution), beginning with "As you've seen in the netstat output, MySQL is not only listening on localhost, but on all interfaces, which means it can be accessed from the outside. Therefore we need to set a password for the user [email protected] as well. But there's one little problem: most likely the Host column in the mysql.user table doesn't contain server1.example.com, but server1. We will change that now, and afterwards we will set a MySQL password for the user [email protected]."

 

Oh, I've jsut seen that you're using CentOS. On CentOS, there's no

Code:

bind-address           = 127.0.0.1

line...
What's the output of

Code:

netstat -tap|grep mysql

?

 

server 1:

Code:

[root@a1 ~]# netstat -tap|grep mysql
tcp        0      0 *:mysql                     *:*                         LISTEN      15459/mysqld

server 2:

Code:

[root@a1b ~]# netstat -tap|grep mysql
tcp        0      0 *:mysql                     *:*                         LISTEN      15932/mysqld
[root@a1b ~]#

 

That's good, so you can skip the bind-address part of the tutorial. Try to proceed with the second half of my first post in this thread.

 

worked great got it working. Another question. If lets say i want to replicate another db, do i sync the databases and then add:

Code:

replicate-do-db = exampledb2

and

Code:

binlog-do-db = exampledb2

to both my.cnf files and restart mysql?

Thanks for the help!

 

Yes, that's correct.