adduser mysql how?

[D.Fernandez]

Hi fivewiners,

I wish to know haw add a user from FWH MySql
I can't find the wiki.

Thank you, very much

Regards

Dario Fernandez

[nageswaragunupudi]

Code: Select all  Expand view  RUN

  cSql  := "CREATE USER newuser@'%' IDENTIFIED BY 'password'"
   oCn:Execute( cSql )

   cSql  := "GRANT ALL PREVILEGES ON 'database.*' TO newuser@'%' IDENTIFIED BY 'password'"
   oCn:Execute( cSql )
 

Also see
https://dev.mysql.com/doc/refman/8.0/en ... -user.html
for full syntax

[D.Fernandez]

Mr. Rao thank you very much.

Best regards

Dario Fernandez