Re: Connectivity to MySQL DB

[Steve Ruby]

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

Re: Connectivity to MySQL DB

[Sanjeev Kabra]

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

- Original Message -
From: Quentin Bennett [EMAIL PROTECTED]
To: 'Sanjeev Kabra' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 6:45 PM
Subject: RE: Connectivity to MySQL DB


 Hi,

 You don't need a special process - the MySQL ODBC driver talks directly to
 the mysqld already running on Solaris.

 Regards

 Quentin

 -Original Message-
 From: Sanjeev Kabra [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, 31 January 2001 11:58
 To: [EMAIL PROTECTED]
 Subject: Connectivity to MySQL DB


 Hi Everybody,

 I have installed MySQL on Solaris and have even setup the connectivity
 using MyODBC on windows. I would like to know what I have to execute on
 Solaris like listener process for Oracle so that when I connect from
 windows environment I can connect to the database running on Solaris.

 Thanks in advance.

 Sanjeev.

 The information contained in this email is privileged and confidential
 and intended for the addressee only. If you are not the intended
 recipient, you are asked to respect that confidentiality and not
 disclose, copy or make use of its contents. If received in error
 you are asked to destroy this email and contact the sender immediately.
 Your assistance is appreciated.



-
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