You generate new XUSER entries or change existing XUSER entries by overwriting their data. To do this, you use the following command with the option –b, and use the file <file_name> to send the data of the new entries to the XUSER program.
xuser -b <file_name>
When you create the XUSER entry with the key name HOME, no SQL mode is specified.
HOME
meyer
"Secret_password"
myDB
server1
(empty
line)
(empty line)
90
1
(empty
line)
You are free to define your own file name. Each XUSER entry in the file must contain the following data in the specified order, and must have a length of exactly 10 lines. You must include an empty line for every option that you omit. (For a description of the options, see Creating or Changing XUSER Entries.)
<user_key>
<user_name>
<password>
<database_name>
<database_server>
<SQL_mode>
(empty line)
<timeout>
<isolation_level>
(empty line)
The empty lines in the file must be left empty, since they are meant to contain other XUSER data that is not relevant for the database version 7.5.