Help trying to setup linux web server (mysql & apache)

[Scootin159]

I got apache, ftp & samba going fine......well except one minor detail I'll mention later. However when trying to setup MySQL I ran into some issues.

I first installed MySQL (via rpm) & had everything working fine....then I totally killed it 🙂-/).
so...I uninstalled it (via rpm), and then reinstalled it....still didn't work (I managed to block root from getting in).
so now I went & deleted the /etc/my.cnf file & /var/lib/mysql directory (another mistake).
uninstalled (rpm) & installed (rpm).

now I get this:
command: service mysqld start
result: service mysqld not found
command: cat /etc/my.cnf
result: file does not exist
command: ls /var/lib/mysql
result: mysql, test, mysql.sock (it's all there)
command: rpm -q MySQL
result: MySQL-3.23.49a-1

If I open http://localhost/phpMyAdmin/ I can access all my databases, but if I try to open it in phpBB install it won't let me connect (am I using the right username/password? how do I set this up?)

another annoying 'glitch' that I mentioned earlier:
http://localhost/folder won't work
http://localhost/folder/ will work
http://localhost/folder/index.php will work

 

[Scootin159]

any ideas?

 

[Nothinman]

From the Debian default httpd.conf :

#
# Aliases: Add here as many aliases as you need (with no limit). The format is
# Alias fakename realname
#
# Note that if you include a trailing / on fakename then the server will
# require it to be present in the URL. So "/icons" isn't aliased in this
# example, only "/icons/"..
#


So look for the folder/ definition and change it to just folder.

 

[Scootin159]

<< From the Debian default httpd.conf :

#
# Aliases: Add here as many aliases as you need (with no limit). The format is
# Alias fakename realname
#
# Note that if you include a trailing / on fakename then the server will
# require it to be present in the URL. So "/icons" isn't aliased in this
# example, only "/icons/"..
#


So look for the folder/ definition and change it to just folder. >>



Except they are just folders in the document root that I am using, not aliased folders. I looked through the file & didn't see anything that would apply to real folders. I also checked & the document root folder doesn't have any trailing / on it.

 

[Nothinman]

Don't know then, http://server/folder has always worked for me.

 

[kt]

if you can access all your database thru phpMyAdmin, then look at the config.inc.php file in your phpMyAdmin folder. Look for the login information you entered. By default, the login user/password is root with no password. You change that by making changes to the database named "mysql". If you don't know what you're doing, I suggest reading up more on it before making any changes.

 

[Scootin159]

<< if you can access all your database thru phpMyAdmin, then look at the config.inc.php file in your phpMyAdmin folder. Look for the login information you entered. By default, the login user/password is root with no password. You change that by making changes to the database named "mysql". If you don't know what you're doing, I suggest reading up more on it before making any changes. >>



THANK YOU! That is exactly what I needed. Well maybe not EXACLY, but you gave me the hint I needed to figure out what I needed for my specific application. Thanks!