Creating a New User
On this page
The following steps describe how to create a new user that will be authenticated using SAML 2.
Connect to the master aggregator node as a user that has CREATE USER permissions.
Replace the fictional values and execute the following statement to create a new user:
CREATE USER `johndoe`@`localhost` IDENTIFIED WITH authentication_saml;
The important part of this statement is the
authentication_ identification type.
Once a user has been created and identified with the SAML 2.
Connect to an aggregator node by replacing fictional values and executing the following statement:
mysql --host=localhost --port=3306 --user=johndoe --password=PHNhbWxwOlJlc3B...25zZT4= --enable-cleartext-plugin
The most important observation about this connection statement is the value of the
In addition to the Base64-encoded password, there are two other important details about this connection statement:
--enable-cleartext-pluginflag ensures that the user’s password is passed to the internal SAML 2.
0 authentication module in clear text. This flag is required.
More than one SingleStoreDB node may be hosted at any given address, so the correct port must be specified.
In this example, port 3306 is specified because it’s the default port for master aggregator nodes.
Last modified: April 26, 2023