Set up a shared mysql database server

[BlurrieBlue]

Good day. I'm new here and I'm nt sure this post should belong in here or not.

I had done my programming on the virtual machine while having mysql database set up in my PC. I was unable to get the data from my PC unless I installed another database server in the virtual machine itself.

Is it possible for me to change to localhost of the database to a shared server?
I'm currently using MySQL 5.5.

Thanks in advanced.

[cereal]

In order to access from the virtual server you need to change a setting on the database config file. Search for my.cnf and change this line:

bind-address = 127.0.0.1

Set the ethernet IP of the host machine. By default MySQL listens only on localhost. When you done restart MySQL server and it should work.

[BlurrieBlue]

I can't find the my.cnf file and i do look into my.ini file, it doesn't have the bind address line.

[cereal]

You can create that file and start mysql like this:

mysql --defaults-extra-file=/etc/mysql/my.cnf

Here you can find more information about Option Files: http://dev.mysql.com/doc/refman/5.5/en/option-files.html
bye :)

[BlurrieBlue]

Thanks cereal for all those reply. I had get the problem solved by creating new server instance :)