MySQL¶

11. februára 2015
v Debian, Linux, MySQL
2 min čítanie

MySQL Workbench - passwords not being saved in keychain

MySQLWorkbench

If you have problem, that your MySQL Workbench can’t save passwords for your MySQL connections, try to start mysql-workbench in verbose mode. Maybe you will see a error:

$ mysql-workbench --verbose
** Message: Gnome keyring daemon seems to not be available. Stored passwords will be lost once quit
['un\\"o', 'do``s']
Ready.

Thread started

19. septembra 2014
v MySQL
1 min čítanie

MySQL consistency check - permissions and non-accessible databases

mysql-grant-syntax-2

The following query lists all grants for nonexistent databases:

30. apríla 2014
v MySQL
1 min čítanie

Create triggers with MySQL procedures

Angry developer

I wrote some SQL procedures, which can create triggers. The main goal was to create triggers for mysql schema, but it is not possible for the following limitation of current version MySQL and MariaDB:

1465 HY000 ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA Triggers can not be created on system tables

30. apríla 2014
v Linux, MySQL
2 min čítanie

Howto develop SQL procedures faster

Developer at work

If you are working on some SQL project, making SQL dump more readable is very useful. You need to optimize edit-import-try-fix-export loop, because you want develop your SQL procedures fast. Here are some tips how to accomplish this.

16. februára 2014
v MySQL
2 min čítanie

Ukladanie komentárov v stored procedúrach

gvim-MySQL-procedure

Píšete stored procedúru pre MySQL na spracovanie nejakých dát. Používate na to svoj obľúbený editor a túto procedúru udržiavate ako súbor na disku. Commitnete svoj výtvor do verzionovacieho nástroja a naimportujete svoju procedúru do MySQL: