Semoss13 Posted January 18, 2006 Report Share Posted January 18, 2006 ekš mysql ir vairakas datu bazes. it kaaa ar lietotaaju root piesleegties varu, bet liidz ko gribu ar to datu baazi kaut ko pasaakt, pimeram pievienot jaunu tabulu, taa sanjemu "access denied". Kas varetu buut par probleemu? Link to comment Share on other sites More sharing options...
Delfins Posted January 18, 2006 Report Share Posted January 18, 2006 Lietotājam root nav tiesības uz to datubāzi (alter/drop tiesības) Link to comment Share on other sites More sharing options...
Semoss13 Posted January 18, 2006 Author Report Share Posted January 18, 2006 Lietotājam root nav tiesības uz to datubāzi (alter/drop tiesības) Un kaa shiis tiesiibas pieshkirt? Link to comment Share on other sites More sharing options...
bubu Posted January 18, 2006 Report Share Posted January 18, 2006 MySQL komanda GRANT Link to comment Share on other sites More sharing options...
Grey_Wolf Posted January 19, 2006 Report Share Posted January 19, 2006 bubu --> GRANT tiesiibas var pieskjirt tikai lietotaajs kuram jau ir shaadas tiesiibas.. parasti root taas ir defaultaa... vieniigi shoreiz vareetu buut ka nesleedzs klaat no localhost... un taadeelj aareejiem linkiem vinjas ir apgriestas.... ---- respektiivi tiesiibas var nodod taalaak tikai GRANT un tikai taadas kaa ir pasham.... un tikai uz taam DB uz kuraam shiis tiesiibas attiecas..... -------- Link to comment Share on other sites More sharing options...
bubu Posted January 19, 2006 Report Share Posted January 19, 2006 Tu domā es to nezinu? Es tikai atbildēju uz jautājumu - kā piešķir tiesības. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted January 19, 2006 Report Share Posted January 19, 2006 bubu --> njaa.. vispaar es tikai piebildu pie tava teiktaa ;) Link to comment Share on other sites More sharing options...
Semoss13 Posted January 20, 2006 Author Report Share Posted January 20, 2006 Jaa, bet mana probleema nav pakusteejusies ne pa mm uz priekshu. Kas varetu buut pa desaam, ka root@localhost nav tiesiibu uz konkreetu datu baazi? Link to comment Share on other sites More sharing options...
Grey_Wolf Posted January 20, 2006 Report Share Posted January 20, 2006 (edited) Semoss13-->vai tad seit visi gaisregji? apskaties kaadas privelegijas staav root? Vai ir GRANT tiesiibas? varbuut visas privileegijas ir citam userim nevis root? (dazreiz izveido arii taa - root no locaalhost atstaaj tikai tiesiibas uz pashu serveri (SHUTDOWN utt...) ) Vai pats administree to SQL? Edited January 20, 2006 by Grey_Wolf Link to comment Share on other sites More sharing options...
Recommended Posts