Re: [cobalt-users] MySQL Database

[Frank Svoboda <cobalt@xxxxxxxx>]

Hi!

> I need to install some software that links into a MySQL database.

You mean a web app? Like a CMS or other system that requires a DB?

> Is the version of PHP and MySQL on a standard 550 OK to use?

Sure, you can check the versions and maybe you want to upgrade for 
security or new features reasons.

> How do I create a blank database on the RaQ and do I administer it through
> the ASP server administration in terms of its name, user and passwords?

No idea how to do this via ASP. I'm using phpmyadmin 2.5.6 (try 
googling for it) for all mysql administration.

Here's a quick'n'dirty tutorial for what you want with phpmyadmin:

- DL phpmyadmin, install it and edit the config.inc.php file in the 
phpmyadmin-dir. For quick und highly unsecure reasons just enter the 
following values in the config:
- "PmaAbsoluteUri" - the http://... URL where you reach your 
phpmyadmin in the browser.
- Controluser & controlpass - user & passwort: root & password. The 
standard mysql-root-pswd on cobalt machines is "cobalt-mysql".

****
This works for a quick setup but be *sure* to secure your phpmyadmin 
because when someone else enters with these settings he can delete 
everything.
****

- Open phpmyadmin in your browser, if everything went O.K. you'd be 
in the main screen where you got several options and a pulldown left 
hand.
- Select Database "mysql", then table "user", click on "view" to view 
the current users.
- "add" a new user / line: Host: localhost (if the pages are on the 
same machine) | User: username | Password: password - choose one and 
in the pulldown select "password".
- All rights remain at "N" - No. A normal user should be not allowed 
anything here.

- Chose the link "Home", then press "restart mysql". It's necessary 
to accept the new user.

- Enter the name for the new DB in the field and click "add a new 
DB", est voila!

- Select Database "mysql", then table "db", click on "view" to view 
the current dbs and their access rights.
- "add" a new db / line: Host: localhost (same as above) | Db: 
db-name (the name of the db you just created before) | User: username 
(same as you created before).
- All rights but "grant" to "Y".

Ready! If you want to install a web application which demands a mysql 
DB you can now provide the needed informations: host, username, 
password. That's it! Much luck ;)

P.S.: Maybe some of the field names vary a bit because for me 
everything is in german and I freely xlated it 8)

Again: Remember to secure such a badly configured phpmyadmin for 
security resons! :)

Nity - Frank