MySQL - Can login w/ root via myPHPAdmin, but not remotely

[swamplander]

I've installed MySql and the add-on package phpMyAdmin and can login just fine using the root account. However when I create additional accounts and grant them full rights, they can't login. Creating accounts like this:

CREATE USER 'johndoe' IDENTIFIED BY 'johndoe';
GRANT ALL ON *.* TO 'johndoe';

In addition, when I install something like MySQL Workbench on another machine (Win7 x64) on my network, I can't login to the MyPHP on the server using the root account. Just to ensure it wasn't a firewall issue, I turned the firewall off on the client machine. And to make sure I can get to it, I can telnet to the NAS on port 3306 and get a response.

I've also ensured the "Enable TCP/IP Networking" is enabled, applied and the port is 3306.

At this point I'm a bit lost as to what could be going on. It seems that it simply (1) won't allow anyone to connect remotely and (2) will only allow the root to connect. I don't have any experience with MySQL and have read wikis and posts, but still lost. I do have experience with MS SQL Server (but that isn't helping here). Any tips?

[schumaku]

MYSQL support is out of scope here...

In brief, you need to add @ [source] - just specifying a username is ganting local access only, no network.

http://dev.mysql.com/doc/refman/5.1/en/ ... users.html
http://dev.mysql.com/doc/refman/5.1/en/grant.html
http://www.cyberciti.biz/tips/how-do-i- ... erver.html (especially the part with the @ IP address here!)

[geva]

@swmaspandler - phpMyAdmin will allow you to create users and assign privilidges to them from either all (%) or specific hosts.

[smallfaihk]

you can set in phpadmin page directly

in user privilege page, in login information section, make sure you select "Any Host"