Jika tiger diserver anda tidak mau konek keterangannya “can’t connect to local host, sedangkan di sql yog mau konek, maka solusinya seperti dibawah ini:
– Buka my.conf ato seting mysql ato mariadb
– Lalu tambahkan bind-address=0.0.0.0 dibawah [mysqld] DAN [client]
– Asalnya
[mysqld]
datadir=C:/Program Files/MariaDB 5.5/data
port=3306
sql_mode=”STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION”
default_storage_engine=innodb
innodb_buffer_pool_size=345M
innodb_log_file_size=50M
[client]
port=3306
Menjadi
[mysqld]
bind-address=0.0.0.0
datadir=C:/Program Files/MariaDB 5.5/data
port=3306
sql_mode=”STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION”
default_storage_engine=innodb
innodb_buffer_pool_size=345M
innodb_log_file_size=50M
[client]
bind-address=0.0.0.0
port=3306
– Lokasi file my di mariadb disini C:\Program Files\MariaDB 5.5\data.