Med Java - database:mysql https://medjava.ro/ 2026-04-07T04:10:52+00:00 Med Java https://medjava.ro/ https://medjava.ro/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2023-07-04T16:36:30+00:00 Anonymous (anonymous@undisclosed.example.com) session-commands https://medjava.ro/doku.php?id=database:mysql:session-commands&rev=1688488590&do=diff Session commands Show all processes show processlist Alternatively a query can be used: select id,user, host, db, command, time, state, info, progress from information_schema.processlist Kill a process kill 100 100 is the process id listed above. Oracle compatibility text/html 2025-01-02T18:22:18+00:00 Anonymous (anonymous@undisclosed.example.com) set-character-set-collation https://medjava.ro/doku.php?id=database:mysql:set-character-set-collation&rev=1735842138&do=diff MySQL Set Character Set and Collation For existing tables To use utf8 character set and utf8_general_ci collation: ALTER TABLE my_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Repeat this for all tables for which you need to adjust the character set and collation.