Re: [cobalt-users] RAQ4 - mySQL

["Bryan - Utopian Web Productions" <bryan@xxxxxxxxxxx>]

> I wish to install mySQL on my RAQ4.
>
> I have downloaded the MySQL 3.22.32-1 package for the RaQ3 or RaQ4 from
> http://pkg.nl.cobalt.com/
>
> But what do I do now...
> Where do I upload it to on my server?
> How do I install the package?
> Is there anything I should do before the install?
> How do I know if it worked correctly?

15 Steps To Installing MySQL On Your Raq4:

1. Download the mysql package from:
http://pkg.nl.cobalt.com
(Note: you can also simply right-click on the link and Copy Shortcut, then
feed this URL into Step 2 below. Your box will go fetch the package itself.)
2. Access your Cobalt administration interface. Go to Maintenance(left
menu), then Install Software(top menu).
3. Either enter in the URL of the current mysql package from the above
page, or upload the package from your machine using the Browse button.
Click the "Install a '.pkg' package" button. Your machine will now do this.
It will take some time since it has to either upload or go fetch the
package and then install it. Be patient!
4. When it is finished, you'll see the MySQL package listed. Clicking on
that link will take you to the MySQL homepage.
(Note: I found that on my Raq4i, I did not need to recompile PHP. It worked
already.)
5. This package is installed with the defaults of: user 'root' password
'cobalt-mysql'. You should change this password!
6. The easiest way to interface with your new MySQL database is by using a
program called PHPMyAdmin. (It's free.)
http://www.phpwizard.net/
7. Open up config.inc.php in a plain text editor. The only values you need
to set are:
$cfgServers[1]['user'] = 'root';          // MySQL user (only needed with
basic auth)
$cfgServers[1]['password'] = 'cobalt-mysql';  // MySQL password (only
needed with basic auth)
8. Save config.inc.php and upload the entire PHPAdmin package (including
images already in their folder) to your box via FTP. You'll probably want
to password protect this directory or delete it when you're done and upload
it whenever you need to use it.
9. Using your browser, go to the directory where you uploaded PHPMyAdmin.
You'll see a two-frame window, with a list of installed databases on the
left (mysql and test) and some documentation on the right. Click on the
mysql database link on the left.
10. The right window will change to info on the mysql database. There is a
textbox there where you can directly enter commands. It says "Run SQL
query/queries on database mysql".
11. In this box, type:
SET PASSWORD FOR root=PASSWORD('your_new_password');
Do not change anything in the above line _except_ for your_new_password.
12. Hit Go.
13. Your browser's right frame will now give you an error. Don't freak out;
this is because you successfully changed the password and your script no
longer has the correct one in config.inc.php. Simply return to your plain
text editor where you have config.inc.php opened up, change the password
from 'cobalt-mysql' to whatever you put in as your new password, save and
re-upload.
14. Go back to the PhpMyAdmin directory and you'll be back in again (you
may need to refresh your browser).
15. Ta-da! You've now successfully installed MySQL and changed the default
password on your Raq. You're in business.