MySQL Forums
Forum List  »  Install & Repo

Creating New User using SQL Installer Console
Posted by: Daniel Kelly
Date: November 12, 2018 05:12AM


I am trying to figure out how to create a new user during the installation phase of MySQL Installer console mode in silent mode.

I can create the new user successfully, but I am trying to set the Limit host option and the role and I can't seem to get the combination of all 3 correct.

"C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole" community install server;5.7.24;x64:*:port=3306;rootpasswd=PASSWORD:type=user;username=USERHERE;password=PASSWORD;host='%';role=DBManager;auth_plugin=mysql_native_password -silent

This seems to create the user correctly and sets the Limit hosts to '%' but not the role. So when I go to connect to the DB after installation, it fails until I go in and set the value correctly.

Can anyone assist?


Options: ReplyQuote

Written By
Creating New User using SQL Installer Console
November 12, 2018 05:12AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.