[cobalt-users] MySQL on a RaQ 4i how-to (install, password, uninstall)

["Carrie Bartkowiak" <admin@xxxxxxxxxxxxxxxxxx>]

It took me quite a bit of searching through the list and many web sites to
gather all of the information I needed to install MySQL, and this weekend to
*fix* MySQL thanks to a nasty php script I was trying out instead of
PHPMyAdmin. So I thought I'd put it all in one place for anyone else who
might be having trouble.
Remember, this is for a Raq4i... probably the same for 3's but you need to
use caution I suppose.

Download the package or just grab the shortcut for it at:
http://pkg.nl.cobalt.com/
Btw, the shortcut is:
http://pkg.nl.cobalt.com/i386/RaQ3-RaQ4-MySQL-3.22.32-1.pkg
Then you can upload it or just tell your Cobalt GUI to go get it and install
it.
As for PHP... PHP4 comes on the 4i, and when I installed this package I
didn't need to recompile PHP; it worked already.
You'll need to change the password, it's set by default to 'cobalt-mysql'.
Login as admin, su to root. (type 'su' and then type your admin password, it
is the same for root unless you've changed it.)
now go into mysql
mysql -uroot -p <enter>
enter 'cobalt-mysql' as the password (no quotes)
now you're at the mysql prompt: mysql>
mysql> set password for root=password('your_new_password');
Don't change any of the above line except for your_new_password!!

To interact with your MySQL, it's much quicker to use PHPAdmin than to try
to keep a connection through telnet (especially if you're using windows
sucky telnet client).
You can get it for free at:
http://www.htmlwizard.net/projects/phpMyAdmin/


Now, if you ever have a problem with your MySQL that you simply *cannot*
fix; the cobalt GUI won't let you reinstall it because it will say it's
already installed.
You can try untarring the .pkg and reinstalling the individual rpm's, but
take it from me... it ain't worth it.
It's much quicker and easier to uninstall it and then reinstall it again.
Warning: this WILL flush all of your users, but not your databases and
tables that you've made since you installed the pkg the first time. ALWAYS
keep a paper list in your desk somewhere of all of your users, their
passwords, and what db's those usernames are for in case you ever need to
reset anything. If you're really paranoid, back up your db's before you
uninstall, but it wasn't necessary for me.
To backup the db's:
login, su to root
go to /home/mysql
chown the database folders and everything in them to admin
chmod the database folders and everything in them to 777
download them in ASCII with your favorite FTP program.
chmod everything back to 550
chown everything back to root.

To uninstall the MySQL pkg:
login, su to root, then type:
/var/lib/cobalt/uninstallers/MySQL-3.22.32-1.uninst
Now you can bounce over to /home/mysql and verify that your db's are still
there.
Go ahead and reinstall the .pkg (directions above); don't forget to reset
the default cobalt-mysql password.

If you ever forget your MySQL root password:  (can you tell I've had one
hell of a weekend?)
login, su to root, and take down the mysql server by typing:
/etc/rc.d/init.d/mysql stop
it'll say something like "killing mysql with pid ###".
restart the server without any users by typing:
/usr/sbin/mysqld -Sg
now login to mysql by simply typing "mysql" (no quotes)
mysql>FLUSH PRIVILEGES
mysql>set password for root=password('your_new_password');
mysql>FLUSH PRIVILEGES

You'll probably want to kill it and restart it again normally after that.

If you ever run into a malicious script that wipes out your main mysql
database, just do a locate for mysql_install_db and cd to that directory,
then type:
mysql_install_db
it will reinstall the host database *and* put in a new user database as
well. Again, always have that list handy so you can reset your users.

Cheers, and here's hoping this saves someone from having the same 24hrs that
I just had!  (hey, at least I learned a ton of stuff...)

Thanks go to Alex Lee for attempting to help me find MySQL before any of
this started, which got me searching for his names in the archive and helped
me find a post of his saying where the MySQL package for the RaQ was. (Then
again, that's what got me into this mess... hehehe)

A very brain-fried
Carrie Bartkowiak