Projects need MYSQL , I should take any UDFs?

[Rechard_Long]

  On 3/1/2016 at 9:55 AM, mLipok said:

Try new version:

 

Especially: 

 

Expand  

thank you very much

[mLipok]

There is no need to you such a big font size.
There is no need to quote post each time when you want to post.

 

[Rechard_Long]

>"C:\Program Files\AutoIt3\SciTE\..\autoit3.exe" /ErrorStdOut "C:\Users\TRANLONG\Desktop\BETA SKIN\ADO_EXAMPLE.au3"    
"C:\Users\TRANLONG\Desktop\BETA SKIN\ADO.au3" (762) : ==> The requested action with this object has failed.:
$oConnection.Open($sConnectionString)
$oConnection^ ERROR

@mLipok

Error @@!

[mLipok]

Try new version:

 

 

[Rechard_Long]

expandcollapse popup

>"C:\Program Files\AutoIt3\SciTE\..\autoit3.exe" /ErrorStdOut "C:\Users\TRANLONG\Desktop\BETA SKIN\ADO_EXAMPLE.au3"    
###############################
ADO.au3 (780) : ==> COM Error intercepted !
$oADO_Error.description is:     [MySQL][ODBC 5.3(a) Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:  80020009
$oADO_Error.lastdllerror is:    0
$oADO_Error.scriptline is:  780
$oADO_Error.source is:  Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:    
$oADO_Error.helpcontext is:     0
###############################
###############################
ADO.au3 (780) : ==> COM Error intercepted !
$oADO_Error.description is:     [MySQL][ODBC 5.3(a) Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:  80020009
$oADO_Error.lastdllerror is:    0
$oADO_Error.scriptline is:  780
$oADO_Error.source is:  Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:    
$oADO_Error.helpcontext is:     0
###############################
###############################
ADO.au3 (780) : ==> COM Error intercepted !
$oADO_Error.description is:     [MySQL][ODBC 5.3(a) Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:  80020009
$oADO_Error.lastdllerror is:    0
$oADO_Error.scriptline is:  780
$oADO_Error.source is:  Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:    
$oADO_Error.helpcontext is:     0
###############################
>Exit code: 0    Time: 0.4997

Errors like this are not you?

[mLipok]

  On 3/2/2016 at 12:31 AM, Rechard_Long said:

Errors like this are not you?

Expand  

This is related to MySQL behavior or driver behavior or to both.

$oADO_Error.description is:     [MySQL][ODBC 5.3(a) Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

 

When I ask "Uncle google" for:
"[MySQL][ODBC 5.3(a) Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)"

then he say's:

https://bugs.mysql.com/bug.php?id=71234

http://forums.mysql.com/read.php?37,602010,602010

http://stackoverflow.com/questions/16491843/connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option

http://stackoverflow.com/questions/18017354/mysql-odbc-link-fails-due-to-authentication-protocol-refused

 

[Rechard_Long]

I did it. Happy too , even the basic functions it? you document it? Please share them with me

[Rechard_Long]

 

I see a few presents guidelines and still do not get it . For example, in SQL like this :

SELECT password FROM db_users WHERE id = ' 1 '

it is 123456789 results go , so I want to put the results into

GuictrlcreateLabel($Result, 10, 10, 200, 50)

$Result is variable results

Edited March 3, 2016 by Rechard_Long

[tarretarretarre]

You could try this, no driver required, just unzip and go

 

 

[Rechard_Long]

  On 3/3/2016 at 5:51 AM, tarretarretarre said:

You could try this, no driver required, just unzip and go

 

 

Expand  

awesome , I made a pretty good support , so thank you

[mLipok]

 

  On 3/3/2016 at 2:43 AM, Rechard_Long said:

SELECT password FROM WHERE id db_users = ' 1 '

Expand  

'id db_users' what is this string in your query ?

If this is collumn name (with space in name) then try to use:

Local $sQUERY = "SELECT password FROM WHERE `id db_users` = 1"

 

http://stackoverflow.com/questions/14190798/how-to-select-a-column-name-with-space-between-in-mysql-on-liunx-ubuntu

 

  Quote

There's three kinds of quotes, single ', double ", and backwards `. In MySQL the first two are equivalent and can be used interchangeably. This is not always the case on other platforms, and Postgres in particular treats them differently. The backticks are used only for database or column name escaping. – tadman Jan 7 '13 at 6:46 

Expand  

 

btw..

on  MS SQL this should look like this:

Local $sQUERY = "SELECT password FROM WHERE [id db_users] = 1"

 

Edited March 3, 2016 by mLipok

[binhnx]

Hi @Rechard_Long

I totally don't get it. You get data from a database, then you use GUICtrlCreatePic which can only support local file. 

Your SQL query is also invalid. 

For any problem, first ask "Ông chú Google" first, then search the forum before write a post to ask.

[Rechard_Long]

sorry

Edited March 3, 2016 by Rechard_Long

[Rechard_Long]

  On 3/3/2016 at 9:54 AM, binhnx said:

Hi @Rechard_Long

I totally don't get it. You get data from a database, then you use GUICtrlCreatePic which can only support local file. 

Your SQL query is also invalid. 

For any problem, first ask "Ông chú Google" first, then search the forum before write a post to ask.

Expand  

Sorry , I was too quick to knock Guictrlcreatepic instead it is and I'm not looking at the printed guictrlcreatelabel found

[Rechard_Long]

  On 3/3/2016 at 8:27 AM, mLipok said:

 

'id db_users' what is this string in your query ?

If this is collumn name (with space in name) then try to use:

Local $sQUERY = "SELECT password FROM WHERE `id db_users` = 1"

 

http://stackoverflow.com/questions/14190798/how-to-select-a-column-name-with-space-between-in-mysql-on-liunx-ubuntu

 

 

btw..

on  MS SQL this should look like this:

Local $sQUERY = "SELECT password FROM WHERE [id db_users] = 1"

 

Expand  

sorry I'm wrong , rather

SELECT password FROM db_users WHERE id = 1

today I was just typing how this wrong , that wrong not see @@ !

[binhnx]

Okay, so everything should be clear now. The @mLipok's mySQL UDF use the latest/ a newer version of mysql driver which use another authentication hashing method that your mysql database does not support, so you need to do some addition step with your database to update that hash (for instruction to solve the problem please follow the link in previous @mLipok's post)

  On 3/2/2016 at 5:33 PM, mLipok said:

https://bugs.mysql.com/bug.php?id=71234

http://forums.mysql.com/read.php?37,602010,602010

http://stackoverflow.com/questions/16491843/connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option

http://stackoverflow.com/questions/18017354/mysql-odbc-link-fails-due-to-authentication-protocol-refused

Expand  

If you don't want to mesh with the database and if you use @tarretarretarre's UDF without any problem, just use it

-- Translated by Google myself

"Được rồi, mọi thứ rõ ràng rồi. UDF của @mLipok dùng với những phiên bản mới nhất của mysql driver, nó dùng phương pháp băm (hashing) khác để xác thực người dùng mà cơ sở dữ liệu mysql của bạn không hỗ trợ,  vì vậy bạn cần phải làm một số bước bổ sung với cơ sở dữ liệu của bạn để cập nhật các hash đó (hướng dẫn để giải quyết vấn đề xin vui lòng làm theo các liên kết trong bài trước của @mLipok)

Nếu không muốn động đến cơ sở dữ liệu và nếu bạn dùng @tarretarrentarre UDF mà không có vấn đề gì thì cứ dùng nó luôn đi"

Edited March 3, 2016 by binhnx
Add Vietnamese translation

[Rechard_Long]

I have connections , but select print function GuiCtrlCreateLabel like?

[binhnx]

If you want to display the password, you're not so lucky.

Many framework use an addition layer to protect the password so when hackers have access to the database, they cannot also steal the password from it. In addition, the password cannot be revert to the plain text form.

Unless the database and the code to populate data to the database is your code, I think you cannot get the real password

-- Translate:

Không được đâu sói ạ (don't be evil)

[Rechard_Long]

  On 3/3/2016 at 10:53 AM, binhnx said:

If you want to display the password, you're not so lucky.

Many framework use an addition layer to protect the password so when hackers have access to the database, they cannot also steal the password from it. In addition, the password cannot be revert to the plain text form.

Unless the database and the code to populate data to the database is your code, I think you cannot get the real password

-- Translate:

Không được đâu sói ạ (don't be evil)

Expand  

 

I am the administrator , I print out the value to be retrieved Guictrlcreatelabel function , you understand? What's your nationality?

[mLipok]

  On 3/3/2016 at 10:30 AM, binhnx said:

The @mLipok's mySQL UDF use the latest/ a newer version of mysql driver which use another authentication hashing method that your mysql database does not support

Expand  

ADO.au3 UDF not mySQL UDF - as this UDF is not only for MySQL but for all posible ADO (ODBC ) Driver.
You can use any driver you want to.

 

Edited March 3, 2016 by mLipok
wording