Installing MySQL on Vista

What is the best way to install MySQL on Vista?

I'm assuming the expected location is under Program Files, like any other
program. But since Vista won't let any program write to the program files
directory, it automatically copies the databases to a subdirectory under
Users\Bob\AppData\...VirtualStore\Program Files\MySQL\Data\ for example.

If another user logs in to the computer, those databases don't exist for
him, which makes it a little tough if you want to use the same data
regardless of how you log in!

This is all solved by installing MySQL directly off the root, i.e.,
c:\MySQL\, but I'm not sure that's really the "right" way to do things.

Any ideas? Recommendations?

Thanks

Van


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Installing MySQL on Vista

Haven't done this one wihtMySQL yet, but my feeling is that anything
belongs off the root if it is to be generally shared across users.

I believe the same is true of documents folders that will be shared over
the network or between users. If another user is logged in Vista prevents
access to some of the personal folders in order to protect "private" files
belonging to the user who is not logged on.

> What is the best way to install MySQL on Vista?
>
> I'm assuming the expected location is under Program Files, like any other
> program. But since Vista won't let any program write to the program files
> directory, it automatically copies the databases to a subdirectory under
> Users\Bob\AppData\...VirtualStore\Program Files\MySQL\Data\ for example.
>
> If another user logs in to the computer, those databases don't exist for
> him, which makes it a little tough if you want to use the same data
> regardless of how you log in!
>
> This is all solved by installing MySQL directly off the root, i.e.,
> c:\MySQL\, but I'm not sure that's really the "right" way to do things.
>
> Any ideas? Recommendations?
>
> Thanks
>
> Van
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=mdangus@psychtest.com
>
>




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org