Cara sharing database mysql di xampp

I'm using xampp and navicat to manage mysql on two dev machines (laptop & desktop). The laptop is my main machine, while the desktop acts as a local dev server for the group.

Table of Contents Show

Add IP to your Remote MySQL
Steps to connect to your database remotely
Bagaimana cara mengkoneksikan PHP dengan database MySQL?
Database MySQL disimpan dimana?
Kenapa tidak bisa koneksi ke database MySQL?
Apa itu export database?

Connecting to mysql via localhost in navicat is working fine on the laptop. Is there a way (other than the http tunneling method) to allow access to the desktop from the laptop via navicat?

asked Aug 11, 2009 at 15:37

Just make sure that your mysql is binding to a socket on 0.0.0.0 and you should be able to connect to that socket. I guess the default is for mysql to bind to 127.0.0.1, which, of course, is hard to reach from the outside.

EDIT: The MySQL configuration file should be in .\xampp\mysql\bin\my.ini. You need to find the bind-address parameter and change it to 0.0.0.0.

Everyone on your network should then be able to connect that MySQL instance. Of course, that may include people who better shouldn't do that. But as long as there is a password for each mysql user and the instance is not facing the internet, there is not much to worry about.

answered Aug 11, 2009 at 16:22

innaMinnaM

1,4289 silver badges9 bronze badges

To me, this is easier and quick:

Go to PhpMyAdmin and then: localhost/phpmyadmin -> User accounts -> Edit privileges -> Login Information
Change Host name drop down to Any host or type any IP 192.168.0.3 or even with masking 192.168.0.% And click the button Go.

3. Restart MySQL

More details here. You can delete the newly created row after your purpose will be solved.

answered Dec 21, 2019 at 13:19

Connect to a database with MySQL Workbench on your shared, VPS, or Dedicated hosting account. MySQL Workbench is a free tool you can use to connect to your server databases from your personal computer. MySQL Workbench can be Downloaded for free at the following link:

You will want to use the Windows (x86, 64-bit), MSI Installer if you are on Windows. The file we are installing in this tutorial is the mysql-workbench-gpl-5.2.47-win32.msi file.

Once you have downloaded MySQL Workbench, you can install it onto your computer. After you have the program installed, follow the steps below to set up a remote connection.

Don’t have time to read the article? Watch our walk-through video.

Add IP to your Remote MySQL

In order for you to be able to connect to your databases remotely you will need to add your local computer IP address to the Remote MySQL in cPanel. You can get your IP address by going to the following link:

What’s My IP address?

Steps to connect to your database remotely

Open MySQL Workbench.
Click New Connection towards the bottom left of MySQL Workbench.
In the “Set up a New Connection Dialogue” box, Type your Database connection credentials. The credentials will be like the following:
Connection Name: You can name this whatever you like.
Connection Method: Standard (TCP/IP).
Hostname: You can use your domain our your cPanel IP address.
Port: 3306
Username: Your cPanel username or the user you created for the database.
Password: cPanel password or the password for the database user that was created.
Default Schema: This can be left blank.
Click Test Connection.
Type your password and click the “Save Password in Vault” check box.Click Ok.
MySQL Workbench should say “Connection parameters are correct“. Click Ok.
Click Ok again to accept the connection settings.
Now under the SQL Development section you will see your connection listed in the Open Connection to Start Querying box. Click your newly created account.
Now you will see the databases list in the area on the left.

Bagaimana cara mengkoneksikan PHP dengan database MySQL?

Empat langkah menggunakan MySQLi untuk membuat koneksi database PHP ke MySQL: Buka File Manager -> public_html. Buat File Baru dengan mengklik ikon tambah file pada menu di atas layar. Simpan dengan nama databaseconnect.php, atau nama lain yang Anda inginkan, tapi ekstensinya tetap .

Database MySQL disimpan dimana?

Folder Data berisi seluruh file database dan tabel yang kita buat di dalam MySQL. Jika anda menggunakan setingan default, maka lokasinya akan berada di: C:\ProgramData\MySQL\MySQL Server 8.0\data.

Kenapa tidak bisa koneksi ke database MySQL?

Kenapa Database tidak koneksi ? Ini dikarenakan setting database Anda belum sesuai, atau MySql tidak aktif. Setelah pengisian setting database connection kemudian klik ok maka akan muncul pesan seperti berikut : Klik yes untuk menyimpan hasil inputan maka program akan berjalan dengan normal.

Apa itu export database?

Export Database Proses export adalah proses menyimpan database menjadi sebuah file dengan format sql. Proses ini juga bisa disebut proses backup database.