It is currently Thu Mar 28, 2024 3:26 pm



Reply to topic  [ 14 posts ] 
mySQL and phpBB 
Author Message
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post mySQL and phpBB
Oooooookay. First and foremost, i have absolutly no clue what i am doing.

I've come to the conclusion, that in order to have phpBB you must first have a working database of sorts, and decided i wanted to learn mySQL anyway, so i figured this is a good way to start.

I've downloaded mysql, to this directory:
C:\Documents and Settings\Steven Fellows\My Documents\web\mysql

all the files, including the different sized *.cnf files, are in this folder. I've read about custom installs moving these files to other places, but i'm trying to keep it simple.

I followed THIS guide, as it's the simplest and most easy one to follow that i have come across.

I'll attatch my my.cnf as a .txt.

The problem, is the problem stated in the guide, the "Error 1067" but i can't see what i'm doing wrong, more to the point, i'm not sure i understand whats wrong. Any ideas/help/instructions would be much appreciated.

EDIT: I've noticed that the guide tells me to have a path to "ibdata" and "iblogs" yet these filers/folders (?) do not exist. What might they be? I notice it's "enqiuring" for a Dir, but does this just mean the directory in which this file is stored OR the location of this directory?


You do not have the required permissions to view the files attached to this post.

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Sun Apr 25, 2004 10:43 am
Profile WWW
Duke
User avatar

Joined: Mon Mar 31, 2003 8:59 am
Posts: 1358
Location: right behind you
Reply with quote
Post 
Do you have a web server set up already? Honestly, I would make life easy on yourself. Go download on the all in packages that PHP, Apache and MySQL (and phpmyadmin probably too). That will install everything for you. If the php or mysql version are older, you can just download the update and should not have to configure anything. PHP Triad is what I have used, but it is no longer being supported and the PHP and mysql and phpmyadmin versions are all old. There are other packages out there though that have it all-in-one as well. Search around on download.com or google for it.


Sun Apr 25, 2004 3:11 pm
Profile YIM WWW
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post 
I'm guessing these are like... "auto edditors" for the coding etc? I'm gunna get one for the mySQL side of things, and learn the stuff aswell as i go.

Yeah, I've already got my server set up, see the link in my signature!

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Sun Apr 25, 2004 3:25 pm
Profile WWW
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post 
this thing is fucking whack. I tried out the edditor on the MySql site, and it's shit. Non of it makes any sense, you change things, save it, and the changes just default to before the save...

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Sun Apr 25, 2004 4:35 pm
Profile WWW
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post 
Oh, and BTW the properties for for each field is dumb. Because I'm assuming that enum means "from the following" eg, Yes or No? Mr, Miss, Mrs? etc. But anyway, you can set that and still type whatever the fuck you want in there.

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Mon Apr 26, 2004 4:26 am
Profile WWW
Duke
User avatar

Joined: Mon Mar 31, 2003 8:59 am
Posts: 1358
Location: right behind you
Reply with quote
Post 
Mysql relies heavily on the logic coming from the programmer, which is part of why it is so fast. If you want something more compliant with ansi/iso, you should checkout postgresql.

As far as an admin program for mysql, I would use phpmyadmin. Very easy to use, and because it's web software, you can use it anywhere.


Mon Apr 26, 2004 5:51 am
Profile YIM WWW
King
User avatar

Joined: Wed Apr 16, 2003 2:18 pm
Posts: 1976
Location: Sexy Town
Reply with quote
Post 
Its really easier than you think.

If your doing this on your home computer then you need to complete the following steps.

#1 Install mysql
#2 Install Php (and make sure its working)
#3 Install phpbb ( the forums)

You cant do #3 until 1 and 2 have been complete and are working. Pig is right though, download that all in one package deal and its alot easier. Install Mysql really doesnt require much editing, but install php does.

http://www.mysql.com/
www.php.net
www.phpbb.com

To control mysql you this http://www.mysql.com/products/mysqlcc/

_________________
Contrary to popular belief, America is not a democracy, it is a Chucktatorship.
Image


Mon Apr 26, 2004 5:53 am
Profile ICQ YIM
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post 
Yeah, thats what i have. I've got all of the above. So i'm trying to get in installed localy to get a feel of it, then i'll do it on my web space.

But i'm using that program, and it simply isn't doing what i am telling it to. I entered default feild data, and decided i wanted to change it, (eg the format of the data in the field date, from the defualt 0000-00-00 to 00/00/0000 and there is no option to do that. Also, Just to check, i tried changing the default Mr, To Mrs. And it doesn't save it. Just goes back to Mr every time.

I can also type anything i want in to that field, when in theory, it should only let me type in one of the following. Mr, Mrs, Miss.

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Mon Apr 26, 2004 7:01 am
Profile WWW
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 2:17 pm
Posts: 7721
Location: Centre of the sun
Reply with quote
Post 
Now i know your name, im going to hunt you down and rape you!

_________________
"Well a very, very hevate, ah, heavy duh burtation tonight. We had a very derrist derrison, bite, let's go ahead and terrist teysond those fullabit who have the pit." - Serene Branson


Tue Apr 27, 2004 7:57 am
Profile
Felix Rex
User avatar

Joined: Fri Mar 28, 2003 6:01 pm
Posts: 16646
Location: On a slope
Reply with quote
Post 
I got a question. MySQL. How the hell do you create users and stuff so I can start manipulating databaseS? I have it married to IIS on my work box (win2k).

_________________
They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.


Tue Apr 27, 2004 3:21 pm
Profile WWW
Duke
User avatar

Joined: Mon Mar 31, 2003 8:59 am
Posts: 1358
Location: right behind you
Reply with quote
Post 
http://dev.mysql.com/doc/mysql/en/GRANT.html


Tue Apr 27, 2004 3:38 pm
Profile YIM WWW
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post 
Something tells me i'm going to have to do some basic MySql stuff to get a feel for this really. Is there good place to start? lol, like... what can i do with it? and simple step by step tutorials for begginers? I searched but couldn't find anything Decent.

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Tue Apr 27, 2004 5:19 pm
Profile WWW
Duke
User avatar

Joined: Mon Mar 31, 2003 8:59 am
Posts: 1358
Location: right behind you
Reply with quote
Post 
mysql is nothing on its own. It is only used (and useful) with a programming language. PHP is my favorite. Check out sitepoint.com for an article by kevin yank. It is a good intro. phpbuilder and webmonkey also have good articles.


Tue Apr 27, 2004 6:39 pm
Profile YIM WWW
Minor Diety
User avatar

Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4003
Location: Walsall, West Mids, UK
Reply with quote
Post 
thanks :D

_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts


Wed Apr 28, 2004 5:55 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 14 posts ] 

Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.