» »

Mysql error 2002

Mysql error 2002

roli ::

Že cel dan se j***** z prekletim mysqlom. Včeraj je normalno delal danes pa ne več. Preden sem ugasnil računalnik sem ga izklopil z ukazom: /etc/init.d/mysql stop


Danes pa ga hočem zagnat in problem:
/etc/init.d/mysql start
Starting service MySQL done

To je vse OK dokler se ne poizkusiš povezat nanj,da bi ustvaril bazo:
Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Že cel dan brskam po googlu in vidim na miljone teh napak in rešitev.Vendar ga nikakor ne morem pripravit do delovanja.Sistem je Suse linux 10.0 z nameščenim apache+php+mysql ( default iz CDja. Nameščen je tudi popravek za apache ).Poizkusil sem reinstall mysqla in strežnika pa ne pomaga.
Kaj storiti?
http://www.r00li.com

wind ::

Malo poglej po logih, kaj natančno se dogaja.
w

roli ::

Sem še nekaj poizkušal in dobil presenetljiv rezultat:Vedno ko zaganjam mysql ga zaženem kot root. In vedno napiše done. Če ga zaženem kot user mi javi failed. User je v skupini mysql.

Log file:
060311 13:04:36 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibPqDSY5' (Errcode: 2)
060311 13:04:36 InnoDB: Error: unable to create temporary file; errno: 2
060311 13:04:36 [ERROR] Can't init databases
060311 13:04:36 [ERROR] Aborting

060311 13:04:36 [Note] /usr/sbin/mysqld: Shutdown complete

060311 13:04:36 mysqld ended

060311 13:33:16 mysqld started
060311 13:33:16 InnoDB: Started; log sequence number 0 43634
060311 13:33:16 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060311 13:33:16 mysqld ended

060311 13:33:42 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibMuzR1H' (Errcode: 2)
060311 13:33:42 InnoDB: Error: unable to create temporary file; errno: 2
060311 13:33:42 [ERROR] Can't init databases
060311 13:33:42 [ERROR] Aborting

060311 13:33:42 [Note] /usr/sbin/mysqld: Shutdown complete

060311 13:33:42 mysqld ended

060311 13:35:58 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibdR8ufv' (Errcode: 2)
060311 13:35:58 InnoDB: Error: unable to create temporary file; errno: 2
060311 13:35:58 [ERROR] Can't init databases
060311 13:35:58 [ERROR] Aborting

060311 13:35:58 [Note] /usr/sbin/mysqld: Shutdown complete

060311 13:35:58 mysqld ended

060311 13:38:57 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibZi3CUt' (Errcode: 2)
060311 13:38:57 InnoDB: Error: unable to create temporary file; errno: 2
060311 13:38:57 [ERROR] Can't init databases
060311 13:38:57 [ERROR] Aborting

060311 13:38:57 [Note] /usr/sbin/mysqld: Shutdown complete

060311 13:38:57 mysqld ended

060311 13:45:33 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ib9p4PhS' (Errcode: 2)
060311 13:45:33 InnoDB: Error: unable to create temporary file; errno: 2
060311 13:45:33 [ERROR] Can't init databases
060311 13:45:33 [ERROR] Aborting

060311 13:45:33 [Note] /usr/sbin/mysqld: Shutdown complete

060311 13:45:33 mysqld ended

060311 14:49:47 mysqld started
060311 14:49:47 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060311 14:49:47 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060311 14:49:47 [ERROR] Aborting

060311 14:49:47 [Note] /usr/sbin/mysqld: Shutdown complete

060311 14:49:47 mysqld ended

060311 14:50:05 mysqld started
060311 14:50:05 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060311 14:50:05 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060311 14:50:05 [ERROR] Aborting

060311 14:50:05 [Note] /usr/sbin/mysqld: Shutdown complete

060311 14:50:05 mysqld ended

060311 14:50:43 mysqld started
060311 14:50:43 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060311 14:50:43 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060311 14:50:43 [ERROR] Aborting

060311 14:50:43 [Note] /usr/sbin/mysqld: Shutdown complete

060311 14:50:43 mysqld ended

060311 14:55:46 mysqld started
060311 14:55:46 InnoDB: Started; log sequence number 0 43634
060311 14:55:47 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060311 14:55:47 mysqld ended

060311 17:55:37 mysqld started
060311 17:55:37 InnoDB: Started; log sequence number 0 43634
060311 17:55:38 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060311 17:55:38 mysqld ended

Datoteka mysql.host res ne obstaja in to je verjetno problem.Kako ga rešit ( reinstall ne pomaga )?
http://www.r00li.com

Tody ::

ustvari tabelo mysql.host ?

roli ::

To sem uredil z simpl ukazom in rebootom. Sem pa po nesreči odstrail root userja:8) .In sedaj se nikakor več ne morem povezat na server.
http://www.r00li.com


Vredno ogleda ...

TemaSporočilaOglediZadnje sporočilo
TemaSporočilaOglediZadnje sporočilo
»

problem pri sprembi root gesla v MySQL v Ubuntu

Oddelek: Pomoč in nasveti
231274 (854) killa bee
»

Arhiviranje serverja s TAR - incremental in FTP na drugo lokacijo in email report - S

Oddelek: Operacijski sistemi
61561 (1472) Daedalus
»

mysql linux problem

Oddelek: Omrežja in internet
141461 (1314) Trubadur
»

mysql napaka

Oddelek: Izdelava spletišč
7771 (716) Red_Mamba
»

Mysql problem z zagonom

Oddelek: Izdelava spletišč
161184 (1046) Gandalfar

Več podobnih tem