Toad for MySQL - Community for development, administration, tuning, tips and tricks

Forums » General Discussion

Thread: Access Access denied for user 'someuse'@'111.222.333' (using password: YES)

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 3 - Pages: 1 - Last Post: Apr 27, 2012 6:36 AM by: calete	Threads: [ Previous \| Next ]

delvelasco

Posts: 1
Registered: 9/14/11

Access Access denied for user 'someuse'@'111.222.333' (using password: YES)
Posted: Sep 14, 2011 9:26 PM

Another newbie question.

Well from a totally new person using mysql i was able to install mysql on my pc. But now i want to use Toad to connect to mysql from another pc on our home network. I have created a new user as someuser@ipAddressOfSecondPc and granted all privileges. Then i open port 3306 on the PC with mysql. However when i try to connect i get Access denied for user 'someuser'@'ipAddressOfSecondPc' (using password: YES).

I've google and searched for a solution. I've read some other solutions to similar issues but with no luck. Any help would be appreciated. So basically i just want to connect from either PC in our home network.

Thanks to all who respond.

curious

Posts: 3
Registered: 3/29/12

Re: Access Access denied for user 'someuse'@'111.222.333' (using password: YES)
Posted: Apr 18, 2012 7:24 AM

in response to: delvelasco

I have a similar problem.

I use OS Win 7 and the local database is hooked without problems, but when I want to connect to database server on another site - there is a problem. All the parameters we set, but it definitely can not connect without a problem.

Can anyone help?

curious

Posts: 3
Registered: 3/29/12

Re: Access Access denied for user 'someuse'@'111.222.333' (using password: YES)
Posted: Apr 27, 2012 4:08 AM

in response to: curious

Is anyone can help?

calete

Posts: 3
Registered: 4/15/12

Re: Access Access denied for user 'someuse'@'111.222.333' (using password: YES)
Posted: Apr 27, 2012 6:36 AM

in response to: delvelasco

Thinks to check:

- MySQL is running on the ipAddressOfFirstPc? Telnet ipAddressOfFirstPc 3306
- On first pc, can you connect on the IP (not localhost or 127.0.0.1)?
- Check (in mysql/user database/table) that "someuser" has in the host value "%", meaning anywhere.
- If MySQL is running in "localhost" (127.0.0.1) rather than the IP, adjust my.ini to configure that.

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	Guru: 2001 + pts
	Expert: 751 - 2000 pts
	Enthusiast: 31 - 750 pts
	Novice: 0 - 30 pts
	Moderators
	Helpful answer (5 pts)
	Answered (10 pts)

Toad World

Downloads

Welcome, Guest