adduser mysql how?

adduser mysql how?

Postby D.Fernandez » 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 24.09, Harbour, MVS2022 Community, BCC, MySql & MariaDB, Dbf/Cdx VSCode.
Maldonado - Uruguay
D.Fernandez
 
Posts: 462
Joined: Wed Jul 31, 2013 1:14 pm
Location: Maldonado - Uruguay

Re: adduser mysql how?

Postby nageswaragunupudi » Wed Jun 29, 2022 2:01 pm

Code: Select all  Expand view
  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
User avatar
nageswaragunupudi
 
Posts: 10619
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: adduser mysql how?

Postby D.Fernandez » Thu Jun 30, 2022 4:43 am

Mr. Rao thank you very much.

Best regards

Dario Fernandez
Dario Fernandez
FWH 24.09, Harbour, MVS2022 Community, BCC, MySql & MariaDB, Dbf/Cdx VSCode.
Maldonado - Uruguay
D.Fernandez
 
Posts: 462
Joined: Wed Jul 31, 2013 1:14 pm
Location: Maldonado - Uruguay


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 58 guests