I just tested the MySQL extension module under Debian 7 64 bit.
' MySQL Test Program
INCLUDE mysql.bas
dbh = mysql::RealConnect("localhost","root","******","sbtest")
mysql::query(dbh,"SELECT * FROM products WHERE productLine = 'Planes'")
WHILE mysql::FetchHash(dbh,column)
PRINT column{"productCode"}," - ",column{"productName"},"\n"
WEND
PRINTNL
PRINT "The database handle is: ",dbh,"\n"
PRINT "Affected rows by SELECT: ",mysql::AffectedRows(dbh),"\n"
PRINT "Character set name is: ",mysql::CharacterSetName(dbh),"\n"
PRINT "Last error is: ",mysql::ErrorMessage(dbh),"\n"
PRINT "Client info is: ",mysql::GetClientInfo(),"\n"
PRINT "Host info is: ",mysql::GetHostInfo(dbh),"\n"
PRINT "Proto info is: ",mysql::GetProtoInfo(dbh),"\n"
PRINT "Server info is: ",mysql::GetServerInfo(dbh),"\n"
PRINT "PING result: ",mysql::Ping(dbh),"\n"
PRINT "Thread ID: ",mysql::ThreadId(dbh),"\n"
PRINT "Status is: ",mysql::Stat(dbh),"\n"
mysql::Close(dbh)
admin@ip-10-191-131-54:~/sb22/test$ scriba testmysql.sb
S18_1662 - 1980s Black Hawk Helicopter
S18_2581 - P-51-D Mustang
S24_1785 - 1928 British Royal Navy Airplane
S24_2841 - 1900s Vintage Bi-Plane
S24_3949 - Corsair F4U ( Bird Cage)
S24_4278 - 1900s Vintage Tri-Plane
S700_1691 - American Airlines: B767-300
S700_2466 - America West Airlines B757-200
S700_2834 - ATA: B757-300
S700_3167 - F/A 18 Hornet 1/72
S700_4002 - American Airlines: MD-11S
S72_1253 - Boeing X-32A JSF
The database handle is: 1
Affected rows by SELECT: 12
Character set name is: latin1
Last error is:
Client info is: 5.5.31
Host info is: Localhost via UNIX socket
Proto info is: 10
Server info is: 5.5.31-0+wheezy1
PING result: -1
Thread ID: 0
Status is: Uptime: 22639 Threads: 1 Questions: 624 Slow queries: 0 Opens: 432 Flush tables: 2 Open tables: 42 Queries per second avg: 0.027
admin@ip-10-191-131-54:~/sb22/test$