DevHeads.net

Postings by Martijn Tonies

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

Hi there,

In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user?

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Upscene releases Database Workbench 5.4.6

Upscene releases Database Workbench 5.4.6

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.4.6 "

This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure, a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

Here's the full list of

ANN: Upscene releases Database Workbench 5.4.4

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.4 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

ANN: Stored routine debugger Hopper, version 2.0.1 released

Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2.0.1 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

Major version 2 has a fully renewed user interface, support for Firebird 3
packages, stored functions, MySQL diagnostic-statements, binary data in
variables and much more.

For more information, see <a href="http://www.upscene.com/go/?go=news&amp;id=20180627" title="http://www.upscene.com/go/?go=news&amp;id=20180627">http://www.upscene.com/go/?go=news&amp;id=20180627</a>

With regards,

Martijn Tonies

Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

ANN: Upscene releases Database Workbench 5.4.2

Upscene releases Database Workbench 5.4.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.2 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

ANN: Upscene releases Database Workbench 5.4.0

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.0 "

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

In MySQL 8.0, how does one recognize roles?

Hi,

In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users

But how does one distinguish between roles and users?

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Upscene releases Database Workbench 5.3.4

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool:

" Database Workbench 5.3.4 "

This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Ups

ANN: Stored routine debugger Hopper, version 2.0 released

Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

This version includes support for Firebird 3 packages and stored functions,
MySQL diagnostic-statements, binary data in variables and much more.

For more information, check the Hopper page on this website. <a href="http://www.upscene.com/stored_procedure_debugger/" title="http://www.upscene.com/stored_procedure_debugger/">http://www.upscene.com/stored_procedure_debugger/</a>

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase.

Upscene releases Database Workbench 5.3.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.3.2 “

This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Up

Upscene releases Database Workbench 5.3

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.3 "

This release includes a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packges and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions.

Starting MySQL takes a long long time

Hello all,

Had a normal MySQL shutdown, reboot and then this happens:

161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled.
161010 10:58:31 InnoDB: The InnoDB memory heap is disabled
161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
161010 10:58:31 InnoDB: Compressed tables use zlib 1.2.3
161010 10:58:32 InnoDB: Initializing buffer pool, size = 107.0M
161010 10:58:32 InnoDB: Completed initialization of buffer pool
161010 10:58:32 InnoDB: highest supported file format is Barracuda.
161010 10:58:39 InnoDB: Waiting for the background threads to start
161010 10:58:

ANN: Database Workbench 5.2 now includes PostgreSQL support

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.2 "

This release includes support for PostgreSQL and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions.

ANN: Upscene releases Database Workbench 5.1.12

Upscene releases Database Workbench 5.1.12

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

“ Database Workbench 5.1.12 “

This release adds a few small features and useful enhancements.

The full version 5.1.x change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12</a>

Version 5 added numerous new features and improvements to existing tools and
the new, more consistent user interface is better than ever and works fine
under Wine on Linux.

Version 5.1 includes SQL Azure and Firebird 3 support, additional data expor

Upscene releases Database Workbench 5.1.10

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

Database Workbench 5.1.10

This release adds a few small features and includes Windows Terminal Server support.

The full version 5.1.x change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12</a>

Version 5 added numerous new features and improvements to existing tools and
the new, more consistent user interface is better than ever and works fine
under Wine on Linux.

Version 5.1 includes SQL Azure and Firebird 3 support, additional data export
functionality, improve

ANN: 20% discount on Database Workbench Basic or Pro!

Dear reader,

We're offering a 20% Mid Autumn Discount on our database design
and development product "Database Workbench", available in Basic
and Pro edition.

Use coupon code MAD15 while ordering, valid until November the 9th.

You can find more information about Database Workbench here:
<a href="http://www.upscene.com/database_workbench/" title="http://www.upscene.com/database_workbench/">http://www.upscene.com/database_workbench/</a>

Thank you.

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Upscene releases Database Workbench 5.1.6

Upscene releases Database Workbench 5.1.6

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

“ Database Workbench 5.1.6 "

This version is the next big release after version 5 and includes new features,
enhancements and fixes.

The full version 5.1.x change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.1.x&amp;id=12</a>

Version 5 added numerous new features and improvements to existing tools and
the new, more consistent user interface is better than ever and works fine
under Wine on Linux.

Version 5.1 includes SQL Azure and Fi

Upscene releases Database Workbench 5.1.2

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

“ Database Workbench 5.1.2 "

This version is the next big release after version 5 and includes new features,
enhancements and fixes.

The change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.1.2&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.1.2&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.1.2&amp;id=12</a>
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.1.0&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.1.0&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.1.0&amp;id=12</a>

Version 5 added numerous new features and improvements to existing tools and
the new, more consistent user interface is better than ever and works fine
under Wine on Linux.

Version 5.1 includes SQL Azure and Firebird 3 s

Upscene releases Database Workbench 5.1.0

For immediate release:
<a href="http://www.upscene.com/news/item/20150624" title="http://www.upscene.com/news/item/20150624">http://www.upscene.com/news/item/20150624</a>

Upscene releases Database Workbench 5.1.0

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

“ Database Workbench 5.1 "

This version is the next big release after version 5 and includes new features,
enhancements and fixes.

The change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.1.0&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.1.0&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.1.0&amp;id=12</a>

Version 5 added numerous new features and improvements to existing tools and
the new, more consistent user interface is better than ever and works fine
under Wine on L

Upscene releases Database Workbench 5.0.10

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

" Database Workbench 5 "

This release fixes several issues as reported by our customers.

The change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.0.10&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.0.10&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.0.10&amp;id=12</a>

Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!

For more information, see What's new

ANN: Upscene releases Database Workbench 5.0.8

Upscene releases Database Workbench 5.0.8

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

" Database Workbench 5 "

This release fixes several issues as reported by our customers.

The change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.0.8&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.0.8&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.0.8&amp;id=12</a>

Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you

ANN: Advanced Data Generator 3.3.0 released

Dear ladies and gentlemen,

Upscene Productions is happy to announce the next release
of their Windows based flexible and easy to use test data
generator tool:

"Advanced Data Generator 3.3.0"

A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many filling options, templates and
much more.

Version 3 included many new features, eg:
* Unicode support in an all new fresh user interface
* Ability to use external databases as the source for data
* New and improved data libraries for real life like data
* New

ANN: Database Workbench 5.0.6 released

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

" Database Workbench 5 "

Version 5.0.6 fixes an issue with the MySQL module and includes some changes
for Firebird 3.

The change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.0.6&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.0.6&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.0.6&amp;id=12</a>

Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!

For more

ANN: Upscene releases Database Workbench 5.0.4

Upscene releases Database Workbench 5.0.4

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

“ Database Workbench 5 "

Version 5.0.4 introduces some small new features and a list of fixes
base on user feedback.

The change log is available here:
<a href="http://www.upscene.com/go/?go=tracker&amp;v=5.0.4&amp;id=12" title="http://www.upscene.com/go/?go=tracker&amp;v=5.0.4&amp;id=12">http://www.upscene.com/go/?go=tracker&amp;v=5.0.4&amp;id=12</a>

Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's alw

ANN: Upscene releases Database Workbench 5.0.2

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

" Database Workbench 5 "

Version 5.0.2 fixed some issues that came to light after the initial
major version 5 release.

<a href="http://www.upscene.com/news/item/20140918" title="http://www.upscene.com/news/item/20140918">http://www.upscene.com/news/item/20140918</a>

Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!

"A few bugs popped up after the initial version 5 rel

ANN: database developer tool "Database Workbench 5" now available

Upscene releases Database Workbench 5

Upscene Productions is proud to announce the availability of
the next major version of the popular multi-DBMS development tool:

" Database Workbench 5 "

There have been numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!

"There is so much new in Database Workbench 5, I don't know where to start", says Martijn Tonies,
founder of Upscene Product

ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

Ladies, gentlemen,

Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:

" Database Workbench 4.4.7 Pro "

For more information, see <a href="http://www.upscene.com/go/?go=news&amp;id=20140617" title="http://www.upscene.com/go/?go=news&amp;id=20140617">http://www.upscene.com/go/?go=news&amp;id=20140617</a>

Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )

Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Ups

ANN: Hopper - Stored Routine debugger - v1.5.1 released

Dear ladies and gentlemen,

Upscene Productions is proud to announce version 1.5.1 of our
product called "Hopper".

Hopper is a Windows-based Stored Routine and Trigger Debugger,
available for InterBase, Firebird and MySQL.

For more information, see <a href="http://www.upscene.com/go/?go=hopper" title="http://www.upscene.com/go/?go=hopper">http://www.upscene.com/go/?go=hopper</a>

This release contains new features and bugfixes, see
<a href="http://www.upscene.com/go/?go=news&amp;id=20140616" title="http://www.upscene.com/go/?go=news&amp;id=20140616">http://www.upscene.com/go/?go=news&amp;id=20140616</a>
for more information.

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Three days left on the 75% FIFA World Cup Discount!

Dear reader,

There’s 3 days left on our FIFA World Cup special:

75% discount on all our database development products!

<a href="http://www.upscene.com/" title="http://www.upscene.com/">http://www.upscene.com/</a>

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

ANN: 75% special FIFA World Cup 2014 discount on all our products

Hello everyone,

We’re currently offering a 75% discount on all our (Windows based) products!

This includes test data generator, development and debugging tools, feel free
to take a look at <a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Thank you for your attention.

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>