SQL Playground Doc Update - don't recommend root

[knz]

Raphael 'kena' Poss (knz) commented:

Re: SQL Playground

Issue Description

The playground uses a regular cluster but then uses the root user to log in. This is not best practice (#1342 )

Suggested Resolution

Use cockroach demo or pre-create a non-root user (possibly with admin role) for the playground session.

Jira Issue: DOC-959

[jseldess]

I would like to use demo, but then I wouldn't be able to embed the DB Console. You can't control the listening addresses with demo. It has to be localhost. The DB Console won't open with that, unfortunately.

Given that, what should I do? Create an additional client cert, use root to create a SQL user with admin privileges (to access DB Console and be unrestricted with data access), and then start the sql shell with that user?

[knz]

Create an additional client cert, use root to create a SQL user with admin privileges (to access DB Console and be unrestricted with data access), and then start the sql shell with that user?

That sounds about OK?

I would also like to know what katakoda recommends for TLS config for applications that start a web application. Do they provide TLS certs we can use? That would be great for the DB console experience. (I wouldn't believe we'd be the first users to ask.)