MariaDB How add a user from FW

MariaDB How add a user from FW

Postby D.Fernandez » Mon Jun 28, 2021 10:55 pm

Hi,
I Need add a user from FW with read, write permission.

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: MariaDB How add a user from FW

Postby nageswaragunupudi » Tue Jun 29, 2021 2:22 am

cSql := "CREATE USER 'name'@'location' IDENTIFIED BY 'password'
oCn:Execute( cSql )
// location can be 'localhost' or a wildcard ip address or '%'. '%' indicates from all locations.

cSql := "GRANT ALL PREVILEGES ON 'dataasename.*' TO 'username'@'location'
oCn:Execute( cSql )

ON *.* indicates on all databases
@'%' indicates from all locations.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: MariaDB How add a user from FW

Postby D.Fernandez » Tue Jun 29, 2021 4:22 am

Thank you, very much Mr. Rao.

I want DATA privileges ONLY. Select , Insert , Update , Delete , File

Could you show me haw to do it?

Tank 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: MariaDB How add a user from FW

Postby nageswaragunupudi » Tue Jun 29, 2021 4:56 am

GRANT SELECT, INSERT, DELETE ON 'database' TO 'username'@'location' IDENTIFIED BY 'password'
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: MariaDB How add a user from FW

Postby D.Fernandez » Fri Jul 16, 2021 11:57 pm

Thank you very much Rao.

Best regards
Ruben 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: Google [Bot] and 52 guests