http://www.mysql.com/doc/G/R/GRANT.html
You need to GRANT 'emdtest.ncr.com' permission to connect or a user from
any box to connect with a user name and password.
mysql> GRANT ALL PRIVILEGES ON *.* TO kenneth@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
means kenneth can connect from box ("%") with a password. Remember you
need to Flush your new settings for them to take effect.
Read Learn Live
http://www.mysql.com/doc/A/d/Adding_users.html
>
> I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to
> this MySQL database server'
>
> How do I correct this???
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
