Dotaz: odinstalovani myqsl

[stix]

zdravim, sem naprostej novacek a este moc netusim co a jak. sehnal sem si starou kraksnu na ktery se chci ucit ale mam ted problem s databazi. podle navodu na netu sem se snazil zprovoznit proftpd s administraci uzivatelu v db, jenze sem se preklikl a provedl sem dotaz: GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost' IDENTIFIED BY 'password'; GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost.localdomain' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; na db mysql misto na ftp takze mi ted mysql vubec nenabehne a ja si nevim rady :(( dyz sem dal apt-get remove mysql-client mysql-server libmysqlclient12 tak mi to vzalo sebou i phpmyadmin a este nejaky baliky, to by nebylo zase tak hrozny, jenze dyz dam znovu install tak mi to porad pise tu chybu :( vypise: /usr/bin/mysqladmin: connect to server at 'localhost' failed a dal neco at zkontroluju jestli existuje nakej socket a cestu, ale dyz tam mrknu tak je ta slozka prazdna

Odpovědi

[azurIt]

odinstaluj MySQL, kompletne vymaz adresar /var/lib/mysql/ (ak tam mas nejake data v databazi tak o ne prides!) a znovu to nainstaluj.

[stix]

tak sem to zkusil a nepomohlo to, porad to hlasi tu stejnou chybu. nekde asi musi byt jeste neco, ale netusim kde :( pro odinstalovani sem pouzil to stejny co sem psal nahore, pak sem smazal ten adresar a nainstaloval to znovu ale chyba je tam porad

[azurIt]

co pise MySQL pri starte ? pozri logy syslog a messages

[stix]

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

[azurIt]

ale toto vypise 'mysqladmin'. najdi co vypisuje mysql server pri _starte_

[azurIt]

tak ma napadlo, pri instalacii MySQL si sa dufam drzal pokynov, ktore ti dal apt-get a spustil si prikaz 'mysql_install_db'..

[stix]

tak to bude mozna ono, zadny pokyny totiz nedal, jen to nainstaloval, zkusil spustit a vypsalo to tohle. jak budu mit cas tak to vyzkousim, doufam ze uz to bude v poho. diky

[stix]

tak porad nic, jeste sem si rikal jestli mi nechybi nejaky baliky, mam nainstalovany tyto:
ii libdbd-mysql-p 2.9006-1 A Perl5 database interface to the MySQL data
ii libmysqlclient 4.0.24-10sarge mysql database client library
ii mysql-client 4.0.24-10sarge mysql database client binaries
ii mysql-common 4.0.24-10sarge mysql database common files (e.g. /etc/mysql
ii mysql-server 4.0.24-10sarge mysql database server binaries
rc php4-mysql 4.3.10-18 MySQL module for php4
rc proftpd-mysql 1.2.10-15sarge Versatile, virtual-hosting FTP daemon (with