Import External Data Wizard Needs Strange (For Me) Privilege

[Khushboo]

Hi,

We will look into this issue. In the mean while, please reply to these queries:

1. Are you able to connect to MySQL server at 192.166.100.20, using username 'mickey' through SQLyog at 192.168.200.30. (Please

2. If you are connected successfully, can you see database “my_project” in SQLyog's Object Browser? You can also execute “Show Databases” to check if you have access to this database.

Thank You.

Regards,

Khushboo

[MickeyMiner]

Hi,

thank you for a prompt response.

'Khushboo' wrote on '18:

2. If you are connected successfully, can you see database “my_project” in SQLyog's Object Browser? You can also execute “Show Databases” to check if you have access to this database.

Yes. I have the rights to see my databases (including my_project), their tables, triggers, structures and data. I have no rights to change the structures though.

I have just talked to our admins. They had to give me create table rights to migrate the data. But they have revoked them immediately after I was ready… This seems to be a bug in SQLyog, that I need more rights than necessary to simply make some inserts…

m.

[Khushboo]

Quote:

I have just talked to our admins. They had to give me create table rights to migrate the data.

To import successfully, the privileges required on target table depend upon the options selected in Import External Data –> Advanced Options (see the screen shot).

Please check what options you have selected? You can also attach a screenshot here.

Thank You.

Regards,

Khushboo

[Author]

Posts