Does your MySQL installation actually have the root user with or without a password? it might also be your datasource setup in the WiTango editor and not the odbc.ini

R
On Saturday, August 17, 2002, at 06:12 PM, Rick Sanders wrote:


Hey Robert,

Thanks for the help!

I've tried using a different user by specifying the user in the ODBC.ini but it keeps defaulting to the root user!

Here's my odbc.ini which is in the /usr/local/tango/etc

[ODBC Datasources]
bloks=MySQL Database

[bloks]
Description = bloks database
Driver = /usr/local/lib/libmyodbc-2.5-2.50.38.so
DSN = bloks
ServerName = bloks (Also tried localhost)
Trace = No
user = root (Also tried other users)
password = bloks
port = 3306
host = bloks (Also tried localhost)
database bloks

Thanks in advance!

Rick



Actually it looks like you're making a connection ot the DB just fine, but the problem is that you're trying to access the DB as root and the root user of MySQL has a password set, and that's why you're getting rejected.

2 things:
1- use the root password
2- use a different user with the proper password (DO THIS NOT THE OTHER IF YOU CAN)

R
On Saturday, August 17, 2002, at 01:54 PM, Rick Sanders wrote:

Hey List,

I've installed WiTango successfully on Linux. Tafs run fine. However, when I try to run a taf connecting to a MYSQL DSN, I get:

[TCX][MyODBC]Access denied for user: 'root@localhost' (Using password: NO)
S1000

If anyone could help me with proper ODBC.ini and permission settings, I would greatly appreciate it!

Thanks in advance.

Rick Sanders
President, Web Energy
Tel: (514) 620-3006
Fax: (514) 620-3017
Web: www.webenergy-sw.com

Reply via email to