FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour adduser mysql how?
Posts: 555
Joined: Wed Jul 31, 2013 01:14 PM
adduser mysql how?
Posted: Tue Jun 28, 2022 11:30 PM

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

Dario Fernandez

FWH 2501, Harbour, MVS2022 Community, MySql & MariaDB, Dbf/Cdx VSCode.

Maldonado - Uruguay
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: adduser mysql how?
Posted: Wed Jun 29, 2022 02:01 PM
Code (fw): Select all Collapse
   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
Regards



G. N. Rao.

Hyderabad, India
Posts: 555
Joined: Wed Jul 31, 2013 01:14 PM
Re: adduser mysql how?
Posted: Thu Jun 30, 2022 04:43 AM

Mr. Rao thank you very much.

Best regards

Dario Fernandez

Dario Fernandez

FWH 2501, Harbour, MVS2022 Community, MySql & MariaDB, Dbf/Cdx VSCode.

Maldonado - Uruguay

Continue the discussion