Server tidak mau konek “can’t connect to localhost”

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.

Leave A Comment?