[+] Baza MySQL nie chce si

mpm1122 · Post autor: **mpm1122** » 04 sierpnia 2013, 11:58

Witam.
Przy próbie instalacji bazy danych MySQL (po wpisaniu haseł) dostaję taką informację:

[ ok ] Stopping MySQL database server: mysqld.130804 11:45:29 [Note] Plugin 'FEDERATED' is disabled.
130804 11:45:29 InnoDB: The InnoDB memory heap is disabled
130804 11:45:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130804 11:45:29 InnoDB: Compressed tables use zlib 1.2.7
130804 11:45:29 InnoDB: Using Linux native AIO
130804 11:45:29  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
130804 11:45:32  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
130804 11:45:32 InnoDB: Fatal error: cannot initialize AIO sub-system
130804 11:45:32 [ERROR] Plugin 'InnoDB' init function returned error.
130804 11:45:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130804 11:45:32 [ERROR] Unknown/unsupported storage engine: InnoDB
130804 11:45:32 [ERROR] Aborting
130804 11:45:32 [Note] /usr/sbin/mysqld: Shutdown complete

A kilkanaście sekund później taką:

Kod: Zaznacz cały

 Unable to set password for the MySQL "root" user                                                                                                                                                   An error occurred while setting the password for the MySQL administrative user. This may have happened because the account already has a password, or because of a communication problem with the MySQL server.                                                                                                                       You should check the account's password after the package installation.                                                                                              
Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for more information.

Próbowałem takowych rozwiązań:

Kod: Zaznacz cały
```
apt-get -f install
```

Kod: Zaznacz cały

mysql_secure_installation (ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2))

Kod: Zaznacz cały
```
innodb_use_native_aio=0 w my.cnf
```

Lista repozytoriów:

Kod: Zaznacz cały

deb [URL]http://ftp.de.debian.org/debian/[/URL] wheezy main contrib non-free
deb-src [URL]http://ftp.de.debian.org/debian/[/URL] wheezy main contrib non-free


deb [URL]http://security.debian.org/[/URL] wheezy/updates main contrib non-free
deb-src [URL]http://security.debian.org/[/URL] wheezy/updates main contrib non-free


deb [URL]http://ftp.de.debian.org/debian/[/URL] wheezy-updates main contrib non-free
deb-src [URL]http://ftp.de.debian.org/debian/[/URL] wheezy-updates main contrib non-free

System na VPS-ie to Debian 7, zainstalowany na openvz. Zakupiony w ultimahost.pl (pakiet ovz.4096MB). Niestety, ale po reinstalacji systemu problem powrócił.
Proszę o pomoc.

Post autor: **Yampress** » 04 sierpnia 2013, 13:04

Zresetuj hasło roota do bazy mysql.

mpm1122 · Post autor: **mpm1122** » 04 sierpnia 2013, 15:17

Niestety, ale nie mogę zmienić hasła bo serwer nawet nie uruchamia się. Próbowałem przez:

Kod: Zaznacz cały

mysqladmin -u root password

Dostaję w wyniku coś takiego:

Kod: Zaznacz cały

mysqladmin -u root password testhaslo
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!

dhapollo · Post autor: **dhapollo** » 04 sierpnia 2013, 15:50

A może w ten sposób:

Kod: Zaznacz cały

dpkg-reconfigure mysql-server-5.5

mpm1122 · Post autor: **mpm1122** » 04 sierpnia 2013, 15:56

Kod: Zaznacz cały

/usr/sbin/dpkg-reconfigure: mysql-server-5.5 is broken or not fully installed.

Kod: Zaznacz cały

ps -ef | grep mysql

Kod: Zaznacz cały

root     15714  1546  0 15:57 pts/0    00:00:00 grep mysql
[B]telnet 127.0.0.1 3306[/B]
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused
[B]mysql_upgrade[/B]
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

Kod: Zaznacz cały

dpkg --configure mysql-server-5.5

Kod: Zaznacz cały

Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...
[ ok ] Stopping MySQL database server: mysqld.
130804 16:03:57 [Note] Plugin 'FEDERATED' is disabled.
130804 16:03:57 InnoDB: The InnoDB memory heap is disabled
130804 16:03:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130804 16:03:57 InnoDB: Compressed tables use zlib 1.2.7
130804 16:03:57 InnoDB: Using Linux native AIO
130804 16:03:57  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
130804 16:04:00  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
130804 16:04:00 InnoDB: Fatal error: cannot initialize AIO sub-system
130804 16:04:00 [ERROR] Plugin 'InnoDB' init function returned error.
130804 16:04:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130804 16:04:00 [ERROR] Unknown/unsupported storage engine: InnoDB
130804 16:04:00 [ERROR] Aborting


130804 16:04:00 [Note] /usr/sbin/mysqld: Shutdown complete

Jakieś pomysły?

Post autor: **Yampress** » 04 sierpnia 2013, 18:11

mpm1122 pisze:
Kod: Zaznacz cały
mysqladmin -u root password

Jako root wpisujesz:

Kod: Zaznacz cały

mysqladmin -u root password twoje_hasło

dhapollo · Post autor: **dhapollo** » 04 sierpnia 2013, 23:16

Problem rozwiązany, baza mysql uruchomiła się.

Kod: Zaznacz cały

echo " innodb_use_native_aio=0" >> /etc/mysql/my.cnf

Kod: Zaznacz cały

service mysql start
[ ok ] Starting MySQL database server: mysqld . . ..

Kod: Zaznacz cały

ps -A | grep mysql
 7334 pts/1    00:00:00 mysqld_safe
 7705 pts/1    00:00:00 mysqld

[+] Baza MySQL nie chce si

[+] Baza MySQL nie chce się włączyć