mysql - How to install mysql5.7.19 on CentOS7.3 to using generic binaries? -


i want install mysql-5.7.19 on centos7.3 using generic binaries.

and follow mysql official documents install.but i'm failed. of operation steps.

    # yum remove  mysql mysql-server mysql-libs mysql-server     # mv /etc/my.cnf     # rm -rf  /etc/mysql     # yum install libaio     # groupadd mysql     # useradd -r -g mysql -s /bin/false mysql      # cd /usr/local     # tar zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz      # ln -s /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64  mysql     # cd mysql     # mkdir data     # mkdir mysql-files     # chmod 750 mysql-files     # chown -r mysql .     # chgrp -r mysql .     # bin/mysqld --initialize --user=mysql # temporary password     # bin/mysql_ssl_rsa_setup     # chown -r root .     # chown -r mysql data mysql-files     # bin/mysqld_safe --user=mysql & # on step,it stop work.

on last step, waiting long time, no change. , show command：

    [root@root mysql]# bin/mysqld_safe --user=mysql &     [1] 19188     [root@root mysql]# logging '/usr/local/mysql/data/root.err'.     2017-08-15t11:20:20.303281z mysqld_safe starting mysqld daemon      databases /usr/local/mysql/data

and enter enter key, it's show that:

 [2]+  done                    bin/mysqld_safe --user=mysql

so, read "root.err" file,it's content:

[root@root data]# cat root.err 2017-08-15t11:35:28.810813z 0 [warning] timestamp implicit default value deprecated. please use --explicit_defaults_for_timestamp server option (see documentation more details). 2017-08-15t11:35:28.810926z 0 [note] --secure-file-priv set null. operations related importing , exporting data disabled 2017-08-15t11:35:28.810957z 0 [note] /usr/local/mysql/bin/mysqld (mysqld 5.7.19) starting process 19573 ... 2017-08-15t11:35:28.816198z 0 [note] innodb: punch hole support available 2017-08-15t11:35:28.816222z 0 [note] innodb: mutexes , rw_locks use gcc atomic builtins 2017-08-15t11:35:28.816227z 0 [note] innodb: uses event mutexes 2017-08-15t11:35:28.816232z 0 [note] innodb: gcc builtin __sync_synchronize() used memory barrier 2017-08-15t11:35:28.816235z 0 [note] innodb: compressed tables use zlib 1.2.3 2017-08-15t11:35:28.816239z 0 [note] innodb: using linux native aio 2017-08-15t11:35:28.816497z 0 [note] innodb: number of pools: 1 2017-08-15t11:35:28.816614z 0 [note] innodb: using cpu crc32 instructions 2017-08-15t11:35:28.818176z 0 [note] innodb: initializing buffer pool, total size = 128m, instances = 1, chunk size = 128m 2017-08-15t11:35:28.826402z 0 [note] innodb: completed initialization of buffer pool 2017-08-15t11:35:28.828653z 0 [note] innodb: if mysqld execution user authorized, page cleaner thread priority can changed. see man page of setpriority(). 2017-08-15t11:35:28.840789z 0 [note] innodb: highest supported file format barracuda. 2017-08-15t11:35:28.850411z 0 [note] innodb: creating shared tablespace temporary tables 2017-08-15t11:35:28.850452z 0 [note] innodb: setting file './ibtmp1' size 12 mb. physically writing file full; please wait ... 2017-08-15t11:35:29.052935z 0 [note] innodb: file './ibtmp1' size 12 mb. 2017-08-15t11:35:29.053828z 0 [note] innodb: 96 redo rollback segment(s) found. 96 redo rollback segment(s) active. 2017-08-15t11:35:29.053842z 0 [note] innodb: 32 non-redo rollback segment(s) active. 2017-08-15t11:35:29.054615z 0 [note] innodb: waiting purge start 2017-08-15t11:35:29.104749z 0 [note] innodb: 5.7.19 started; log sequence number 2539569 2017-08-15t11:35:29.104975z 0 [note] plugin 'federated' disabled. 2017-08-15t11:35:29.109728z 0 [note] found ca.pem, server-cert.pem , server-key.pem in data directory. trying enable ssl support using them. 2017-08-15t11:35:29.109925z 0 [warning] ca certificate ca.pem self signed. 2017-08-15t11:35:29.111515z 0 [note] server hostname (bind-address): '*'; port: 3306 2017-08-15t11:35:29.111564z 0 [note] ipv6 available. 2017-08-15t11:35:29.111576z 0 [note]   - '::' resolves '::'; 2017-08-15t11:35:29.111590z 0 [note] server socket created on ip: '::'. 2017-08-15t11:35:29.111815z 0 [note] innodb: loading buffer pool(s) /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64/data/ib_buffer_pool 2017-08-15t11:35:29.112760z 0 [note] innodb: buffer pool(s) load completed @ 170815 19:35:29 2017-08-15t11:35:29.123457z 0 [note] event scheduler: loaded 0 events 2017-08-15t11:35:29.124324z 0 [note] /usr/local/mysql/bin/mysqld: ready connections. version: '5.7.19'  socket: '/tmp/mysql.sock'  port: 3306  mysql community server (gpl) 2017-08-15t11:35:29.124337z 0 [note] executing 'select * information_schema.tables;' list of tables using deprecated partition engine. may use startup option '--disable-partition-engine-check' skip check.  2017-08-15t11:35:29.124341z 0 [note] beginning of list of non-natively partitioned tables 2017-08-15t11:35:29.133315z 0 [note] end of list of non-natively partitioned tables

what should ? please me. !!!


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more