Erdogans Klucis Posted January 11, 2006 Report Share Posted January 11, 2006 ja man majlapa un datubāze atrodas uz viena un tā paša servera, kādam userim jābūt definētam lai lapa konektētos pie datubāzes? Vai tipa username@xxx.xxx.xx.xx kur xxxxxx ir servera IP? Jeb vai username@% ? Kā lai es pasaku, ka tam userim atļauta pieeja tikai no vienas IP adreses? Link to comment Share on other sites More sharing options...
[Ya] Posted January 11, 2006 Report Share Posted January 11, 2006 ja tu doma mysql tad atļauj tikai localhost, un nogriez Mysqlam pieeju no āras Link to comment Share on other sites More sharing options...
Erdogans Klucis Posted January 11, 2006 Author Report Share Posted January 11, 2006 lai pats tabulām klāt tiktu, vēl tak otru useri arī vajag, ja? būtu pateicīgs, ja kāds uzrakstītu tās privilēģijas, ar kurām pietiek pirmajam un otrajam userim. pirmajam es tā saprotu ka vairāk par SELECT, INSERT, UPDATE, DELETE (uz konkrēto datubāzi) nevjag. Kādas minimāli vajag otram? man backupi arī jātaisa Link to comment Share on other sites More sharing options...
Grey_Wolf Posted January 11, 2006 Report Share Posted January 11, 2006 (edited) username@% --> noziimee ka dotais useris var piekljuut jeb no kurienes... pilniigi briiva pieeja, Ljoti nedroshs risinaajums tavaa gadijumaa username@localhost edit: lai backupotu/atjaunotu (tikai irakstus, nevis struktuuru) FILE ---- papildus noderees. CREATE ALTER ------ Edited January 11, 2006 by Grey_Wolf Link to comment Share on other sites More sharing options...
Erdogans Klucis Posted January 11, 2006 Author Report Share Posted January 11, 2006 paldies Link to comment Share on other sites More sharing options...
Recommended Posts