MySql Admin

[Vernon Brown_4]

I have Fedora Core 4 with Apache server, MySql and PHP 5. In trying to get phpBB2 forum going I need to create a database and a user with access to that dataabase in MySql.

Does anyone know how to access MySql with admin priviledges. This is a new install of C4 with mysqld started from the command line with
> service mysqld start
I need to know how to find the admin username and password. Using root as user with the root password doesn't work.

Thanks for any help.

[Vernon Brown_4]

Google search turned up that the root account is activated with blank password, and so have now gained admin access to mysql, changed password and set up admin account.

Now I need to find out how to get PHP and MySql talking to each other.

[Steven E. Protter · Accepted solution]

Hi Verson:

Some mysql links:

http://www.apachefriends.org/en/

http://www.linuxhelp.net/guides/lamp/

I also have some notes at home. I'll be there in about an hour.

You may have issues integrating PHP 5 and mysql 4.x

I know HP has an integration of mysql 5 and php 5 but thats hp-ux. Red Hat has been extremely slow at moving along with mysql releases.

Now: there is a mysql log in /var/log/mysql (maybe mysqld).

Anyway, if there is more that I can do for you when I get home, I'll re-post.

Aside:
Congratulate Bill Hassell on point number 30,000.
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=973677

SEP

[Vernon Brown_4]

Thanks Steven; I found the "docs" manual and am pouring over it. I've already set up 3 phpBB2 forums, but in all three I had to download source and re-compile Apache2, PHP 5, and MySql. I'm trying it this time with Fedora 4 out of the box.

First thing I notice is that MySql support was not part of the PHP5 .config. So maybe it's not possible.