HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Mysql remote access - ERROR 1045 (28000): Access denied for user (http://www.howtoforge.com/forums/showthread.php?t=58680)

spazio 10th September 2012 21:38

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?

till 11th September 2012 08:31

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.

spazio 17th September 2012 20:01

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

falko 18th September 2012 13:52

Did you specify any IP addresses for the remote access?


All times are GMT +2. The time now is 08:03.

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