Devart Forums

I drop TMyConnection on form. Now I would like simply to see all databases on server. I have two mysql servers (4.0 on Linux/network and 4.1 on Windows/localhost).
I have granted all on testdb.* to my_user@localhost identified by 'pwd';
Properties are set like this: username=my_user, password=pwd, server='', direct=true.
Connect fails with 'Access denied for user...'
Setting property direct to false.
Connect succeeds and I am able to select database from drop-down list box.
At my 4.0 Linux machine works with direct mode, too.

Thank you for information.
It's known problem and we've already fixed it.
Please download the last MyDAC version (3.30.1.13).

Ikar, I am using 3.30.1.13 and this bug is happening.
Switching direct on/off is different in fail/success of connection.

We couldn't reproduce the problem.
Please send us TMyConnection definition and script to create my_user

C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 91 to server version: 4.1.7-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| infiko |
| mysql |
| t |
| test |
| voda |
+----------+
5 rows in set (0.00 sec)

mysql> grant all on t.* to testuser@localhost identified by 'testpwd';
Query OK, 0 rows affected (0.08 sec)

----------------------------------

object MyConnection1: TMyConnection
Options.Direct = False
Username = 'testuser'
Password = 'testpwd'
Left = 112
Top = 32
end

Database dropdown shows t, test.
Connecting using Connected property works, too.

object MyConnection1: TMyConnection
Username = 'testuser'
Password = 'testpwd'
Left = 112
Top = 32
end

Database dropdown raises exception "Access denied for user 'testuser@localhost' (using password: YES)"
Connecting using Connected property switching raises the same exception.

object MyConnection1: TMyConnection
Database = 't'
Options.Direct = False
Username = 'testuser'
Password = 'testpwd'
LoginPrompt = False
Left = 112
Top = 32
end

Database dropdown shows t, test.
Connecting using Connected property works, too.

object MyConnection1: TMyConnection
Database = 't'
Username = 'testuser'
Password = 'testpwd'
LoginPrompt = False
Left = 112
Top = 32
end

Database dropdown raises exception "Access denied for user 'testuser@localhost' (using password: YES)"
Connecting using Connected works, and, if I connect first, then database dropdown works fine and shows t, test.

Thank you for your sample. It does help us very much.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build.

Thanks, glad to help. When will it be available?

Ikar wrote:Thank you for information.
It's known problem and we've already fixed it.
Please download the last MyDAC version (3.30.1.13).

I have read your answer , and therefore I imidiately downloaded (3.30.1.13), but it still does not work. If I remove user and password from connectiondialog, I am alowed to see the databasenames in the combobox, also if I choose "root" without password, but not if I use my own username and password. I use the trialversion, but if this will work, I intend to buy the Mydac-component.

mvh
Viggo Denmark

In about three weeks.