Błąd przy uruchamianiu serwera MySql

[Pjo 0]

Witam.

Mam problem z uruchomieniem MySql-a.

 

root@ks3099399:~# service mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

 

W logach mysql-a nic się nie pokazuje, lecz w syslogu jest:

 

Aug 20 13:44:07 ks3099399 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 20 13:44:07 ks3099399 mysqld: 120820 13:44:07 [Note] Plugin 'FEDERATED' is disabled.
Aug 20 13:44:07 ks3099399 mysqld: 120820 13:44:07  InnoDB: Initializing buffer pool, size = 8.0M
Aug 20 13:44:07 ks3099399 mysqld: 120820 13:44:07  InnoDB: Completed initialization of buffer pool
Aug 20 13:44:07 ks3099399 mysqld: 120820 13:44:07  InnoDB: Operating system error number 13 in a file operation.
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: The error means mysqld does not have the access rights to
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: the directory.
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: File name ./ibdata1
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: File operation call: 'open'.
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: Cannot continue operation.
Aug 20 13:44:07 ks3099399 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 20 13:44:21 ks3099399 /etc/init.d/mysql[5134]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 20 13:44:21 ks3099399 /etc/init.d/mysql[5134]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 20 13:44:21 ks3099399 /etc/init.d/mysql[5134]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 20 13:44:21 ks3099399 /etc/init.d/mysql[5134]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 20 13:44:21 ks3099399 /etc/init.d/mysql[5134]:
Aug 20 13:45:01 ks3099399 /USR/SBIN/CRON[5426]: (root) CMD (/usr/local/rtm/bin/rtm 14 > /dev/null 2> /dev/null)
Aug 20 13:45:09 ks3099399 named[8139]: error (network unreachable) resolving '69.168.127.164.in-addr.arpa/PTR/IN': 2001:470:1a::2#53
Aug 20 13:46:01 ks3099399 /USR/SBIN/CRON[5927]: (root) CMD (/usr/local/rtm/bin/rtm 14 > /dev/null 2> /dev/null)

 

 

 

Nie wiem co robić. Przeszukałem wiele for i nic. I jeszcze jedno - nic nie zmieniałem w configu mysql-u od instalacji serwera.

[xorg 693]

Aug 20 13:44:07 ks3099399 mysqld: InnoDB: The error means mysqld does not have the access rights to
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: the directory.
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: File name ./ibdata1
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: File operation call: 'open'.
Aug 20 13:44:07 ks3099399 mysqld: InnoDB: Cannot continue operation.

[Pjo 0]

Ustawiłem chmod na 666 - nic, 777 - nadal nie działa i ten sam error...

[Gość patrys]

Ustaw poprawne uprawnienia czyli odczyt/zapis dla usera i usera na tego z którym uruchamiany jest serwer.

[Pjo 0]

Dałem chmod 777 całemu folderowi mysql-a i teraz jest błąd przy stopie.

 

root@ks3099399:~# service mysql restart
Stopping MySQL database server: mysqld failed!

 

 

I logi:

 

Aug 20 14:39:43 ks3099399 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 20 14:39:43 ks3099399 mysqld: 120820 14:39:43 [Note] Plugin 'FEDERATED' is disabled.
Aug 20 14:39:43 ks3099399 mysqld: 120820 14:39:43  InnoDB: Initializing buffer pool, size = 8.0M
Aug 20 14:39:43 ks3099399 mysqld: 120820 14:39:43  InnoDB: Completed initialization of buffer pool
Aug 20 14:39:43 ks3099399 mysqld: 120820 14:39:43  InnoDB: Started; log sequence number 0 44233
Aug 20 14:39:43 ks3099399 mysqld: 120820 14:39:43 [Note] Event Scheduler: Loaded 0 events
Aug 20 14:39:43 ks3099399 mysqld: 120820 14:39:43 [Note] /usr/sbin/mysqld: ready for connections.
Aug 20 14:39:43 ks3099399 mysqld: Version: '5.1.63-0+squeeze1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2808]: Upgrading MySQL tables if necessary.
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2811]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2811]: Looking for 'mysql' as: /usr/bin/mysql
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2811]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2811]: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock'
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2811]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2811]: FATAL ERROR: Upgrade failed
Aug 20 14:39:44 ks3099399 /etc/mysql/debian-start[2821]: Checking for insecure root accounts.

Edytowano Sierpień 20, 2012 przez Pjo (zobacz historię edycji)

[Pjo 0]

Reinstalowałem mysql-a i nadal to samo. Może ma ktoś jakiś pomysł?

[Pjo 0]

Pomoże ktoś? Bazy stoją od 3 godzin, i trace ludzi...

[tym 205]

Ustaw poprawne chmody, czyli 700 + chown -R mysql.mysql /var/lib/mysql.

Reinstalacja opierała się na apt-get remove? Apt-get nie usuwa katalogów w których są dane, więc generalnie nic się z /var/lib/mysql nie zmieniło.

[Pjo 0]

Dobra, dałem chmod 700, wpisałem chown -R mysql.mysql /var/lib/mysql i nadal nie działa... Ma ktoś jakiś pomysł co jeszcze może być?

[Pjo 0]

Pomoże ktoś?