mysql的原始安装目录_**MySQL最简单原始安装和配置 【切换目录的错误】

[root@ibm01 log]#

[root@ibm01 log]# cat alert.log

2016-07-14T10:37:42.718861Z mysqld_safe Starting mysqld daemon

with databases from /efs/ibm01/db/mysql

2016-07-14T10:37:42.897140Z 0 [Warning] TIMESTAMP with

implicit DEFAULT value is deprecated. Please use

--explicit_defaults_for_timestamp server option (see documentation

for more details).

2016-07-14T10:37:42.897988Z 0 [Note] /usr/sbin/mysqld (mysqld

5.7.11-log) starting as process 58509 ...

2016-07-14T10:37:42.902761Z 0 [Warning] option

'innodb-read-io-threads': unsigned value 256 adjusted to 64

2016-07-14T10:37:42.903058Z 0 [Warning] InnoDB: Using

innodb_file_format is deprecated and the parameter may be removed

in future releases. See

http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html

2016-07-14T10:37:42.903105Z 0 [Note] InnoDB: PUNCH HOLE

support available

2016-07-14T10:37:42.903112Z 0 [Note] InnoDB: Mutexes and

rw_locks use GCC atomic builtins

2016-07-14T10:37:42.903118Z 0 [Note] InnoDB: Uses event

mutexes

2016-07-14T10:37:42.903122Z 0 [Note] InnoDB: GCC builtin

__sync_synchronize() is used for memory barrier

2016-07-14T10:37:42.903126Z 0 [Note] InnoDB: Compressed tables

use zlib 1.2.3

2016-07-14T10:37:42.903141Z 0 [Note] InnoDB: Adjusting

innodb_buffer_pool_instances from 2 to 1 since

innodb_buffer_pool_size is less than 1024 MiB

2016-07-14T10:37:42.904556Z 0 [Note] InnoDB: Number of pools:

1

2016-07-14T10:37:42.904652Z 0 [Note] InnoDB: Using CPU crc32

instructions

2016-07-14T10:37:42.978308Z 0 [Note] InnoDB: Initializing

buffer pool, total size = 256M, instances = 1, chunk size =

128M

2016-07-14T10:37:42.993075Z 0 [Note] InnoDB: Completed

initialization of buffer pool

2016-07-14T10:37:43.003159Z 0 [Note] InnoDB: If the mysqld

execution user is authorized, page cleaner thread priority can be

changed. See the man page of setpriority().

2016-07-14T10:37:43.015840Z 0 [Note] InnoDB: Highest supported

file format is Barracuda.

2016-07-14T10:37:43.029938Z 0 [Note] InnoDB: Creating shared

tablespace for temporary tables

2016-07-14T10:37:43.032216Z 0 [Note] InnoDB: Setting file

'/efs/ibm01/db/mysql/ibtmp1' size to 12 MB. Physically writing the

file full; Please wait ...

2016-07-14T10:37:43.076521Z 0 [Note] InnoDB: File

'/efs/ibm01/db/mysql/ibtmp1' size is now 12 MB.

2016-07-14T10:37:43.077213Z 0 [Note] InnoDB: 96 redo rollback

segment(s) found. 96 redo rollback segment(s) are active.

2016-07-14T10:37:43.077232Z 0 [Note] InnoDB: 32 non-redo

rollback segment(s) are active.

2016-07-14T10:37:43.077562Z 0 [Note] InnoDB: Waiting for purge

to start

2016-07-14T10:37:43.128551Z 0 [Note] InnoDB: 5.7.11 started;

log sequence number 2493718

2016-07-14T10:37:43.128800Z 0 [Note] InnoDB: Loading buffer

pool(s) from /efs/ibm01/db/mysql/ib_buffer_pool

2016-07-14T10:37:43.129142Z 0 [Note] Plugin 'FEDERATED' is

disabled.

2016-07-14T10:37:43.130848Z 0 [Note] InnoDB: Buffer pool(s)

load completed at 160714 18:37:43

2016-07-14T10:37:43.174947Z 0 [Note] Found ca.pem,

server-cert.pem and server-key.pem in data directory. Trying to

enable SSL support using them.

2016-07-14T10:37:43.175179Z 0 [Warning] CA certificate ca.pem

is self signed.

2016-07-14T10:37:43.176484Z 0 [Note] Server hostname

(bind-address): '*'; port: 3306

2016-07-14T10:37:43.176538Z 0 [Note] IPv6 is available.

2016-07-14T10:37:43.176547Z 0 [Note]  - '::'

resolves to '::';

2016-07-14T10:37:43.176552Z 0 [Note] Server socket created on

IP: '::'.

2016-07-14T10:37:43.179314Z 0 [Warning] 'db' entry 'sys

mysql.sys@localhost' ignored in --skip-name-resolve mode.

2016-07-14T10:37:43.179452Z 0 [Warning] 'proxies_priv' entry

'@ root@localhost' ignored in --skip-name-resolve mode.

2016-07-14T10:37:43.180373Z 0 [Warning] 'tables_priv' entry

'sys_config mysql.sys@localhost' ignored in --skip-name-resolve

mode.

2016-07-14T10:37:43.186205Z 0 [Note] Event Scheduler: Loaded 0

events

2016-07-14T10:37:43.186475Z 0 [Note] /usr/sbin/mysqld: ready

for connections.

Version: '5.7.11-log'  socket:

'/efs/ibm01/db/mysql/run/mysql.sock'  port: 3306

MySQL Community Server (GPL)

2016-07-14T10:37:43.227527Z 2 [Note] Access denied for user

'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)

[root@ibm01 log]#