LAMP server from scratch

nickoed · #1 03-21-2008, 04:37 AM

Hi all,

We have a spare powerconnect server in work and i was looking to set it up as a web server for a company intranet - more to gain experience in configuring a web server than anything else.

I decided to go with Fedora 8 as i'd used fedora previously and followed the LAMP tutorial on HowToForge.

However i've come across a problem which i just can't seem to resolve (after pretty intensive searching). So, i guess this post is in 2 parts.

Firstly, the error i'm getting is with mysql only. The error message is:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I understand this may be a generic error but i'm not sure what other information would be useful.

Secondly, as this is my first web server - have I made the correct choice in terms of linix release or would something like CentOS be more suitable? I'd like to get this right from the start now that i have the chance.

Thanks in advance!

Nick.

tamouh · #2 03-21-2008, 06:16 AM

Check this tutorial:

http://librenix.com/?page=LAMP

nickoed · #3 03-21-2008, 06:23 AM

That's the tutorial i followed. Both Apache and PHP work correctly but when mysql give this error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Nick.

dexxtreme · #4 03-21-2008, 07:07 AM

For a production machine I probably would have went with CentOS because the support lifecycle is longer than with Fedora.

For your mysql issues, where are you seeing that particular error? You will have to create separate mysql login for each script (blog, wiki, messageboard, etc.) that you want to run. You should never allow your scripts to connect directly to your server with the mysql root login. Also, on a new install I don't think that there is a default mysql password set, so you will need to change that as well.