/users/mysql/irix6.5/daimi/muser
/users/mysql/linux/daimi/muser
/users/mysql/solaris/daimi/muser
Which one to use depends on the operating system of the machine you
are using the command from (the type of operating system can be found
by the command echo $OSTYPE).
The command takes two arguments: the name of the database and a password for mySQL (which is independent of the password used for normal logins to machines). E.g.
/users/mysql/linux/daimi/muser myDatabase myPassword
The program returns an URL for a web based tool for administration of
the new database (probably, no administration will be
needed). Apparently, a mySQL user is made for each database
constructed (with the same name as the database, e.g. the user will be
myDatabase in the example above). It is suggested that
you set up only one database with the same name as your normal login
name.
To actually use mySQL, you run the mySQL client by the command
mysql, using the database host
amigo. E.g. run the command
mysql -h amigo -p
and give the chosen password (myPassword in the example above) when
prompted. For more about the options for the mysql client, use the
command man mysql .
To learn how to work with mySQL, see its documentation, e.g. at
http://www.mysql.com/documentation/mysql/bychapter/index.html
In particular, follow the examples in section 3 to get started (note
that the database already has been created by the command
muser described above). Use section 6 for further details
on query commands.
Note: To enter data from a file, you must start the mysql client with
the --local-infile option, i.e.:
mysql -h amigo --local-infile -p