problem sql server

[ sashko_ @ 11.08.2005. 13:54 ] @

Kako da pokrenem mysql kada otkucam mysql u konzoli dobijem poruku:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
kada pokrenem kdevelop da bi pisao neki sql kod dobijem poruku Please select a valid database connection.
kako ovo da resim??

[ vbraca @ 11.08.2005. 14:22 ] @

Koja Linux distribucija i koja verzija MySQL-a ?

[ sashko_ @ 11.08.2005. 20:01 ] @

slackware 10 distribucija a mysql mysql-4.0.20-i486-1 pa onda instaliran mysql-4.1.7-i486-1jim

[ vbraca @ 12.08.2005. 07:26 ] @

Elem, može biti biše razloga:
1) Jesi li se u potpunosti pridržavao instalacione procedure iz MySQL readme fajla ?
2) da li je pokrenut MySQL deamon (mysqld_safe) recimo pri podizanju sistema ili ručno

Code:
ja@localhost:>/usr/bin/mysqld_safe -h localhost -u root -p
ili
ja@localhost:>/usr/bin/safe_mysqld -h localhost -u root -p

za početak toliko, ako te ne mrzi pretraži Yahoo ili Google sa

Code:
Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

[ sashko_ @ 12.08.2005. 11:27 ] @

evo sta dobijem
root@abit:/# /usr/bin/mysqld_safe -h localhost -u root -p
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/abit.pid
050812 12:15:47 mysqld ended

[ caiser @ 12.08.2005. 12:34 ] @

Citat:

vbraca:

Code:
ja@localhost:>/usr/bin/mysqld_safe -h localhost -u root -p
ili
ja@localhost:>/usr/bin/safe_mysqld -h localhost -u root -p

???

Zar ne bi trebalo:

Code:
ja@localhost:>/usr/bin/mysqld_safe --user=mysql &

[ sashko_ @ 12.08.2005. 13:16 ] @

nece ni to:
/usr/bin/mysqld_safe --user=mysql &
dobijem
root@abit:/# /usr/bin/mysqld_safe --user=mysql &
[1] 2013
root@abit:/# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/abit.pid
050812 14:19:04 mysqld ended

[1]+ Done /usr/bin/mysqld_safe --user=mysql

[ vbraca @ 12.08.2005. 14:44 ] @

@Caiser >> da u pravu si posto je ovde deamon u pitanju

@sashko_ >> otkud sad taj abit.pid ?

Proveri jos jednom da li si MySQL instalirao po uputstvu - kreirao mysql korisnika/grupu, napravio.konvertovao mysql osnovne tabele, nadji my.cnf fajl pa vidi sta pise u njemu ...

I naravno probaj Yahoo! ili Google

[ sashko_ @ 12.08.2005. 14:49 ] @

ej sad kad kucam: to se nalazi u scripto rc.mysqld
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid $SKI
on radi ali samo u user a u root ne
u cemu je problem

[ misk0 @ 17.08.2005. 23:35 ] @

Citat:

STOPPING server from pid file /var/lib/mysql/abit.pid

a da pogledas sta pishe u tom fajlu?? Tj fajlu koji ima extenziju .err i nalazi se u istom direktoriju. Obicno pishe sta ne valja ...