LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-30-2003, 02:42 PM   #1
Nick2k3
LQ Newbie
 
Registered: Jun 2003
Posts: 4

Rep: Reputation: 0
MySQL 4.0.13-0 Configuration Help Please


OK, so far I've got Apache and PHP (both latest stable versions) installed and working perfectly. All done under the root account (might not be secure but that's what I've done).

All this is done on RedHat 9.0 using shell - I have no access to a gui.

Anyway, I now want to setup MySQL and I'm having a bit of trouble getting PHPBB working right. So far I've installed the RPM's of these:

Server 4.0.13-0 RPM

Client programs 4.0.13-0 RPM

Installed them both with RPM -i *client & server*

They both installed perfectly.

I setup a password using:

mysqladmin -u root password 123456 (for sake of argument).

Then, I put:

mysqladmin -u root -p123456 create forum

It created the forum in this directory:

/var/lib/mysql/

Now.... On PHPBB I'm using these settings to connect to the SQL database and I get a "cannot connect to the database" error.

The server name is server, I'm logged in as root@server.

Install screen:

da014a0002.pwp.blueyonder.co.uk/phpbb1.jpg

My IP in the piccy is NOT my correct IP, but when I use my correct IP I get the same error screen.

I've also tried database username as just 'root' but I still get this error message:

da014a0002.pwp.blueyonder.co.uk/phpbb2.jpg

What am I doing wrong? I can use the following commands OK and I can see my tables ok....

mysqlshow -p123456

and it shows my forum I created called forum is created OK.

Any help is appreciated, thanks.
 
Old 06-30-2003, 02:46 PM   #2
Nick2k3
LQ Newbie
 
Registered: Jun 2003
Posts: 4

Original Poster
Rep: Reputation: 0
Also, forgot to say I'm setting all this up on a windows PC connected to my linux machine using internet explorer.

I'm not doing this configuration on my linux machine, if that makes much difference.
 
Old 06-30-2003, 02:52 PM   #3
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
You will probably need to use "root@localhost" as the name. Personnaly I would grant access to another user using the mysql client:
mysql -p

Then use a grant statement:
grant all on forum.* to phpbb@localhost identified by 'phpbbpass';

Then "exit".

You can now use the username "phpbb@localhost" and password "phpbbpass"
 
Old 07-01-2003, 04:45 PM   #4
Nick2k3
LQ Newbie
 
Registered: Jun 2003
Posts: 4

Original Poster
Rep: Reputation: 0
Quote:
Originally posted by david_ross
You will probably need to use "root@localhost" as the name. Personnaly I would grant access to another user using the mysql client:
mysql -p

Then use a grant statement:
grant all on forum.* to phpbb@localhost identified by 'phpbbpass';

Then "exit".

You can now use the username "phpbb@localhost" and password "phpbbpass"
Thanks, I tried your suggestions but I still couldn't get it working

Does anyone know of a perfect step by step guide to get it installed and working OK? I've been googling all day but still I'm completely stuck. This is the furthest I've got with installing Mysql, I think i've perfectly done it but theres a security setting / config I'm missing or something
 
Old 07-01-2003, 05:05 PM   #5
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
Did you get any errors when running the mysql query (grant statement)?

Do you still get the same errors?

I just noticed that the error said "root@server@server" maybe you should just try root as the user.
 
Old 07-02-2003, 01:23 AM   #6
nakkaya
LQ Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45
are phpbb and mysql on the same machine?
 
Old 07-02-2003, 10:00 PM   #7
Nick2k3
LQ Newbie
 
Registered: Jun 2003
Posts: 4

Original Poster
Rep: Reputation: 0
Quote:
Originally posted by nakkaya
are phpbb and mysql on the same machine?
Yes they are.

Thanks for the help guys I managed to get everything working in the end. I had to do a full reinstall of RH9, recompile apache, php and install mysql from .rpm's and it works fine now.

Might not be secure... I'm running everything as root but the server is successfully running in run level 3 with apache 2.0.46, php 4.3.2 and mysql 4.0.13-0 installed and working fine.

I don't know what I did but the same settings I used before worked this time so maybe I misspelled something the first time I'm not sure .

The servers in a cupboard, there's only me on the network and I've got a router forwarding only traffic on port 80 to the server and the firewall on the server is configured as high and only to allow www / http data to come through...

I'm assuming this is fairly safe, it's working anyway .
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql configuration klemen *BSD 3 08-19-2005 12:00 AM
openldap configuration with mysql javier_ccs Linux - Software 1 07-06-2005 10:56 AM
Mysql 4.1 and PHP configuration? sikandar Linux - Software 2 05-30-2005 10:08 PM
MySQL configuration... needamiracle Linux - Software 0 07-22-2002 01:07 PM
MySQL configuration oulevon Linux - General 14 06-26-2001 11:55 PM


All times are GMT -5. The time now is 10:24 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration