Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 22nd December 2008, 14:40
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
Default phpmyadmin+mysql www-data access denied

Hi all,

I have a server running phpmyadmin and offcourse mysql.

Versions running :

phpMyAdmin 2.9.1.1-Debian-9
MySQL client version: 5.0.32
Server version: 5.1.30-Dotdeb_0.dotdeb.0

Yet, when i try to alter or add something to my database i get logged out with the reason :

#1045 - Access denied for user 'www-data'@'localhost' (using password: YES)

How could i resolve this ?

Thanks in advance.
__________________
A computer is almost human - except that it does not blame its mistakes on another computer.
Reply With Quote
Sponsored Links
  #2  
Old 23rd December 2008, 14:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by HooGLaNDeR View Post
#1045 - Access denied for user 'www-data'@'localhost' (using password: YES)
Are you seeing this in phpMyAdmin? Is the user name with which you log in www-data?
Are there any errors in Apache's error log?
You can enable MySQL logging to see which queries phpMyAdmin tries to execute.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 24th December 2008, 10:31
HooGLaNDeR HooGLaNDeR is offline
Member
 
Join Date: Sep 2006
Posts: 49
Thanks: 7
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by falko View Post
Are you seeing this in phpMyAdmin? Is the user name with which you log in www-data?
Are there any errors in Apache's error log?
You can enable MySQL logging to see which queries phpMyAdmin tries to execute.
Hi Falko,

I log in with my root account of MySQL.
There are no errors logged in the apache logs.
this is what phpmyadmin states when trying to add a new record in a table :

#1045 - Access denied for user 'www-data'@'localhost' (using password: YES)

Altering tables gives no errors.
__________________
A computer is almost human - except that it does not blame its mistakes on another computer.
Reply With Quote
  #4  
Old 25th December 2008, 10:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Strange. You might have to modify phpMyAdmin's config.php.

I wonder if the dotdeb PHP's MySQL client is not compatible with your MySQL server version.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Tags
mysql phpmyadmin www-data

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISP Config hesitation when opening web pages frankb Installation/Configuration 7 15th December 2008 13:06
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Can't Remote Access mysql 4.1 dedibox Installation/Configuration 2 24th August 2006 10:32
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 18:26
Problem recieving mail webstergd Installation/Configuration 19 16th December 2005 12:08


All times are GMT +2. The time now is 14:32.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.