Lorraine,
The key here is that you are asking to connect from a different
workstation. If you go into the mysql user table and look at the root user
you will see that it is only allowed on the ³localhost² (use mysql;select
host,user from user;). That will limit the root account so that mysql will
only allow it to connect from the local machine. Since you want to connect
from a remote machine you will have to add in a user (I don¹t recommend
opening up root account permissions for this) that has access from other
systems. You can either specify the host that it will connect from or use
wildcards.We generally setup either application accounts for use from specific hosts, or user accounts from anywhere. For more information check out the documentation on the mysql website. It is a great resource for mysql information (http://dev.mysql.com/doc/refman/5.0/en/adding-users.html). Example: CREATE USER joeuse...@¹%¹ IDENTIFIED BY somePassword¹; GRANT {whatever privileges} ON *.* to joeuse...@¹%¹; ************ I STRONGLY recommend that you DO NOT connect to the DDMDB through any application. Archive Manager is working hard enough on that database without any external application also interfering with the tables. We use this to access our Report Manager databases. ************ From: "Lorraine C. Alimay" <[email protected]> Reply-To: "Lorraine C. Alimay" <[email protected]> Date: Fri, 12 Mar 2010 14:02:39 +0800 To: spectrum <[email protected]> Subject: [spectrum] Spectrum Database to Windows ODBC Hi to All, Does anybody knows how to connect to spectrum ddmdb database using MySQL connector/ODBC from a different workstation. I used the .configrc as the credentials. (see screenshots). Is there any settings or credentials need to do to access ddmdb database? Thanks, Lorraine * --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
<<image.png>>
