[mysql] I can only connect from localhost

MaheS

I can only connect to my perfectly working mysql server from localhost

What could be the problem? How to fix?

moocha · Watchman Joined: 21 Oct 2003 Posts: 5722

Have you granted access to the remote users? I'm referring to MYSQL access/users.
_________________
Military Commissions Act of 2006: http://tinyurl.com/jrcto

"Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety."
-- attributed to Benjamin Franklin

MaheS · Posted: Fri May 14, 2004 2:48 pm Post subject:

Yes I have

it is not a 'user can't login' problem, it's can't connect to database problem! :s

Spooky Ghost · Posted: Fri May 14, 2004 3:11 pm Post subject:

Check bind_address in /etc/mysql/my.cnf

MaheS · Posted: Fri May 14, 2004 3:46 pm Post subject:

bind_adress = 127.0.0.1

Ok I putted this line in comment, works! thx vry mutch

Now I need to take care of the 'Acces denied for user: ... ' error

but that shouldn't be much of a problem

tecknojunky · Posted: Mon Oct 04, 2004 6:30 pm Post subject:

I just installed mysql for the first time and I'm trying to set root passwords, as specified by the ebuild at the end of the merge.

Similar problem:

kashani · Posted: Mon Oct 04, 2004 8:09 pm Post subject:

tecknojunky · Posted: Mon Oct 04, 2004 8:14 pm Post subject:

The locolhost part is done and worked on the 1st shot.

# /usr/bin/mysqladmin -u root -h manitou.inet password 'sayagain'
/usr/bin/mysqladmin: connect to server at 'manitou.inet' failed
error: 'Host 'manitou.inet' is not allowed to connect to this MySQL server'
_________________
(7 of 9) Installing star-trek/species-8.4.7.2::talax.

kashani · Posted: Mon Oct 04, 2004 8:22 pm Post subject:

ping manitou and see which IP you get. I'd guess that it goes to the interface and not 127.0.0.1

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

tecknojunky · Posted: Mon Oct 04, 2004 8:30 pm Post subject:

kashani · Posted: Mon Oct 04, 2004 8:38 pm Post subject:

Right, but the important distinction is that only localhost has access after that first command you ran. To see, do this.

mysql -u root -p
use mysql;
select * from user;

You'll most likely see only a localhost entry. You'll need to do something like this:

GRANT ALL PRIVILEGES ON *.* TO root@manitou IDENTIFIED by 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED by 'password' WITH GRANT OPTION;

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

tecknojunky · Posted: Tue Oct 05, 2004 3:48 am Post subject:

But, but, I'm just doing verbatim what was said here:

fleed · l33t Joined: 28 Aug 2002 Posts: 756 Location: London

You're close!
You can either restart mysql after you do the grants (not really necessary but might be easiest for you)

Or you could connect again:

tecknojunky · Posted: Tue Oct 05, 2004 8:55 am Post subject:

I give up. I don't understand why ebuild's instructions do not work only for me. :cry:

_________________
(7 of 9) Installing star-trek/species-8.4.7.2::talax.

fleed · l33t Joined: 28 Aug 2002 Posts: 756 Location: London

You have to know what you're doing!

tecknojunky · Posted: Tue Oct 05, 2004 9:11 pm Post subject:

fleed · l33t Joined: 28 Aug 2002 Posts: 756 Location: London

Sure you can expect anything! (just kidding)

I think the instructions are meant as more of a reminder of what you should do. And you should know how to use the software before you're actually able to use it, the ebuild only gives you a few pointers.

trossachs · Veteran Joined: 22 Jan 2004 Posts: 1204 Location: London

Just to butt in here rather than start another post, but when I try and connect to my database remotely using the GUI mysqladmin, I get this error:

Ian Tindale · n00b Joined: 13 Dec 2002 Posts: 16 Location: London

I get exactly the same problem. Follow the instructions on the ebuild to the letter, it doesn't work. Give up - waste of time.
_________________
Ian Tindale

trossachs · Veteran Joined: 22 Jan 2004 Posts: 1204 Location: London

Does nobody esle have an angle on this?

kashani · Posted: Fri Nov 26, 2004 7:28 am Post subject:

What does netstat -ptln say?

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

trossachs · Veteran Joined: 22 Jan 2004 Posts: 1204 Location: London

My box says this:

fleed · l33t Joined: 28 Aug 2002 Posts: 756 Location: London

trossachs · Veteran Joined: 22 Jan 2004 Posts: 1204 Location: London

Sorted, it works. thanks