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?