phpBB

nautilus_1987 · 07-07-2003, 03:10 PM

Hello!
I am trying to install phpBB now and I really need some help.
I have downloaded phpBB 2.05 copied it to my server. And started the install (install.php). BTW I have compiled Apache with PHP 4.3.0 + MySQL 4.x. So I think that's enough for phpBB to run. Now I am complicated with such fields:
===========
Database Server Hostname / DSN:
Your Database Name:
Database Username:
Database Password:
Prefix for tables in database:
=================
What should I type here?

Proud · 07-07-2003, 03:16 PM

The details for your MySQL database doodle?

david_ross · 07-07-2003, 03:19 PM

Use these values - you need to create a database and asign permissions first (see below):
Database Server Hostname / DSN: localhost
Your Database Name: phpbb
Database Username: phpbb
Database Password: (see below - YOURPASSWORD)
Prefix for tables in database: (leave as is)

Create the db:
mysqladmin create phpbb

Add the privilages:
mysql

Then at the prompt:
grant all on phpbb.* to phpbb@localhost identified by 'YOURPASSWORD';

nautilus_1987 · 07-07-2003, 03:25 PM

interesting ......... when I type 'mysqladmin create phpbb' it gives following errors:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

???

david_ross · 07-07-2003, 03:27 PM

You probably don't have mysql running - start it then try again.

nautilus_1987 · 07-07-2003, 03:31 PM

1. I am not familiar with 'how to run mysql'
2. I have tried alot of commands starting with 'mysql' prefix and all they drop similar error. Can't open socket

Crashed_Again · 07-07-2003, 03:37 PM

Try this:

/etc/init.d/mysqld restart

to restart mysql.

david_ross · 07-07-2003, 03:38 PM

http://www.mysql.com/documentation/m...utomatic_start

trickykid · 07-07-2003, 04:56 PM

On Slackware do this first:

Code:

mysql_install_db
chown -R mysql.mysql /var/lib/mysql
safe_mysqld &

This will get your mysql server running.

Then to create another database instead of using the default one created by the mysql_install_db command, do what david_ross mentioned with the:

Code:

mysqladmin create phpbb

I would just opt to just use the database mysql though if you want to.

And then you can connect as root to mysql like this and then do these commands to grant a user that you will use for the phpbb board like this, if your going to use the default mysql DB that is installed already:

Code:

bash# mysql
mysql> use mysql
mysql> grant all on mysql.* to username@localhost identified by 'YOURPASSWORD' with grant option;

If you want your mysql to start automatically at boot time, do this:

Code:

cp /usr/share/mysql/mysql.server /etc/rc.d/
cd /etc/rc.d
mv mysql.server rc.mysql

Then you can edit your particular runlevel you boot to to start mysql with something like this in the file, for example runlevel 3 would be rc.M:

Code:

if [ -x /etc/rc.d/rc.mysql ] then
  . /etc/rc.d/rc.mysql start
fi

You can add the same thing on your reboot and shutdown scripts but instead stop mysql with the stop command in place of start to properly shut it down.

Hope this helps out..

nautilus_1987 · 07-08-2003, 02:27 AM

thanks trickykid, but
[root@ ~]# mysqladmin create phpbb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
=========
Maybe I have to login as simple user?

MasterC · 07-08-2003, 02:36 AM

Hey Nautilus, how's it goin?

Try logging is as the root user into mysql:
#mysql -u root -p

It should then prompt you for your root password (for mysql, not your root password for your system, these are seperate entities), so enter it. IF you get to a:
mysql>
Prompt, then you are good to go, but if you don't, or you haven't setup a root password in mysql, then that's what you should do.

You might wanna have a read over the mysql docs at www.mysql.com It really helped me get a slight hold on how mysql works, and how to use it. I still get caught up sometimes, but usually referring back to the docs works out the kinks.

Good Luck!

Cool

trickykid · 07-08-2003, 08:32 AM

Quote:

Originally posted by nautilus_1987
thanks trickykid, but
[root@ ~]# mysqladmin create phpbb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
=========
Maybe I have to login as simple user?

And if that doesn't work for some unknown reason for the instructions MasterC gave, login as root then simply type:

Code:

# mysql

And that should allow you access. Then see if you can't setup a user with permissions in the above steps, etc.

nautilus_1987 · 07-08-2003, 10:04 AM

Quote:

Hey Nautilus, how's it goin?

everything is ok Chad

(except mysql

)
===============
some strange stuff is happenning ........ People what version of mysql you are using? Mine is 3.2.25

nautilus_1987 · 07-08-2003, 10:07 AM

I remember when I was installing Apache + PHP + Mysql, everything was running smoothly ....... really. I have created a database, set pass .... interesting. Maybe I should upgrade mysql ?

MasterC · 07-08-2003, 11:00 AM

I'm using one from the 4.x tree, I believe it's 4.0.13, yes, just checked.

Working smoothly, and appears to be the suggested version in everything I've used lately. Might be worth a shot, follow the install docs perfectly and you shouldn't have a hitch at all.

Good Luck

Cool