saimon_k Posted January 17, 2005 Report Share Posted January 17, 2005 (edited) Mocības turpinās. Esmu iebietējis kā ar phpMyAdmin uztaisiit teiblu un ievadiit tajaa kaut kaadus datus. Tagadinjaas gribēju notestēt, bet nesanāk piekonektēties DB, kas staav uz hosta netaa. Gribeeju uzvaicaat peec reaala piemeera datu baazes konekcijai netaa (nevis kaarteejais localhost un root). Datu baazes nosaukums ir 'test'. Tabulas nosaukums ir 'table' Vēl ir zināms username un passw, ko jaaievada, lai ielogotos phpMyAdmin. Kods $db = mysql_pconnect('domain.lv', 'login', 'passw'); Atgriež: Warning: mysql_pconnect(): Access denied for user: 'domain@ns.datateks.lv' (Using password: YES) in /home/virtual/site80/fst/var/www/html/blabla/blabla/db_conn01.php on line 9 Edited January 17, 2005 by saimon_k Link to comment Share on other sites More sharing options...
bubu Posted January 17, 2005 Report Share Posted January 17, 2005 Access denied = nav tiesību. Link to comment Share on other sites More sharing options...
saimon_k Posted January 17, 2005 Author Report Share Posted January 17, 2005 (edited) Access denied = nav tiesību. 12835[/snapback] Tas noziimee to, ka man ir jaaizveido kaut kadi juuzeri ar paroleem, kuriem ir noteiktas privileegijas? Edited January 17, 2005 by saimon_k Link to comment Share on other sites More sharing options...
PheliX Posted January 17, 2005 Report Share Posted January 17, 2005 Access denied = nav tiesību. 12835[/snapback] Tas noziimee to, ka man ir jaaizveido kaut kadi juuzeri ar paroleem, kuriem ir noteiktas privileegijas? 12839[/snapback] nu bet logjiski :) Link to comment Share on other sites More sharing options...
saimon_k Posted January 17, 2005 Author Report Share Posted January 17, 2005 (edited) damn, visu dienu bakstu visaadus tutoriaaljus un manuaaljus, bet nekaadi nesanaak izveidot jaunu juuzeri ar kaut kaadaam noteiktaam priritaateem, visu laiku man izmet 'You have an error in your SQL syntax near 'tere-pere' at line 1. Saak jau besiit uz vakara pusi. Mosh kaadam te veel ir phpMyAdmin un jamais var uzmest kveriju, ar kura paliidziibu var radiit jaunu juuzeri? UPD: Izmeeginaaju ielogoties bez passw un errora mesaages vairs nebija. Ko tas noziimee? Edited January 17, 2005 by saimon_k Link to comment Share on other sites More sharing options...
Venom Posted January 18, 2005 Report Share Posted January 18, 2005 GRANT Select, Insert, Update, Delete, Index, Alter, Create, Drop, References ON db.* TO 'login'@'% vai IP' IDENTIFIED BY 'password' cik saprotu, tas ir serveris.lv? tur laikam pats sev nemaz nevarēsi pielikt ūseri (pašam nav GRANT tiesību) no citurienes nevar pieslēgties, jo tiesības slēgties tikai no localhost Link to comment Share on other sites More sharing options...
saimon_k Posted January 18, 2005 Author Report Share Posted January 18, 2005 GRANT Select, Insert, Update, Delete, Index, Alter, Create, Drop, References ON db.* TO 'login'@'% vai IP' IDENTIFIED BY 'password' cik saprotu, tas ir serveris.lv? tur laikam pats sev nemaz nevarēsi pielikt ūseri (pašam nav GRANT tiesību) no citurienes nevar pieslēgties, jo tiesības slēgties tikai no localhost 12848[/snapback] tas maina lietas buutiibu. Link to comment Share on other sites More sharing options...
Recommended Posts