<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Zach Alexakos Geelong North Secondary College Information Technology Department</TITLE><BASE
href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\">
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<META content=FrontPage.Editor.Document name=ProgId>
<STYLE></STYLE>
</HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma" bgColor=#ffffff>
<DIV><FONT face=Arial>Hello all, </FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Had a look at PHPMyadmin but it ended up being quite
complicated eg: setting up configuration files etc... As a teacher I
don't have time to spend hours configuring servers although I'm finding that's
exactly what I am doing at the moment. </FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Webmin on the other hand (thanks Peter), was easy to
install but would come up with the message that cache privileges were not
enabled when trying to get it running from the browser. Trying to find the
relevant file was impossible- also trying to find the relevant support for this
problem was also impossible. Any advice for this particular problem would
be appreciated. </FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>But I'm still baffled by the fact that the mysql commands
for creating tables would not work via the command line screen. Having
created a million and one databases/tables using mysql (years ago at uni), this
one keeps coming up as a syntax error on line two (and it's exactly as it is in
the moodle documentation)- any help on this one would resolve all above
problems. Period.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>line 1- mysql> CREATE DATABASE moodle</FONT></DIV>
<DIV><FONT face=Arial>line 2- mysql> GRANT
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER ON moodle</FONT></DIV>
<DIV><FONT face=Arial>line 3- mysql> TO </FONT><A
href="mailto:username@localhost"><FONT
face=Arial>username@localhost</FONT></A><FONT face=Arial> IDENTIFIED BY
'password';</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>It creates the database but doesn't like line two or
three. </FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Zach Alexakos</FONT></DIV>
<DIV><FONT face=Arial>Nth Geelong SC</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=branson.darrel.l@edumail.vic.gov.au
href="mailto:branson.darrel.l@edumail.vic.gov.au">Darrel Branson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=moodle@edulists.com.au
href="mailto:moodle@edulists.com.au">The Moodle Users' in Schools Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, March 30, 2005 10:29
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Moodle] MySQL</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial>G'day,</FONT></DIV>
<DIV><FONT face=Arial>MC is is a filemanager and has nothing to do with Mysql.
You need to install phpMyadmin. <A
href="http://www.phpmyadmin.net/">http://www.phpmyadmin.net/</A></FONT></DIV>
<DIV><FONT face=Arial>This will give you a web interface into Mysql. You need
to have Apache running and php enabled.</FONT></DIV>
<DIV><FONT face=Arial>Cheers</FONT></DIV>
<DIV><FONT face=Arial>Darrel</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=BROWN-PH@oxley.vic.edu.au
href="mailto:BROWN-PH@oxley.vic.edu.au">Philip Brown</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=moodle@edulists.com.au
href="mailto:moodle@edulists.com.au">moodle@edulists.com.au</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, March 30, 2005 9:52
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Moodle] MySQL</DIV>
<DIV><BR></DIV>
<DIV>I think Red Hat has a utility called MC (Midnight Commander). If you
type that in at the command line (log in as super user) it might make
navigation less painful. I don't think you can access the Mysql
administration page using a browser unless you use WebAdmin.</DIV>
<DIV> </DIV>
<DIV>P. Brown<BR>Oxley College<BR>9727 9917<BR><BR>>>> <A
href="mailto:alexakos.zach.z@edumail.vic.gov.au">alexakos.zach.z@edumail.vic.gov.au</A>
30/03/2005 9:15:28 am >>><BR></DIV>
<DIV>
<DIV>To the Moodle list, </DIV>
<DIV> </DIV>
<DIV>Does anyone know if you can access the administration page of mysql in
Red Hat 9 using a browser? </DIV>
<DIV> </DIV>
<DIV>At the moment all I can access is the terminal command line
interface.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Zach Alexakos</DIV>
<DIV>Nth Geelong SC </DIV>
<DIV> </DIV>
<DIV> </DIV>
<P></P>
<P><B>Important - </B>This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before opening
or using attachments check them for viruses and defects. Regardless of any
loss, damage or consequence, whether caused by the negligence of the sender
or not, resulting directly or indirectly from the use of any attached files
our liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,
and not necessarily those of the Department of Education &
Training.</P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>moodle mailing
list<BR>moodle@edulists.com.au<BR>http://www.edulists.com.au/mailman/listinfo/moodle<BR></BLOCKQUOTE>
<P></P>
<P><B>Important - </B>This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before opening or
using attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or not,
resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender, and
not necessarily those of the Department of Education & Training.
<P>
<HR>
<P></P>_______________________________________________<BR>moodle mailing
list<BR>moodle@edulists.com.au<BR>http://www.edulists.com.au/mailman/listinfo/moodle<BR></BLOCKQUOTE><p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.</BODY></HTML>