thanks
| ClanKiller.com http://forums.clankiller.com/ |
|
| mySQL and phpBB http://forums.clankiller.com/viewtopic.php?f=24&t=806 |
Page 1 of 1 |
| Author: | Mole [ Sun Apr 25, 2004 10:43 am ] |
| Post subject: | 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? |
|
| Author: | Pig [ Sun Apr 25, 2004 3:11 pm ] |
| Post subject: | |
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. |
|
| Author: | Mole [ Sun Apr 25, 2004 3:25 pm ] |
| Post subject: | |
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! |
|
| Author: | Mole [ Sun Apr 25, 2004 4:35 pm ] |
| Post subject: | |
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... |
|
| Author: | Mole [ Mon Apr 26, 2004 4:26 am ] |
| Post subject: | |
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. |
|
| Author: | Pig [ Mon Apr 26, 2004 5:51 am ] |
| Post subject: | |
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. |
|
| Author: | ElevenBravo [ Mon Apr 26, 2004 5:53 am ] |
| Post subject: | |
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/ |
|
| Author: | Mole [ Mon Apr 26, 2004 7:01 am ] |
| Post subject: | |
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. |
|
| Author: | derf [ Tue Apr 27, 2004 7:57 am ] |
| Post subject: | |
Now i know your name, im going to hunt you down and rape you! |
|
| Author: | Satis [ Tue Apr 27, 2004 3:21 pm ] |
| Post subject: | |
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). |
|
| Author: | Pig [ Tue Apr 27, 2004 3:38 pm ] |
| Post subject: | |
http://dev.mysql.com/doc/mysql/en/GRANT.html |
|
| Author: | Mole [ Tue Apr 27, 2004 5:19 pm ] |
| Post subject: | |
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. |
|
| Author: | Pig [ Tue Apr 27, 2004 6:39 pm ] |
| Post subject: | |
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. |
|
| Author: | Mole [ Wed Apr 28, 2004 5:55 am ] |
| Post subject: | |
thanks
|
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|