topic-38473

Board index FiveWin para Harbour/xHarbour MariaDB - AddUser

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

MariaDB - AddUser
Posted: Tue Feb 11, 2020 01:47 PM

Buenos dias
Con TDolphin tengo esta función :AddUser( "%", AllTrim(cUser), AllTrim(cPswUser), shIni["MARIADB"]["database"],, "CREATE,INSERT,UPDATE,DELETE,SELECT,CREATE VIEW,SHOW VIEW" )

Cual es su equivalente con FWNativo

gracias

Resistencia - "Ciudad de las Esculturas"

Chaco - Argentina

FranciscoA

Posts: 2170

Joined: Fri Jul 18, 2008 01:24 AM

Re: MariaDB - AddUser
Posted: Tue Feb 11, 2020 10:23 PM

Hola Mario.
En MySql lo hago asi:

Code (fw): Select all Collapse

oServer:Query("CREATE USER 'Roberto'@'localhost' IDENTIFIED BY 'rober'")
oServer:Query("GRANT ALL PRIVILEGES ON * . * TO 'Roberto'@'localhost'")
oServer:Query("FLUSH PRIVILEGES")

Francisco J. Alegría P.

Chinandega, Nicaragua.

Fwxh-MySql-TMySql

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: MariaDB - AddUser
Posted: Wed Feb 12, 2020 10:41 AM

Buenos dias Francisco
Muchisimas gracias!

Resistencia - "Ciudad de las Esculturas"

Chaco - Argentina

FiveTech Support Forums

Continue the discussion