sudo yum install mysql-serverJika sudah maka jalankan servicenya :
sudo /etc/init.d/mysqld restartUntuk mengamankan dan settting password:
sudo /usr/bin/mysql_secure_installationsetelah itu silakan ikuti panduan nya
nano /etc/my.cnfcomment line berikut sebelum [mysqld safe]
#bind-address = 127.0.0.1 #skip-networking atau port=3306 #bind-address=0.0.0.0 bind-address=139.59.253.205 # skip-networkingLogin ke dalam mysql via cmd
mysql -u root -p mysqllalu create database misal: anu
CREATE DATABASE anu;lalu ketikkan ini untuk memberi akses ke user berdasarkan password
GRANT ALL ON anu.* TO 'root'@'%' IDENTIFIED BY 'PASSWORDKAMU';Jikasudah reload dengan
mysql> FLUSH PRIVILEGES;
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';Lalu, bukakan aksesnya dengan ini
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
Reload konfigurasi baruFLUSH PRIVILEGES;dan anda sudah bisa login mysql via Heidi
http://www.tecmint.com/how-to-setup-mysql-master-slave-replication-in-rhel-centos-fedora/
Tutorial ini akan membantu membuat replikasi Mysql server dengan 2 IP yang berbeda misal :
192.168.1.1 => MASTER
192.168.1.2 => SLAVE
https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication
# yum install mysql-server mysql
# nano /etc/my.cnf
server-id = 1
binlog-do-db=greviarelay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
log-error = /var/lib/mysql/mysql.err
master-info-file = /var/lib/mysql/mysql-master.info
relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
log-bin = /var/lib/mysql/mysql-bin
# /etc/init.d/mysqld restart
# mysql -u root -p
mysql> GRANT REPLICATION SLAVE ON *.* TO 'root_user'@'%' IDENTIFIED BY 'your_password'; mysql> FLUSH PRIVILEGES; mysql> FLUSH TABLES WITH READ LOCK; mysql> SHOW MASTER STATUS; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000003 | 990 | grevia | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) mysql> quit;
# mysqldump -u root -p --all-databases --master-data > /root/dbdump.db
mysql> UNLOCK TABLES; mysql> quit;
# yum install mysql-server mysql
# nano /etc/my.cnf
server-id = 2 master-host=192.168.1.1 master-connect-retry=60 master-user=slave_user master-password=yourpassword replicate-do-db=tecmint relay-log = /var/lib/mysql/mysql-relay-bin relay-log-index = /var/lib/mysql/mysql-relay-bin.index log-error = /var/lib/mysql/mysql.err master-info-file = /var/lib/mysql/mysql-master.info relay-log-info-file = /var/lib/mysql/mysql-relay-log.info log-bin = /var/lib/mysql/mysql-bin
CREATE TABLE mahonara( id int AUTO_INCREMENT PRIMARY KEY, nama varchar(100) NULL ); INSERT INTO mahonara(nama) VALUES('benga'), ('charlie'), ('dumdum');
adalah kumpulan tutorial server dan pemograman tentang seputar Linux & PHP
CodeIgniter