mysql master slave

最新推荐文章于 2024-04-08 18:09:11 发布

原创最新推荐文章于 2024-04-08 18:09:11 发布 · 523 阅读

0 ·

CC 4.0 BY-SA版权

Database 专栏收录该内容

36 篇文章

订阅专栏

本文介绍了MySQL数据库的安装过程及配置细节。包括使用CMake进行编译配置，通过mysql_install_db初始化数据库实例，启动mysqld服务，以及设置管理员密码等关键步骤。

http://blog.youkuaiyun.com/zqtsx/article/details/9378703 更全

cmake ../ \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql3306 \
-DMYSQL_DATADIR=/usr/local/mysql3306/data -DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=1

./mysql_install_db --user=mysql --basedir=/usr/local/mysql3306 --datadir=/usr/local/mysql3306/data

./mysqld_safe \
--defaults-file=/usr/local/mysql3306/my.cnf

./mysqld_safe \
--defaults-file=/usr/local/mysql3406/my.cnf

/usr/local/mysql3406/bin/mysqladmin -u root -h 127.0.0.1 -P3406 password '123456'

/usr/local/mysql3406/bin/mysql -h 127.0.0.1 -u root -p

GRANT REPLICATION SLAVE ON *.* TO 'backup'@'127.0.0.1' IDENTIFIED BY '123456';

change master to master_host='127.0.0.1', master_user='backup', master_password='123456', master_port=3306;