Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: good database for forum

  1. #1
    Mentor Stuart's Avatar
    Join Date
    May 2002
    Location
    nb.ca
    Posts
    1,087

    good database for forum

    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)

  2. #2
    Senior Member
    Join Date
    Apr 2002
    Posts
    417

    Re:good database for forum

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

    download and install it.

  3. #3
    Mentor Stuart's Avatar
    Join Date
    May 2002
    Location
    nb.ca
    Posts
    1,087

    Re:good database for forum

    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...

  4. #4
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760

    Re:good database for forum

    do you need a walkthrough on setting up MySQL?

  5. #5
    Mentor Stuart's Avatar
    Join Date
    May 2002
    Location
    nb.ca
    Posts
    1,087

    Re:good database for forum

    yes, a very very very *IDIOT* proof walkthrough

  6. #6
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760

    Re:good database for forum

    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

  7. #7
    Mentor Stuart's Avatar
    Join Date
    May 2002
    Location
    nb.ca
    Posts
    1,087

    Re:good database for forum

    Thank you so much man

  8. #8

    Re:good database for forum

    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

  9. #9
    Moderator
    Good Guru
    Schotty's Avatar
    Join Date
    Jul 2001
    Location
    Milwaukee, WI
    Posts
    5,760

    Re:good database for forum

    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
    Code:
    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 ...
    Code:
    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)
    Code:
    /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.
    Code:
    mysql -u root -p
    You should have a few databases by default installed, and a
    Code:
    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.

    Code:
    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

    Code:
    drop table table1;
    drop database ljr;
    Inserted some data

    Any questions ;D

  10. #10
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935

    Re:good database for forum

    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.

Similar Threads

  1. Help about Database!
    By hellagurl in forum Windows - General Topics
    Replies: 1
    Last Post: 05-24-2005, 11:16 AM
  2. Database client
    By doggiebone in forum Redhat / Fedora
    Replies: 20
    Last Post: 04-28-2003, 12:30 AM
  3. Database Information
    By mcdougrs in forum General Chat
    Replies: 0
    Last Post: 04-24-2003, 03:23 PM
  4. Good god why is this forum so slow!?!
    By in forum Announcements and Suggestions
    Replies: 17
    Last Post: 07-22-2002, 12:58 AM
  5. Database recommendations
    By papanohair in forum Linux - Software, Applications & Programming
    Replies: 2
    Last Post: 07-06-2002, 07:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •