mysql and apache2
 

For some reason msyql isn't working properly with apache2. When I go into /etc/init.d/ and type ./mysql restart it says

Starting MySQL database server: mysqld
Checking for crashed MySQL tables in teh background.
Suzzy:/etc/init.d# /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'

This is a brand new installation of Debian and everything else. I install apache2, php4, apache2-mod-php4, and mysql-server. Is it just not configured with apache2 properly?

Also how do I take off the defualt redirect to /var/www/apache2-default/ on my site for apache2?

Okay this is weird. I updated mysql-server and now it doesn't give me the error, but it still isn't connecting on the forum.

have you created a mysql user named debian-sys-maint? If not, that's why you'll get that error!

and to take care of that redirect you need to open up your httpd.conf and change the
DocumentRoot directive to whatever directory you want to be your DocumentRoot

How do I create that user for mysql?

Well, I would first install phpMyAdmin to create and manage users other then root.

mysql should be setup automatic to accept connections from root, so first you need to create a root password

mysqladmin -u root password "new-password"

Then use phpMyAdmin to create and edit any other users.....

User Host Password Global privileges Grant Action
debian-sys-maint localhost Yes ALL PRIVILEGES Yes Edit

It appears to be made. I'm not sure what the password is though. Nothing?

well if he exists then use phpMyAdmin to create a new password...

if that is an actual user on your system you can as that user type

mysqladmin -u debian-sys-maint password "new-password"

I don't think it's the user becuase it's not giving me that error anymore. It restarts just fine.