Re: [cobalt-users] mySQL

[jk@xxxxxxxxxxxx (Jens Kristian Søgaard)]

"Neil J. Kemp" <neil@xxxxxxxxxx> writes:

> >What about the mySQL administration. Can I do this via a web interface
> >(creating tables, adding users...) ? And: Where are the settings stored.

> I think you can do this via PhpMyAdmin (which you mentioned below) but

You can't add users (easily) via phpMyAdmin.

> >What about database limitations. Can I set a size limit for each database,
> >or are their sizes calculated with the user's quota on the RaQ2 ?

The size of the databases all count towards the quota set for the
MySQL-user (if such has been created, otherwise it's the root-users
normally). I.e. you would have to set up your own accounting for MySQL
space usage.

> There is a thing called MyODBC but that's rather for your server to connect
> to Access databases etc (to my understanding - I've never actually used it).

The other way around. It's great if you need to export an existing
Access database into your MySQL database.

> I don't believe there is anyway to access the databases EXCEPT from MySQL

There's plenty of other ways. You could for example use the
magnificent tool called KMySQL (KDE / GUI based).


-- 
Jens Kristian Søgaard,
jk@xxxxxxxxxxxx -- http://www.jksoegaard.dk/
Søger du noget? -- http://www.google.com/