topic-41919

Board index FiveWin for Harbour/xHarbour adduser mysql how?

D.Fernandez

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

nageswaragunupudi

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

D.Fernandez

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

FiveTech Support Forums

Continue the discussion