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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
02-06-2005, 09:28 PM
|
#1
|
Member
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316
Rep:
|
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?
|
|
|
02-06-2005, 09:29 PM
|
#2
|
Member
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316
Original Poster
Rep:
|
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.
|
|
|
02-06-2005, 10:13 PM
|
#3
|
Member
Registered: Nov 2004
Location: Toledo, OH
Distribution: SuSE 9.2 Pro
Posts: 53
Rep:
|
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
|
|
|
02-07-2005, 03:23 PM
|
#4
|
Member
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316
Original Poster
Rep:
|
How do I create that user for mysql?
|
|
|
02-07-2005, 05:51 PM
|
#5
|
Member
Registered: Nov 2004
Location: Toledo, OH
Distribution: SuSE 9.2 Pro
Posts: 53
Rep:
|
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.....
|
|
|
02-08-2005, 12:01 AM
|
#6
|
Member
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316
Original Poster
Rep:
|
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?
|
|
|
02-08-2005, 04:47 PM
|
#7
|
Member
Registered: Nov 2004
Location: Toledo, OH
Distribution: SuSE 9.2 Pro
Posts: 53
Rep:
|
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"
|
|
|
02-08-2005, 05:37 PM
|
#8
|
Member
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316
Original Poster
Rep:
|
I don't think it's the user becuase it's not giving me that error anymore. It restarts just fine.
|
|
|
All times are GMT -5. The time now is 08:48 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|