Hozzászólások
-
Bejegyzés
-
Megoldódott a gondom egy kedves kollegám segitett benne:
Leírom neketek,h hogyan is sikerult és hátha segit ez másnak is:
Töröld ki a MySQL könyvtárat:
/var/lib/mysql/mysql -t
futtasd: mysql_install_db
futtasd: /etc/init.d/mysql start
/var/run/mysqld/mysqld.sock’ van ilyen file?Akkor:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h thotyl-lapitopi password ‘new-password’mysql -u root -p jelszavad
DELETE FROM mysql.user WHERE User = ”;
FLUSH PRIVILEGES;
q
mysql -u root -p
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpwd’);
SET PASSWORD FOR ‘root’@’host_name’ = PASSWORD(‘newpwd’);
qsyslogba ez került a restart után:
Aug 1 17:34:11 thotyl-lapitopi mysqld_safe[18690]: started
Aug 1 17:34:13 thotyl-lapitopi mysqld[18693]: 060801 17:34:13 InnoDB: Started; log sequence number 0 43655
Aug 1 17:34:14 thotyl-lapitopi mysqld[18693]: 060801 17:34:13 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
Aug 1 17:34:14 thotyl-lapitopi mysqld[18693]: 060801 17:34:13 [Note] Starting crash recovery…
Aug 1 17:34:14 thotyl-lapitopi mysqld[18693]: 060801 17:34:13 [Note] Crash recovery finished.
Aug 1 17:34:14 thotyl-lapitopi mysqld[18693]: 060801 17:34:14 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
Aug 1 17:34:14 thotyl-lapitopi mysqld_safe[18724]: ended
Aug 1 17:34:26 thotyl-lapitopi /etc/init.d/mysql[18845]: 0 processes alive and ‘/usr/bin/mysqladmin –defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Aug 1 17:34:26 thotyl-lapitopi /etc/init.d/mysql[18845]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Aug 1 17:34:26 thotyl-lapitopi /etc/init.d/mysql[18845]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
Aug 1 17:34:26 thotyl-lapitopi /etc/init.d/mysql[18845]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Aug 1 17:34:26 thotyl-lapitopi /etc/init.d/mysql[18845]:
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): starting (version 2.14.0), pid 18864 user ‘root’
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/etc/gconf/gconf.xml.mandatory” to a read-only configuration source at position 0
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readwrite:/root/.gconf” to a writable configuration source at position 1
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/etc/gconf/gconf.xml.defaults” to a read-only configuration source at position 2
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/var/lib/gconf/debian.defaults” to a read-only configuration source at position 3
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/var/lib/gconf/defaults” to a read-only configuration source at position 4a messagesbe pedig ez:
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): starting (version 2.14.0), pid 18864 user ‘root’
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/etc/gconf/gconf.xml.mandatory” to a read-only configuration source at position 0
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readwrite:/root/.gconf” to a writable configuration source at position 1
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/etc/gconf/gconf.xml.defaults” to a read-only configuration source at position 2
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/var/lib/gconf/debian.defaults” to a read-only configuration source at position 3
Aug 1 17:34:55 thotyl-lapitopi gconfd (root-18864): Resolved address „xml:readonly:/var/lib/gconf/defaults” to a read-only configuration source at position 4Ebõl sem tudok rájönnis sajna.
Valaki segitsen pls!
Ubuntut használok és a telepités sztem kiválló ha lehet ennek hinni. Telepitési folyamatot a synaptic-al vittem végbe.
mysql restart:
thotyl@thotyl-lapitopi:~$ sudo /etc/init.d/mysql restart
Password:
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
.
.
.
…failed or took more than 6s.
Please take a look at the syslog.
/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!Itt: /var/log/mysqld.log nem találok ilyen fájlt a /var/log/mysql ben pedig semmi ovashato sincs csak mysql-bin.000001-tol 30ig fájlok
Egyébként akkor jelentkezett ez a hiba amikor a torrentfluxot akartam feltenni es az is hibákat generált és többen mondták,h a hiba javitása megvalósitható ugy,h a /etc/php4/apache2
/php.ini fájlban a ;extension=mysql.so elõl kiveszem a kommentet azaz a ; jelet.Ezzel jo is volt mert elorebb jutottam a torrentfluxal de a hiba amit az dobott megmaradt es jott pluszba még 1.
A hábák:
1.: Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /var/www/torrentflux_2.1/html/adodb/drivers/adodb-mysql.inc.php on line 355
2.:Database error: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
Always check your database variables in the config.php file.
Sziasztok
A phpmyadminom tegnap óta ezzel traktál:
#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)
#2002 – A szerver nem válaszol (vagy a helyi MySQL szerver socketje nincs rendesen beállítva)Nem tudok rájonni mi lehet a gondja. Segitsetek kerlek!
legutóbbi hsz