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.
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.1Set the ethernet IP of the host machine. By default MySQL listens only on localhost. When you done restart MySQL server and it should work.
I can't find the my.cnf file and i do look into my.ini file, it doesn't have the bind address line.
You can create that file and start mysql like this:
mysql --defaults-extra-file=/etc/mysql/my.cnfHere you can find more information about Option Files: http://dev.mysql.com/doc/refman/5.5/en/option-files.html
bye :)
Thanks cereal for all those reply. I had get the problem solved by creating new server instance :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.