Accessing remote MySQL database

[Devin Asay]

Brad,

Brilliant! I had been using the browser-based phpmyadmin utility to 
create users for this database. Apparently it does not do it properly. 
When I created the user using the mysqladmin command line application, 
it all worked as expected.

Thanks.

Devin

Brad said:

> I got stuck for awhile on the same error message. It turns out, as a
> default, the root mySQL user can only access mySQL from the local
> machine. For remote access, you should create another user and give
> it access from the host you'll be connecting from (or if you want
> that user to be able to connect from any address use '%' under the
> host column when you create the user.)

Devin Asay
Humanities Technology and Research Support Center
Brigham Young University