Information_schema is the only DB listed in Connector drop-down

--_e3d8a915-e6eb-452c-9388-d58f96cfff94_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


I've created several test databases=2C and they show up when I use the "sho=
w databases" command in the "MySQL command line client" window.
=20
When I try to create an ODBC connection to any of them=2C the only database=
that shows up in the database drop-down (in the MySQL Connector/ODBC windo=
w) is the Information_schema database.
=20
These are local databases=2C and I enter the computername as the server.
=20
Any thoughts?
=20
Thanks=2C
Dave
____________________________________________________________ _____
Windows Live=99: E-mail. Chat. Share. Get more ways to connect.=20
http://windowslive.com/explore?ocid=3DTXT_TAGLM_WL_t2_allup_ explore_012009=

--_e3d8a915-e6eb-452c-9388-d58f96cfff94_--

RE: Information_schema is the only DB listed in Connector drop-down

Hi Dave,

That sounds initially like a permissions issue. Have you checked that the
user you're connecting with has the relevant permission on the test
databases?
You can check that out easily enough using the MySQL Administrator GUI tool
or using the command-line syntax:

SHOW GRANTS FOR myusername@'%'

Post back if that's no good.

Al


-----Original Message-----
From: D Finn [mailto:d_m_finn@hotmail.com]
Sent: 27 January 2009 07:18
To: myodbc@lists.mysql.com
Subject: Information_schema is the only DB listed in Connector drop-down


I've created several test databases, and they show up when I use the "show
databases" command in the "MySQL command line client" window.

When I try to create an ODBC connection to any of them, the only database
that shows up in the database drop-down (in the MySQL Connector/ODBC window)
is the Information_schema database.

These are local databases, and I enter the computername as the server.

Any thoughts?

Thanks,
Dave
____________________________________________________________ _____
Windows LiveT: E-mail. Chat. Share. Get more ways to connect.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_allup_ex plore_012009


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org