[Shadow]

In MySql you can specify users as 'username@host'. Make sure that all users have the hostname set to 'localhost'. You can also block the port used by MySql, allowing connections from localhost only, and if you are so concerned about security, changing the port number of MySql seems to be a good idea, too!

[Shadow]

If I were you, I would not start my small business by developing a new inventory program! Look for a commercial one, they are not that expensive and have all the functions you require… In case you want to develop such a program, then you better turn to sources about business IT and accounting.

SQLyog is a database manager and definitely not a graphical end-user interface. It was designed for db admins and not for the average users!

[Shadow]

You can create an sql script file for the job and choose “Use a query…” option instead of copying the tables.

By the way, why do you have to import the same table that often?

[Shadow]

It seems, it is already done in MySql 4.1, because I don't get all the databases listed and I use 4.1-alpha…

[Shadow]

Yep, that's what I have meant, SQLyog crashes when I would like to select the table with the matching name from the list. So, it crashes BEFORE the Transformation button would appear, not to mention the “Column mapping and transformation” dialog.

I let Dr Watson to complete its error log (the word you won't understand are in Hungarian, but I provided the translations – hope accurately enough):

(the end of the processlist)

1652 SQLyog.exe

1760 drwtsn32.exe

0 _Total.exe

(00400000 – 004A8000)

(77F80000 – 77FFC000)

(77E80000 – 77F39000)

(77E10000 – 77E75000)

(77F40000 – 77F7C000)

(76AE0000 – 76B1D000)

(70BD0000 – 70C35000)

(78000000 – 78046000)

(77DB0000 – 77E0D000)

(770F0000 – 77161000)

(71710000 – 71794000)

(77560000 – 777AA000)

(77A50000 – 77B45000)

(779B0000 – 77A4B000)

(1F7B0000 – 1F7E1000)

(10000000 – 10043000)

(74FE0000 – 74FE9000)

(74FC0000 – 74FD3000)

(74FB0000 – 74FB8000)

(1F850000 – 1F866000)

(77260000 – 772CC000)

(6E360000 – 6E366000)

(75E00000 – 75E1A000)

(77810000 – 7781C000)

(77980000 – 779A4000)

(772F0000 – 77303000)

(774D0000 – 774D5000)

(772D0000 – 772E7000)

(750E0000 – 750F0000)

(75100000 – 7514F000)

(77BE0000 – 77BEF000)

(75150000 – 75156000)

(77950000 – 7797A000)

(77360000 – 7738E000)

(77330000 – 77352000)

(77800000 – 7780E000)

(77860000 – 778EF000)

(77C10000 – 77C6F000)

(77490000 – 774C2000)

(77470000 – 77481000)

(774E0000 – 77502000)

(77310000 – 77329000)

(777B0000 – 777B8000)

(777C0000 – 777C5000)

(74F60000 – 74F7D000)

(74FA0000 – 74FA7000)

(68B40000 – 68BC5000)

(77820000 – 7785E000)

(77070000 – 77093000)

(76F50000 – 76F5F000)

(77390000 – 773A5000)

(71160000 – 7125D000)

(013F0000 – 01539000)

(1F8F0000 – 1F932000)

(1B000000 – 1B16F000)

(1B5C0000 – 1B655000)

(1F8E0000 – 1F8EF000)

(1B2C0000 – 1B2CD000)

(1B2D0000 – 1B2F9000)

(1F800000 – 1F818000)

(777F0000 – 777F7000)

(75950000 – 75956000)

(1B7F0000 – 1B82A000)

(0F9A0000 – 0F9AB000)

(0F9C0000 – 0FA22000)

A szál (azonosító: 0x4b4) állapotlistája: – thread (id 0x4b4) state:

eax=00000001 ebx=002205d2 ecx=00454c68 edx=ffff7561 esi=00000000 edi=00000000

eip=00448cfe esp=0012e6c8 ebp=0012eaf8 iopl=0 nv up ei pl nz na pe nc

cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000202

függvény: -function:

00448ce6 56 push esi

00448ce7 8a11 mov dl,[ecx] ds:00454c68=61

00448ce9 8b7c2410 mov edi,[esp+0x10] ss:00c0bc9b=????????

00448ced 84d2 test dl,dl

00448cef 7469 jz 0045175a

00448cf1 8a7101 mov dh,[ecx+0x1] ds:00f3223a=??

00448cf4 84f6 test dh,dh

00448cf6 744f jz 00451847

00448cf8 8bf7 mov esi,edi

00448cfa 8b4c2414 mov ecx,[esp+0x14] ss:00c0bc9b=????????

HIBA ->00448cfe 8a07 mov al,[edi] ds:00000000=?? <-ERROR 00448d00 46 inc esi 00448d01 38d0 cmp al,dl 00448d03 7415 jz 0045111a 00448d05 84c0 test al,al 00448d07 740b jz 00451714 00448d09 8a06 mov al,[esi] ds:00000000=?? 00448d0b 46 inc esi 00448d0c 38d0 cmp al,dl 00448d0e 740a jz 0045111a 00448d10 84c0 test al,al 00448d12 75f5 jnz 0044ec09 *—-> Az egymásba ágyazott függvényhívások (fordított sorrendben) <----* *—->Nested function calls (in reverse order) <----* FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name 0012EAF8 0040CBDC 00000000 002205D2 00000003 00000000 !

0012F320 0040C4B7 00000000 0012F340 00E430E0 00454100 !

0012F3C4 0040BE55 00000000 00454100 00E42AF8 00000000 !

0012F3DC 00403EF1 001405DA 00000002 00000000 00454100 !

0012F400 00402E4F 00000000 00000000 00000201 00E42AF8 !

0012F448 004017F2 00000001 00180025 0012F578 0012F580 !

0012F464 77E11D0A 001405DA 00000201 00000001 00180025 !

0012F484 77E11BC8 0040164E 001405DA 00000201 00000001 user32!DispatchMessageW

0012F510 77E11CEF 0012F578 00000000 77E1ACA5 0012F578 user32!GetAppCompatFlags2

0012F540 71749972 001A049E 006124C0 000003FC 00141A60 user32!DispatchMessageW

0012F55C 7174B306 00141A60 0012F578 00141B6C 00141A60 comctl32!Ordinal389

0012F5B8 7174B517 0014DAE0 0012F7C0 0012F7C0 0012F86C comctl32!Ordinal389

0012F5D0 7174B56B 0012F5E4 00000007 180106B7 00000034 comctl32!Ordinal164

0012F618 0040B270 0012F7C0 77E172B7 0012F86C 00E41FF8 comctl32!PropertySheetA

0012F840 00409C4D 00E409FC 00439D77 00400000 00220450 !

0012FAF0 0042307C 00E41F28 77E12521 0025044E 00139EE0 !

0012FCFC 004217D4 00009D22 C0000000 00000111 0063D070 !

0012FD18 77E11D0A 0025044E 00000111 00009D22 002304D0 !

0012FD38 77E1350E 00421545 0025044E 00000111 00009D22 user32!DispatchMessageW

0012FD68 77E137A6 0063D070 00000111 00009D22 002304D0 user32!DefWindowProcW

0012FD88 7175D72E 0025044E 00000111 00009D22 002304D0 user32!SendMessageW

0012FDCC 7171A263 00139EE0 002304D0 00000202 00009D22 comctl32!CreateToolbar

0012FE38 77E11D0A 002304D0 00000202 00000000 000B000E comctl32!Ordinal320

0012FE58 77E11BC8 71719926 002304D0 00000202 00000000 user32!DispatchMessageW

0012FEE4 77E172B4 0012FF08 00000001 00446B00 0012FF08 user32!GetAppCompatFlags2

0012FF34 00449999 00E41F28 00000000 00133335 00000001 user32!DispatchMessageA

0012FFC0 77E9CA90 00000000 00000000 7FFDF000 C0000005 !

0012FFF0 00000000 004498CB 00000000 000000C8 00000100 kernel32!CreateProcessW

*—-> A veremtár tartalma <----* *—->Contents of the stack <----* 0012e6c8 10 a5 e3 00 d2 05 22 00 – 00 41 45 00 c6 fe 40 00 ……”..AE…@. 0012e6d8 00 00 00 00 68 4c 45 00 – 00 00 00 00 e0 30 e4 00 ….hLE……0.. 0012e6e8 6c f8 12 00 73 68 6f 77 – 20 66 69 65 6c 64 73 20 l…show fields 0012e6f8 66 72 6f 6d 20 60 6d 64 – 62 32 60 2e 60 54 e1 62 from `mdb2`.`T.b 0012e708 6c 61 31 60 00 00 00 00 – 00 00 00 00 00 00 00 00 la1`………… 0012e718 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e728 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e738 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e748 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e758 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e768 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e778 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e788 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e798 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7a8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7b8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7c8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7d8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7e8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7f8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 …………….

[Shadow]

I use SQLyog v3.11 and it does not display all the databases, just the ones the user has access to. Try checking the global rights!

[Shadow]

Well, Themetal, you haven't tried hard enough! In ODBC import choose table copy. Then you will see all the tables in your db in a list where you can specify which to import. After selecting a table, a button will appear in the “Transform” column. Just click it and then check the auto increment field in those columns you need it! Oh, and you can add indices as well!

[Shadow]

Sure it works, but there are a few catches as always… You may want check out MySql's manual (MyODBC section for example) or dwam.nt web site (http://www.dwam.net/mysql/).

[Shadow]

Currently I have no knowledge of any MySql clients that fully support v4.1 apart from mysqladmin. Ritesh promised a new version of SQLyog compatible with 4.1 to be released later this month, and MySql AB has been developing a new ODBC driver (v3.52, currently in alpha) which will comply with the new binary protocol of MySql 4.1. There is only one workaround to this problem: do not use passwords, users without password are able to connect to the server. If security is too important, then I suggest downgrading to 4.0.x.

[Shadow]

If the user does not have a password, then SQLyog is able to log in and works perfectly with 4.1-alpha…

[Shadow]

According to MySql AB, only ODBC Driver v3.52 will support the new binary protocol implemented in 4.1 . Guess, this might be the reason of login failures with passwords.

Shadow

[Shadow]

Hi!

I'm experiencing the same problem ever since upgrading to MySql 4.1 . Both MySql-Front and SqlYog (3.11) are unable to log in if password is required. Is there any solution to this?

Shadow

[Author]

Posts