Re: unknown option '--ndbcluster'
Ok,
I ran ./mysql_install_db --user=mysql --datadir=/var/lib/mysql
I think it installed the db
4,0K -rw-r----- 1 xxx xxx 56 déc. 23 13:57 auto.cnf
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 ca-key.pem
4,0K -rw-r--r-- 1 xxx xxx 1,1K déc. 23 13:57 ca.pem
4,0K -rw-r--r-- 1 xxx xxx 1,1K déc. 23 13:57 client-cert.pem
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 client-key.pem
4,0K -rw-r----- 1 xxx xxx 323 déc. 23 13:58 ib_buffer_pool
12M -rw-r----- 1 xxx xxx 12M déc. 23 14:07 ibdata1
49M -rw-r----- 1 xxx xxx 48M déc. 23 14:07 ib_logfile0
48M -rw-r----- 1 xxx xxx 48M déc. 23 13:56 ib_logfile1
12M -rw-r----- 1 xxx xxx 12M déc. 23 14:07 ibtmp1
4,0K drwxr-x--- 2 xxx xxx 4,0K déc. 23 13:57 mysql
4,0K drwxr-x--- 2 xxx xxx 4,0K déc. 23 13:57 ndbinfo
4,0K drwxr-x--- 2 xxx xxx 4,0K déc. 23 13:57 performance_schema
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 private_key.pem
4,0K -rw-r--r-- 1 xxx xxx 451 déc. 23 13:57 public_key.pem
4,0K -rw-r--r-- 1 xxx xxx 1,1K déc. 23 13:57 server-cert.pem
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 server-key.pem
4,0K -rw-r----- 1 xxx xxx 5 déc. 23 14:08 sql.pid
12K drwxr-x--- 2 xxx xxx 12K déc. 23 13:57 sys
./mysqld
chris@sql:/opt/mysql/server-5.7/bin$ ./mysqld &
[1] 1798
chris@sql:/opt/mysql/server-5.7/bin$ 2016-12-23T13:07:30.137168Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-23T13:07:30.137641Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2016-12-23T13:07:30.137665Z 0 [Note] ./mysqld (mysqld 5.7.16-ndb-7.5.4-cluster-gpl) starting as process 1798 ...
2016-12-23T13:07:30.139830Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-12-23T13:07:30.140061Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-12-23T13:07:30.140294Z 0 [Note] InnoDB: Uses event mutexes
2016-12-23T13:07:30.140351Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-12-23T13:07:30.140383Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-12-23T13:07:30.140413Z 0 [Note] InnoDB: Using Linux native AIO
2016-12-23T13:07:30.140577Z 0 [Note] InnoDB: Number of pools: 1
2016-12-23T13:07:30.140677Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-12-23T13:07:30.141544Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-12-23T13:07:30.145985Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-12-23T13:07:30.147150Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-12-23T13:07:30.158270Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-12-23T13:07:30.159197Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2538225
2016-12-23T13:07:30.159452Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2538234
2016-12-23T13:07:30.159716Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2538234
2016-12-23T13:07:30.159892Z 0 [Note] InnoDB: Database was not shutdown normally!
2016-12-23T13:07:30.160027Z 0 [Note] InnoDB: Starting crash recovery.
2016-12-23T13:07:30.340087Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-12-23T13:07:30.341117Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-12-23T13:07:30.341649Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-12-23T13:07:30.403538Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-12-23T13:07:30.405492Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-12-23T13:07:30.405895Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-12-23T13:07:30.406739Z 0 [Note] InnoDB: Waiting for purge to start
2016-12-23T13:07:30.458068Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 2538234
2016-12-23T13:07:30.459384Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-12-23T13:07:30.463710Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-12-23T13:07:30.466162Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161223 14:07:30
2016-12-23T13:07:30.657587Z 0 [Note] NDB: NodeID is 3, management server '192.168.56.101:1186'
[Note] NDB[0]: NodeID: 3, no storage nodes connected (timed out)
2016-12-23T13:08:00.840054Z 0 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
2016-12-23T13:08:00.841109Z 0 [Note] NDB Binlog: Starting...
2016-12-23T13:08:00.841736Z 1 [Note] NDB Binlog: Started
2016-12-23T13:08:00.842140Z 1 [Note] NDB Binlog: Setting up
2016-12-23T13:08:00.842998Z 1 [Note] NDB Binlog: Created schema Ndb object, reference: 0x80040003, name: 'Ndb Binlog schema change monitoring'
2016-12-23T13:08:00.844224Z 1 [Note] NDB Binlog: Created injector Ndb object, reference: 0x80050003, name: 'Ndb Binlog data change monitoring'
2016-12-23T13:08:00.844859Z 1 [Note] NDB Binlog: Setup completed
2016-12-23T13:08:00.845522Z 1 [Note] NDB Binlog: Wait for server start completed
2016-12-23T13:08:00.846549Z 0 [Note] NDB Util: Starting...
2016-12-23T13:08:00.847409Z 2 [Note] NDB Util: Wait for server start completed
2016-12-23T13:08:00.851733Z 0 [Note] NDB Index Stat: Starting...
2016-12-23T13:08:00.852447Z 0 [Note] NDB Index Stat: Wait for server start completed
2016-12-23T13:08:00.951717Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2016-12-23T13:08:00.952035Z 0 [Warning] CA certificate ca.pem is self signed.
2016-12-23T13:08:00.953311Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-12-23T13:08:00.953446Z 0 [Note] IPv6 is available.
2016-12-23T13:08:00.953587Z 0 [Note] - '::' resolves to '::';
2016-12-23T13:08:00.953799Z 0 [Note] Server socket created on IP: '::'.
2016-12-23T13:08:00.973175Z 0 [Note] Event Scheduler: Loaded 0 events
2016-12-23T13:08:00.973440Z 0 [Note] ./mysqld: ready for connections.
Version: '5.7.16-ndb-7.5.4-cluster-gpl' socket: '/tmp/mysql.sock' port: 3306 MySQL Cluster Community Server (GPL)
2016-12-23T13:08:00.973646Z 1 [Note] NDB Binlog: Check for incidents
2016-12-23T13:08:00.973673Z 1 [Note] NDB Binlog: Wait for cluster to start
2016-12-23T13:08:00.973669Z 0 [Note] NDB Index Stat: Wait for cluster to start
2016-12-23T13:08:00.973712Z 0 [Note] NDB Index Stat: Started
2016-12-23T13:08:00.973666Z 2 [Note] NDB Util: Wait for cluster to start
2016-12-23T13:08:00.973750Z 2 [Note] NDB Util: Started
2016-12-23T13:08:00.973931Z 0 [Note] NDB Index Stat: created Ndb object 'Ndb Index Stat', ref: 0x80070003
ps -ef | grep mysql :
chris 1798 1268 1 14:07 pts/0 00:00:05 ./mysqld
chris 1867 1268 0 14:14 pts/0 00:00:00 grep --color=auto mysql
i can't access the db
chris@sql:/opt/mysql/server-5.7/bin$ ./mysql -u root
2016-12-23T13:16:32.077971Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)