не не прокатило, делал так
/etc/systemd/system/mysql.service
Код:
# MySQL systemd service file
[Unit]
Description=MySQL Community Server
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
PermissionsStartOnly=true
ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
ExecStart=/usr/bin/mysqld_safe
ExecStartPost=/usr/share/mysql/mysql-systemd-start post
TimeoutSec=600
Restart=on-failure
RuntimeDirectory=mysqld
RuntimeDirectoryMode=755
LimitNOFILE=infinity
LimitMEMLOCK=infinity
Думаю дело в этом
Код:
2015-06-06 16:56:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
пока побороть не смог, explicit_defaults_for_timestamp = 1 в /etc/mysql/my.cnf не работает, все равно выдает
Код:
mysql> show global variables like 'explicit_defaults_for_timestamp';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| explicit_defaults_for_timestamp | OFF |
+---------------------------------+-------+
1 row in set (0.00 sec)
не а не в этом, все [Warning] победил, но преста так и не завелась, блин...
Код:
150606 20:02:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-06-06 20:02:05 0 [Note] /usr/bin/mysqld (mysqld 5.6.24-72.2) starting as process 554 ...
2015-06-06 20:02:05 554 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-06 20:02:05 554 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-06 20:02:05 554 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-06-06 20:02:05 554 [Note] InnoDB: Memory barrier is not used
2015-06-06 20:02:05 554 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-06-06 20:02:05 554 [Note] InnoDB: Using Linux native AIO
2015-06-06 20:02:05 554 [Note] InnoDB: Using CPU crc32 instructions
2015-06-06 20:02:05 554 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-06-06 20:02:05 554 [Note] InnoDB: Completed initialization of buffer pool
2015-06-06 20:02:06 554 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-06 20:02:08 554 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-06 20:02:08 554 [Note] InnoDB: Waiting for purge to start
2015-06-06 20:02:08 554 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 84317432
2015-06-06 20:02:08 554 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-06-06 20:02:08 554 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-06-06 20:02:08 554 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-06 20:02:08 554 [Note] IPv6 is available.
2015-06-06 20:02:08 554 [Note] - '::' resolves to '::';
2015-06-06 20:02:08 554 [Note] Server socket created on IP: '::'.
2015-06-06 20:02:08 554 [Note] Event Scheduler: Loaded 0 events
2015-06-06 20:02:08 554 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.6.24-72.2' socket: '/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)