Hallo zusammen,
ich hatte testweise meine IP Adressen auf dem Server geändert, anschliessend wieder auf die Ursprungsadresse zurückgestellt.
Seitdem läuft mysql nicht mehr.
VDR:/var/run/mysqld# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
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!
die Datei mysqld.sock existiert tatsächlich nicht.
Warum kann ers ich nicht mit localhost verbinden?
aus dem Syslog:
Jun 19 15:42:35 VDR /etc/init.d/mysql[7118]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 19 15:42:35 VDR /etc/init.d/mysql[7118]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jun 19 15:42:35 VDR /etc/init.d/mysql[7118]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jun 19 15:42:35 VDR /etc/init.d/mysql[7118]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jun 19 15:42:35 VDR /etc/init.d/mysql[7118]:
Jun 19 15:42:37 VDR mysqld_safe[7194]: started
Jun 19 15:42:37 VDR mysqld[7198]: ^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ibWGMbdF' (Errcode: 13)
Jun 19 15:42:37 VDR mysqld[7198]: 060619 15:42:37 InnoDB: Error: unable to create temporary file; errno: 13
Jun 19 15:42:37 VDR mysqld[7198]: 060619 15:42:37 Can't init databases
Jun 19 15:42:37 VDR mysqld[7198]: 060619 15:42:37 Aborting
Jun 19 15:42:37 VDR mysqld[7198]:
Jun 19 15:42:37 VDR mysqld[7198]: 060619 15:42:37 InnoDB: Warning: shutting down a not properly started
Jun 19 15:42:37 VDR mysqld[7198]: InnoDB: or created database!
Jun 19 15:42:37 VDR mysqld[7198]: 060619 15:42:37 /usr/sbin/mysqld: Shutdown Complete
Jun 19 15:42:37 VDR mysqld[7198]:
Jun 19 15:42:37 VDR mysqld_safe[7200]: ended
Jun 19 15:42:43 VDR /etc/init.d/mysql[7288]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 19 15:42:43 VDR /etc/init.d/mysql[7288]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jun 19 15:42:43 VDR /etc/init.d/mysql[7288]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jun 19 15:42:43 VDR /etc/init.d/mysql[7288]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jun 19 15:42:43 VDR /etc/init.d/mysql[7288]:
Hat jemand einen Rat?
Gruss
ZEN
ct5.0, mit DVB-T in HH