Problemcic sa MySQL

Problemcic sa MySQL

offline
  • Pridružio: 16 Okt 2003
  • Poruke: 207
  • Gde živiš: Beograd

Ovih dana sam reinstalirao svo FreeBSD sistem i sada imam manjih problem sa MySQL bazom podataka. Naime, sve se lepo instalira kao i oduvek, ali kada pokusam da pokrenem server dobijam sledecu poruku:

050316 23:53:52 mysqld started
050316 23:53:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050316 23:53:52 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050316 23:53:52 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
050316 23:53:53 InnoDB: Flushing modified pages from the buffer pool...
050316 23:53:53 InnoDB: Started; log sequence number 0 43634
050316 23:53:53 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050316 23:53:53 mysqld ended

Nesto se ne secam da sma ikad do sad ista posebno podesava za MySQL na FreeBSd da bi sve radilo. Da li neko zna u cemu bi mogao da bude problem? Ovo se odnosi i na 4.1.10 i 5.0.2 MySQL servere.



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.
offline
  • Peca  Male
  • Glavni Administrator
  • Predrag Damnjanović
  • SysAdmin i programer
  • Pridružio: 17 Apr 2003
  • Poruke: 23211
  • Gde živiš: Niš

chmod-uj direktorijum gde su mysql tabele tako da i others imaju rw privilegije
tako sam ja resio problem...
mozda ima neko elegantnije resenje, mozda chown, pa da direktorijum dodelis mysql user-u



offline
  • Pridružio: 16 Okt 2003
  • Poruke: 207
  • Gde živiš: Beograd

Ne znam kako niti zasto, ali sam iz cistog ocaja danas obrisao MySQL po ko zna koji put i ponovo instalirao preko portova MySQL 5.x...i sad sve radi..Smile

Ko je trenutno na forumu
 

Ukupno su 1237 korisnika na forumu :: 135 registrovanih, 9 sakrivenih i 1093 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 3466 - dana 01 Jun 2021 17:07

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: 8u47, A.R.Chafee.Jr., Aleksej, AleksSE, ALEXV, amonsrb, Andy, armor, Asteker, Avalon015, Baba_Yagi_Antena, bbelic, bestguarder, bokisha253, bolimejoli, boromir, BOXRR, bpop, bpvl, branko87, brkan1, brundo65, Bubimir, bukefal, Car89, ccoogg123, Cicumile, cojapop, dak2, DalmatinacMF, darionis, darkangel, Dimitrise93, Djota1, Dovla 1980, Draganeli, Dzigy, EXIT78, g_g, gasha, Glavni Oružni, gomago, GveX, HrcAk47, Insan, ivan979, jalos, Japidson, Jozo74, Kanader, kikisp, kokodakalo, Kole1975, koliko, koom0001, kovac9mm, Kubovac, Kuroje, larix, Lester Freamon, littlebunny, ljuba, lord sir giga, luka1978, Macalone, mane123, MarkoD, Martin543, maxim_von_burdengate, metallac777, Metanoja, MiGac, Miki01, Milan Miscevic, milanovic, milanpb, milbos, milenko crazy north, MILJEVINAC, mm1811, moldway, N.e.m.a.nj.a., nelezele, Nemanja Opalić, nemkea71, niksa517, NMNJ, Nmr, Nobunaga, omen, OtacMakarije, Pale2025, Panter, Panzer88, pfc74, PlayerOne, Prašinar, Prečanin30, probisic, proka89, Pururin, radionica1, raf87, Raso75, Ratnik84, rokokoko, rovac, S94, samo opusteno, sap, sasakrajina, Sava89, savuni, Shinobi, silikon, Sir Budimir, sixpac, Str2022, Tas011, Topaz9, Troja, TRZH92, tuja, UAV operator, Username1000, Velički, vensla, virked, VJ, voja64, YugoSlav, zokizemun, Zorge, šumar bk2, Čivi