Sanjeev Kabra wrote:
>
> Hi,
>
> I installed MyODBC and even configured it. MySQL db running on Solaris is
> running under the root user. While defining the DSN using MyODBC in the
> username I tried putting root user and the password for the same but I keep
> getting error "can't connect to MySQL Server". The instance for MySQL is
> running. Is there any way to test the login process. I can logon MySQL db on
> using machine.
>
> Basically we are planning to user Actualte report writing tool and MySQL db.
> If you know any body using combination please let me know.
>
> Thanks.
>
> Sanjeev
You must grant privileges to users on remote machines.
See the manual for sintax on the GRANT command.. For example
if you wanted users on a machine with a specific IP to have all access
to a specific database you could do
mysql> grant all privileges on table.* to [EMAIL PROTECTED] identified by 'password'
if the server is on a "trusted" network and you just want to allow
access from any machine using a specific account you would o
mysql> grant all privileges on *.* to username@% identified by 'password'
bascialy when you install mysql it is only set up to alllow access using
user=root from the "localhost"
---------------------------------------------------------------------
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
