just fantastic!
> haven't testen USE MYSQL yet ;) ) it works :) i changed it to my database name and the show tables works also > Second command does a select host, user, password from user on the mysql with my database db1 i get error with sending command select host, user, password from user Columns # 255 Answer from server: FF 7A 04 23 34 32 53 30 32 54 61 62 6C 65 20 27 64 62 31 2E 75 73 65 72 27 20 64 6F 65 73 6E 27 74 20 65 78 69 73 74 We have an error 255 Error code: 1146, see https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html Error mess: Table 'db1.user' doesn't exist it appends .user to the table name which in database db1 is table named just db1 On Mon, 7 Aug 2023 19:15:27 +0200 Rik van Kekem <r...@graficalc.nl> wrote: > Op 07-08-2023 om 18:32 schreef paste...@gmx.com: > > i tried to do the following but i don't seem to get what is going on here - > > i'd appreciate if you could show me the error of my ways > I'm not sure about the packet numbering after the initial stage. > But I've got some more code for getting the data. > It's not yet perfected but it gets the columns and rows. > > First command does a SHOW DATABASES. > Second command does a select host, user, password from user on the mysql > database (for this the database at the top needs to be set to mysql, I > haven't testen USE MYSQL yet ;) ) > > Code is at https://gist.github.com/rvk01/ac22d368b8d1f7d537cf0c67389bda20 > (revision 2 of my gist) > > Still a rough draft ;) > Some code could still be compressed/cleaned up (like error checking etc). > > Grtz, > Rik _______________________________________________ synalist-public mailing list synalist-public@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/synalist-public
