Windows Documentation: Server Install: MySQL

["Mark Harrison" <Mark.Harrison@xxxxxxx>]

OK - I'm fairly comfortable with this one... 

CHANGES SINCE LAST VERSION: 

1: Note that we're now creating the JReceiver database in a later
section
2: Stuff about how to get MySQL to start up included

DRAFT FOR COMMENT:

[WINDOWS]

JReceiver is known to be stable with release 3.23 of MySQL on Windows 2000.
Any infomration about stability with prior releases would be
appreciated.

MySql provide a Windows binary in a ZIP file. It is assumed that you
already have a tool for reading Zip files. Save and unzip the file to a
temporary directory. Then run setup.exe. Install a "typical"
installation to the folder of your choice.

Once MySql is installed, run <directory>/bin/winmysqladmin, and
create a username and password for the database administrator. (It is
important to note that this username and password are for database
administration only. You will (later) be creating a different user with
more restricted security rights. This restricted user is actually used by
the JReceiver software to run. It is possible to run JReceiver directly
using the administrator account, but very bad security practice.)

If this is succesful, you will see a green traffic light icon in the system
tray.

MySQL does not come, as standard, with a Windows GUI that makes running SQL
scripts easy. Several are avaiable, but these instructions are written to
accompany MySQLFront from http://www.anse.de/mysqlfront/

Save MySQLFront to a temporary directory, and run it at the end of
installation. Create a New Connection, with the database administrator
username and password you created above.

Within MySQLFront, select "root" and right-click. Select
"Create Database", and give the new database the name
"jreceiver".

You will not that the Linux version, at this point, does lots of stuff to
initialise the database. The fact you don't find it here is not an
oversight ;-) In the Windows world, it's actually easier to get -all- the
required components installed first, before we customise any of them.
Therefore the Windows equivalent documentation is in the section called
"JReceiver" on purpose.

Finally, make sure MySQL automatically runs whenever you log in. The
easiest way to do this seems to be to add a shortcut to WinMySQL admin to
the "startup" group in Start/Programs.

- Go to the desktop, right-mouse-button on "My Computer", and
select "Manage"
- Select Services and Applications, and then select
"Services"
- In the right hand window, scroll down until you see "MySQL",
and double click on it
- Ensure that the "startup type" is set to automatic.



To unsubscribe from this group, send an email to:
jreceiver_user-unsubscribe@xxxxxxx


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________


To unsubscribe from this group, send an email to:
jreceiver_user-unsubscribe@xxxxxxx


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________

Yahoo! Groups Sponsor

ADVERTISEMENT

For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.