connect win client to mysq on linux box

[Bobnz]

Hi I need to connect windows client machine to a server running linux, server also has another drive with win2000 and depending on what I'm doing is either a windows or linux server. Any help appreciated.

thanks
BobNZ

 

[sleipnir214]

MySQL is not just a file-driven database system like Access. MySQL is a database server, so the server software must be running on each operating system.

I do not know if the two servers (MySQL-win32, MySQL-Linux) can share their datafiles.


With what software are you trying to connect to MySQL?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Bobnz]

The server has dual boot so depending on my choice it will either load win2000 or linux. I have mysqlyog on client machine but can't connect even though client user has permissions.

thanks for the reply.

Bobnz

 

[QatQat]

Windoz version and linux version can share the datafiles.

If you properly configure an ODBC driver from your application box and give the Linux server the same IP address of Windoz server, then whichever you start it will work correctly.



To use a unique dataset create a FAT partition on the harddrive, you can then save all datafiles only once for both systems.

To do so, edity My.ini in Windoz and enable Symbolic links
Add this line in the
[mysqld] section

use-symbolic-links

Then create a symbolic link in the Windoz mysql\data\ directory to point to all related datafiles.



Now linux, mount the FAT partition, do the same in the
/var/bin/mysql directory or whichever is your datafiles directory and both systems will work off the same dataset.



Symbolic links only work for version 4 or above.


Bye

Qatqat



I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.