Printable View
I want to download a full forum script in php and maybe another in asp and host it in a free web host and put the forum work at 100% on that host, so I can made some changes after that. I want to execute it on my pc too. I already have the latest php,apache and mysql in my machine. just need the steps to config the mysql with the form databases etc. Need someone who write some steps I have to follow. Thanks.
What forum script do you want to use?
phpbb is free and very good for a free forum software: http://www.phpbb.com/downloads/
vbulletin isn't free. It's what this forum uses.
I downloaded the phpbb. I´m having problems with the sql:ermm:. for example when I try to test the forum on my pc . I have the php, apache and mysql intsalled, but when I execute the script he try to install the forum but some sql problems because I didn´t created the db. How I do it? on msdos? and give me some help on put the forum working on a web host. :) tyQuote:
Originally Posted by rossco
get phpmyadmin, and use it to create a new database.
for example. I´m trying to test is a free host and they already create a database_name and username. when I upload the site to the ftp. what I´ll have to do? I have to go to the phpmyadmin and create alll the tables,fields etc of the database?Quote:
Originally Posted by rossco
if I want to test the forum on my computer on the virtual server what I have to do? create a bd on mysql? how I do this
Quote:
Originally Posted by TorrentMaster9
* shell commands are red
* mysql commands are green
* mysql infos are orange
This is how you create a DB with MySQL:
$ mysqladmin -u root -p create db1
Comment: with mysqladmin, you create with user "root" a table with the name "db1". If you just installed your mysql, root already exists and has no password.
Then, you have to administrate your newly created table with following commands:
$ mysql -u root -p mysql (Comment: you get on your mysql configuration)
mysql> GRANT CREATE,SELECT,INSERT,UPDATE,DELETE
-> ON db1.*
-> TO torrentmaster@localhost
-> IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.02 sec)
(Comment: this sets the good ownerships for you database)
More informations about "GRANT" here:
http://dev.mysql.com/doc/refman/5.0/en/grant.html
With this command, we have allocated the rights for user "torrentmaster" the rights to CREATE, SELECT, INSERT, UPDATE and DELETE everything on table db1 with the password "password" from localhost.
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Don't hesitate to ask if you have questions ;-)
rexton85
the fact your trying to get a forum up and running on a free host instantly rings alarm bells. chances are you wont be able to do it.
who is the free host ?
I prefer SMF over phpBB.
http://www.simplemachines.org/
Check it out.
I just want to check how it works. http://www.zendurl.comQuote:
Originally Posted by 4play
thanks:)Quote:
Originally Posted by Mud
I´m a noob on this don´t laught if I make stupid questions, hehe. I think the forum have to already have defined the the structure of the db(tables, fields, etc) and you just have to create a database(just the database name, user and pass) on mysql(of the webhost or of the one installed on your pc) and then make some changes on the code of the forum so it can work with that database created. it´s this right?
quickstart guide tells you how to install it.
The webhost had a install script option and had the chance to install phpBB and SMF, so I installed the phpBB. I wrote tha database name and user created on the web mysql and worked. thanks. when I have more doubts I´ll ask. thanks to all.
I need help again. I´m trying to execute the forums on my pc. I already installed apache,php and mysql and can execute scripts. when I try to install the forum I need the database name, user and password. I can create a database by the phpmyadmin script or by mysql command line(create database "name"). What I write on password and user? or how I define the user and pass?
Forget it again. the password default don´t have and the username in this case is "root". problem solved. thanks
oh...Quote:
Originally Posted by rexton85
thanks for the help:)Quote:
Originally Posted by rexton85oh...Quote:
Originally Posted by rexton85
http://www.minibb.net is nice! I've just put a forum together using it at http://www.flixfluxforum.co.uk - much more lightweight and easy to customise than phpBB, but it does lack some of the features
I´m using smf and I´m liking it a lot. Made already a lot of progress on the forum:)Quote:
Originally Posted by lephron