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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th September 2012, 21:38
spazio spazio is offline
Member
 
Join Date: Apr 2007
Posts: 37
Thanks: 1
Thanked 2 Times in 2 Posts
Default Mysql remote access - ERROR 1045 (28000): Access denied for user

Hi
Ubuntu + mysql + ispconfig3

Even if the database remote access is enable in ispconfig3 I always get this error when I try to access from another server consol or 3rd party software.
ERROR 1045 (28000): Access denied for user 'user'@'xx.xx.xx.xx' (using password: YES)

Everything works great on localhost consol.

I tried with a couple of database, users and even with root user. Always the same thing.
If I log with phpmyadmin locally, everything is ok.

There must be something that need to be turned on.

I check in the manual but there is no other mention other than the check box enable remote access.Did I miss something?

What do I need to do to remotely access a database from another server/pc?
Reply With Quote
Sponsored Links
  #2  
Old 11th September 2012, 08:31
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,502
Thanks: 813
Thanked 5,264 Times in 4,128 Posts
Default

Please check the /etc/my.cnf or /etc/mysql/my.cnf file on your server, the line :

bind-address = 127.0.0.1

has to be commented out. Restart mysql when you changed the file.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 17th September 2012, 20:01
spazio spazio is offline
Member
 
Join Date: Apr 2007
Posts: 37
Thanks: 1
Thanked 2 Times in 2 Posts
Default

The line bind-address = 127.0.0.1 is commented out!
Mysql is listenning on all the ip.
If I create a user manually and give it access from the remote ip. Every thing work ok but not with user/pass created in ispconfig!

I just don't want to recreate all the users!
Is it supposed to work out of the box with ispconfig users?

S
Reply With Quote
  #4  
Old 18th September 2012, 13:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Did you specify any IP addresses for the remote access?
__________________
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

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
Forbidden don't have permission ISPConfig 3 BrainyForge General 13 22nd September 2011 16:38
DNS Lookups kieron General 4 4th May 2011 19:49
Postfix doesn't have Nolan Installation/Configuration 5 13th April 2011 05:00
SugarCRM Install on ISPConfig3 w/ SuPHP clucena Installation/Configuration 1 9th February 2010 09:29
MySQL remote access limitation Croydon Developers' Forum 0 30th May 2009 06:16


All times are GMT +2. The time now is 15:55.


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