good database for forum

[Stuart]

I need a database for my forum on my site, but I can't seem to get MySQL..suggestions? (btw, apache2.0.43, php4(cvs'd last night)

[Blaqb0x]

what do you mean "can't seem to get MySQL"

download and install it.

[Stuart]

I *REALLY* should have specified on that one... The install *appears* to go fine, but after starting mysqld_safe and trying to connect it gives me an error something like "$Cannot connect through /tmp/mysql...." yea, something like that.. I wish I could be more specific.. I have looked through alot of documentation, and I can't seem to get it...

[Schotty]

do you need a walkthrough on setting up MySQL?

[Stuart]

yes, a very very very *IDIOT* proof walkthrough

[Schotty]

Allright, Ill get my MySQL book out and hack a quick tutorial on setting it up. BTW, its mainly just running a few things to setup the daemon itself and the admins of the tables. Its really not that hard, but since I rarely do an SQL anymore, much less MySQL, I completely forget how. Needless to say, I can rest assured that it seems hard (did for me) but is silly how really simple it is to get set up.

Gimme a few hours. The book aint that far ;D Just gotta dig thru my 'pile' ;D

[Stuart]

Thank you so much man

[gorn]

My apahce how to has a howto install MySQL check it, if it's not helpful enough then wait for Schotty.

http://www.linuxjunior.org/cgi-bin/p...play&id=76

[Schotty]

Allright, I am going to presume that you can install an RPM, .deb, or build a tarball. If that is an issue, we have other problems than MySQL.

Allright, you just got it installed. Now we must make it usable. Note any distro, should have this done already. MY RH* install didnt need this step. In fact I could skip to starting the daemon.

As root

cd /usr/local/mysql
scripts/my_sql_install_db

Now the book I have wants to make all of the stuff in a mysql group. Its up to you, I personally think its a great idea.

so ...

groupadd mysql
useradd -g mysql mysql
chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chown -R mysql /usr/local/mysql/data

And to start the server, use either RedHats service control (if you grabbed an RH RPM) or whatever method you like, or this command (as listed in my book)

/usr/local/mysql/bin/safe_mysqld --user=mysql &

Okay. Cool beans we got it setup. Now we need to test thast you can connect to the DB, and manipulate data. Just like all good little databases should.

Lets connect. When it asks for a password, hit enter. All MySQL users are unique from the host. So root, bob, fuzzy, and fred in your unix box, are not the same as a root, bob, fuzzy, and fred in the MySQL DB. As of now, root is the only account, and has a null password.

mysql -u root -p

You should have a few databases by default installed, and a

show databases;

will display them. Note the semicolon at the end. It matters ;D

Lets make a table and some data and retrieve it. The following should make sense, so I am not going to go apeshit getting inot detail.

create database ljr;
use ljr;
create table table1 (data1 int);
insert into table1 (data1) values (1);
insert into table1 (data1) values (2);
insert into table1 (data1) values (3);
insert into table1 (data1) values (4);
insert into table1 (data1) values (5);
select data1 from table1 where data1 > 0;

Allright, we created a DB called "ljr".
We switched to it.
Created a table
Queried the data (in a really haphazrd way, but simple enuf).

Now to delete the crap we created

drop table table1;
drop database ljr;
Inserted some data

Any questions ;D

[Compunuts]

Any plan to make a PET out of it? Or do we already have one? I will install MySQL and follow for just the heck out of it.