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

["Fabian" <cobalt@xxxxxxxxx>]

Hi carrie..

I just downloaded the mysql.pkg file.-)

But do you know where I can get the pkg file for php3 or php4 ?
to install in the Cobalt 3...

Regards
Fabian



----- Original Message -----
From: "Carrie Bartkowiak" <admin@xxxxxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Cc: <admin@xxxxxxxxxxxxxxxxxx>
Sent: Monday, October 23, 2000 3:08 AM
Subject: [cobalt-users] MySQL on a RaQ 4i how-to (install, password,
uninstall)


> 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
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>