[Moodle] MySQL

[Zach Alexakos]

Zach Alexakos Geelong North Secondary College Information Technology DepartmentHello all, 

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.  

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.  

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.

line 1- mysql> CREATE DATABASE moodle
line 2- mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER ON moodle
line 3- mysql> TO username at localhost IDENTIFIED BY 'password';

It creates the database but doesn't like line two or three.  


Zach Alexakos
Nth Geelong SC


  ----- Original Message ----- 
  From: Darrel Branson 
  To: The Moodle Users' in Schools Mailing List 
  Sent: Wednesday, March 30, 2005 10:29 AM
  Subject: Re: [Moodle] MySQL


  G'day,
  MC is is a filemanager and has nothing to do with Mysql. You need to install phpMyadmin. http://www.phpmyadmin.net/
  This will give you a web interface into Mysql. You need to have Apache running and php enabled.
  Cheers
  Darrel
    ----- Original Message ----- 
    From: Philip Brown 
    To: moodle at edulists.com.au 
    Sent: Wednesday, March 30, 2005 9:52 AM
    Subject: Re: [Moodle] MySQL


    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.

    P. Brown
    Oxley College
    9727 9917

    >>> alexakos.zach.z at edumail.vic.gov.au 30/03/2005 9:15:28 am >>>

    To the Moodle list, 

    Does anyone know if you can access the administration page of mysql in Red Hat 9 using a browser?  

    At the moment all I can access is the terminal command line interface.



    Zach Alexakos
    Nth Geelong SC  



    Important - 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.



----------------------------------------------------------------------------


    _______________________________________________
    moodle mailing list
    moodle at edulists.com.au
    http://www.edulists.com.au/mailman/listinfo/moodle


  Important - 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. 



------------------------------------------------------------------------------


  _______________________________________________
  moodle mailing list
  moodle at edulists.com.au
  http://www.edulists.com.au/mailman/listinfo/moodle


Important - 
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/moodle/attachments/20050330/f708247a/attachment.html