With Interaktive SQL-Frontend (preferred)
=========================================
(download HeidiSQL : http://downloads.sourceforge.net/heidisql/HeidiSQL_3.1RC1_Setup.exe?modtime=1192230977&big_mirror=0)

1. Create an empty database "interass" for INTERASS

   Tools -> Create Database



2. Create a database user "intuser"

   Tools -> User-Manager

   Username: intuser
   Password: pwuser
   Allow access to: interass





With SQL-Command-Window
=======================
1. Create an empty database "interass" for INTERASS

CREATE DATABASE interass;



2. Create a database user "intuser"

INSERT INTO mysql.user (Host, User, ssl_cipher, x509_issuer,x509_subject) 
VALUES ( 'localhost', 'intuser','','','');



3. Create a password for user "intuser" ("pwuser" too in this example)

// UPDATE mysql.user SET PASSWORD = PASSWORD('pwuser') WHERE user = 'intuser';

GRANT Select, Insert, Update, Delete, Index, Alter, Create, Drop, References ON `interass4`.* TO 'intuser'@'%' IDENTIFIED BY 'pwuser'
FLUSH PRIVILEGES



Following steps 4ff obsolete


=======================================

4. Enable database access for user "intuser":

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO intuser@localhost;
GRANT Select, Insert, Update, Delete, Index, Alter, Create, Drop, References ON interass.* TO 'intuser'@'%' IDENTIFIED BY 'pwuser'


FLUSH PRIVILEGES;



If you have installed MySQL on a server:



5. Install INTERASS on the server too and use INTERASS to create the 
interass database tables

(see "How to connect INTERASS to a MySQL database)



6. Enable remote access for user "intuser":

INSERT INTO mysql.user (Host, User, ssl_cipher, x509_issuer,x509_subject) 
VALUES ( '%', 'intuser','','','');

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO intuser@'%';

UPDATE mysql.user SET PASSWORD = PASSWORD('pwuser') WHERE user = 
'intuser';

FLUSH PRIVILEGES;



ACHTUNG: In ODBC Tabellen welche ueber Anwendung editiert werden,
MUSS ein primary Key definiert sein, andernfalls ist Editieren nicht moeglich



mysql.exe
=========
mysql -h localhost -u root -p
use adr_db
