topic MySql Admin in Operating System - Linux

MySql Admin

Vernon Brown_4 — Wed, 09 Nov 2005 19:25:28 GMT

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.

Re: MySql Admin

Vernon Brown_4 — Wed, 09 Nov 2005 23:05:29 GMT

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.

Re: MySql Admin

Steven E. Protter — Thu, 10 Nov 2005 10:16:34 GMT

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

Re: MySql Admin

Vernon Brown_4 — Thu, 10 Nov 2005 15:56:06 GMT

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.