LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
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 02-06-2005, 09:28 PM   #1
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Rep: Reputation: 30
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?
 
Old 02-06-2005, 09:29 PM   #2
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
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.
 
Old 02-06-2005, 10:13 PM   #3
monroetech
Member
 
Registered: Nov 2004
Location: Toledo, OH
Distribution: SuSE 9.2 Pro
Posts: 53

Rep: Reputation: 15
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
 
Old 02-07-2005, 03:23 PM   #4
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
How do I create that user for mysql?
 
Old 02-07-2005, 05:51 PM   #5
monroetech
Member
 
Registered: Nov 2004
Location: Toledo, OH
Distribution: SuSE 9.2 Pro
Posts: 53

Rep: Reputation: 15
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.....
 
Old 02-08-2005, 12:01 AM   #6
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
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?
 
Old 02-08-2005, 04:47 PM   #7
monroetech
Member
 
Registered: Nov 2004
Location: Toledo, OH
Distribution: SuSE 9.2 Pro
Posts: 53

Rep: Reputation: 15
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"
 
Old 02-08-2005, 05:37 PM   #8
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
I don't think it's the user becuase it's not giving me that error anymore. It restarts just fine.
 
  


Reply



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
SuSE 10.0, Apache2, MySQL, PHP ? petelogan SUSE / openSUSE 4 10-28-2005 10:14 AM
mysql 5.0.3 and Apache2 question bshearer *BSD 2 05-15-2005 02:51 AM
apache2 & mysql JJX Linux - Software 1 12-02-2004 07:16 AM
AS 3 w/ PHP, MySQL, and Apache2 pollardw Red Hat 1 02-23-2004 08:47 PM
apache2 prefork + php4 + mysql rymonree Linux - Software 1 09-06-2003 02:03 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:29 PM.

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
Open Source Consulting | Domain Registration