RE: Jreceiver docs: MySQL installation

["Eric de Oude" <eric.de.oude@xxxxxxx>]

Mark

Thanks for the instructions - Here's a response to your help wanted..

Installing mysql =96 gives the following screens
Screen 1 =96 Introduction etc

Screen 2 =96 The Following Text
     
=93This is a release of MySQL 3.23.49 for Win32.

NOTE: If you install MySQL in a folder other than
C:\MYSQL or you intend to start MySQL on NT/Win2000
as a service, you must create a file named C:\MY.CNF
or \Windows\my.ini or \winnt\my.ini with the following
information::

[mysqld]
basedir=3DE:/installation-path/
datadir=3DE:/data-path/

After your have installed MySQL, the installation
directory  will contain a file named 'my-example.cnf'.
You can use this as a starting point for your own
C:\my.cnf file.

If you have any problems, you can mail them to
win32@xxxxxxx after you have consulted the
MySQL manual and the MySQL mailing list archive
(http://www.mysq= l.com/documentation/index.html)

One behalf of the MySQL AB gang,
Michael Widenius"




Screen 3 - Installation Directory
I chose default c:\mysql

Screen 4 - Choice of Typical, Compact, or Custom

I chose Custom to get Screen 5

Five components are available
Mandatory - The MySQL Servers
Optional - The MySQL Clients and Maintenance Tools
Optional - The MySQL Documentation with different for...
Optional - Examples, Libraries, Includes, and script F
Mandatory - The Grant Tables and core files

All five options are checked by default (Therefore I imagine that is
what typical setting should be)

I have screen dumps of screen 4 and 5 if you'd like them mailed over.

I then went back one screen and installed typical settings.

After creating connections, running scripts and creating users (Took a
little while to figure out) I checked the service and it was set to
automatic already. (Presumably because I used default install settings)

Here is some suggested text for the scripts and users bit - Please check it's OK - It is the way I did things

"Close MySQL Front
Download JReceiver binaries (Current Version 0.1.9)
Extract the files and run jrec_mysql.sql.
MySQL Front will open - login
Select the JReceiver database
Click on the Query Tab
Click on the Green Play Icon - This creates the tables in the database
>From the menus - select Tools, User Manager
Click the Add User tab
Username - jreceiver_app
>From Host - localhost
Password - PASSWORD (From the linux instructions it is not clear if this can be something else)
Under Privileges, ensure that select, insert, update and delete are
checked. The others do not need to be checked
Select the Jreceiver database
Click Add user
Repeat this process twice, changing the From Host field to HOSTNAME and
IP_ADDRESS"


Hope that helps

Eric
-----Original Message-----
From: Mark Harrison [mailto:Mark.Harrison@xxxxxxx]
Sent: 12 April 2002 16:51
To: ukha_d@xxxxxxx Subject: [ukha_d] Jreceiver docs: MySQL installation

As=A0before, this MUST be read in conjunction with the jreceiver site
(http://jreceiver.sourceforg= e.net), since it assumes that you'll have
read the "white bits"!
=A0REQUEST FOR HELP:
There's a bit missing about registering the correct "flavour" (hu= ge,
medium, small) etc. which needs to be stuck in BEFORE the mysqlfront is
run. I can't for the life of me remember what it was, and now mySql's
installed, can't make it come up with the right dialog boxes.... It
would be really useful if someone could do a MySql service install and
tell me what's missing!
CHANGES SINCE LAST VERSION:
1: Explanatory note about the Dba vs. JReceiver users when creating Dba. 2: ".... create database with GUI .... more to follow ..." replac= ed with
something a bit more useful.
3: Remaining "..." text bit re-written to take into account that,=
installing this way round, the user hasn't actually GOT the SQL script
to create the database yet ;-(
4: Final "..." bit about putting MySQL into the startup replaced = with
something more useful.
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 creat= e 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 "Cr= eate
Database", and give the new database the name "jreceiver". .... stuff about the SQL script and the user manager goes here .... Use
MySQLFront logged in as the DBA to run SQL in the right database...
Important difference from the Linux one is that it seems to work best
with _THREE_ users, jreceiver_app@localhost, ...@<IP ADDRESS>,
...@<CLIENT NAME>, not just the two. If I understood windows naming deeply, I could probably sort this out, however this is simple ;-)
Finally, make sure MySQL automatically runs whenever you log in as
follows:
(Note - this won't work until the missing bit in the "request for help= "
at the top is done....)
- Go to the desktop, right-mouse-button on "My Computer", and sel= ect
"Manage"
- Select Services and Applications, and then select "Services" - In the right hand window, scroll down until you see "MySQL", an= d
double click on it
- Ensure that the "startup type" is set to automatic.
=A0