ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") centos 6 -


centos 6, openlitespeed installed, using mariadb

mysql works until stops , can't start

[root@backup ~]# service mysql start starting mysql.170815 09:56:24 mysqld_safe logging '/var/lib/mysql/backup.err'. 170815 09:56:24 mysqld_safe starting mysqld daemon databases /var/lib/mysql ..... error!

/var/lib/mysql/backup.err:

170814 06:44:02 mysqld_safe starting mysqld daemon databases /var/lib/mysql 2017-08-14  6:44:02 3069880736 [note] /usr/sbin/mysqld (mysqld 10.1.25-mariadb) starting process 3250 ... 2017-08-14  6:44:02 3069880736 [note] innodb: innodb_empty_free_list_algorithm has been changed legacy because of small buffer pool size. in order use backoff, increase buffer pool @ least 20mb.  2017-08-14  6:44:02 3069880736 [note] innodb: using mutexes ref count buffer pool pages 2017-08-14  6:44:02 3069880736 [note] innodb: innodb memory heap disabled 2017-08-14  6:44:02 3069880736 [note] innodb: mutexes , rw_locks use gcc atomic builtins 2017-08-14  6:44:02 3069880736 [note] innodb: gcc builtin __sync_synchronize() used memory barrier 2017-08-14  6:44:02 3069880736 [note] innodb: compressed tables use zlib 1.2.3 2017-08-14  6:44:02 3069880736 [note] innodb: using linux native aio 2017-08-14  6:44:02 3069880736 [note] innodb: using generic crc32 instructions 2017-08-14  6:44:02 3069880736 [note] innodb: initializing buffer pool, size = 128.0m 2017-08-14  6:44:02 3069880736 [note] innodb: completed initialization of buffer pool 2017-08-14  6:44:02 3069880736 [note] innodb: highest supported file format barracuda. 2017-08-14  6:44:02 3069880736 [note] innodb: starting crash recovery checkpoint lsn=2657313375 2017-08-14  6:44:02 3069880736 [note] innodb: restoring possible half-written data pages doublewrite buffer... innodb: set innodb_force_recovery ignore error. 2017-08-14  6:44:02 3069880736 [error] plugin 'innodb' init function returned error. 2017-08-14  6:44:02 3069880736 [error] plugin 'innodb' registration storage engine failed. 2017-08-14  6:44:02 3069880736 [note] plugin 'feedback' disabled. 2017-08-14  6:44:02 3069880736 [error] unknown/unsupported storage engine: innodb 2017-08-14  6:44:02 3069880736 [error] aborting  error in my_thread_global_end(): 1 threads didn't exit 170814 06:44:07 mysqld_safe mysqld pid file /var/lib/mysql/backup.pid ended

test mysql:

[root@backup ~]# mysql error 2002 (hy000): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (111 "connection refused")

/etc/my.cnf :

# [client]  port = 3306  socket = /var/lib/mysql/mysql.sock # group read both both client , server # use options affect # [client-server]  # # include files config directory # !includedir /etc/my.cnf.d

/etc/my.cnf.d/server.cnf:

# # these groups read mariadb server. # use options server (but not clients) should see # # see examples of server my.cnf files in /usr/share/mysql/ #  # read standalone daemon , embedded servers [server]  # mysqld standalone daemon [mysqld]  # # * galera-related settings # [galera] # mandatory settings #wsrep_on=on #wsrep_provider= #wsrep_cluster_address= #binlog_format=row #default_storage_engine=innodb #innodb_autoinc_lock_mode=2 # # allow server accept connections on interfaces. # #bind-address=0.0.0.0 # # optional setting #wsrep_slave_threads=1 #innodb_flush_log_at_trx_commit=0  # embedded server [embedded]  # group read mariadb servers, not mysql. # if use same .cnf file mysql , mariadb, # can put mariadb-only options here [mariadb]  # group read mariadb-10.1 servers. # if use same .cnf file mariadb of different versions, # use group options older servers don't understand [mariadb-10.1]

i have uninstalled mariadb server , client, reinstalled still doesn't work. 

[root@backup ~]# service mysql restart  error! mysql server pid file not found! starting mysql.170815 11:33:12 mysqld_safe logging '/var/lib/mysql/backup.err'. 170815 11:33:12 mysqld_safe starting mysqld daemon databases /var/lib/mysql ..... error!  error! failed restart server. [root@backup ~]# mysql error 2002 (hy000): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (111 "connection refused")

grep "socket"

[root@backup ~]# mysqld --verbose --help | grep "socket" 2017-08-15 18:05:44 3070110112 [note] plugin 'feedback' disabled.                       buffer length tcp/ip , socket communication   --performance-schema-max-socket-classes=#                       maximum number of socket instruments.   --performance-schema-max-socket-instances=#                       maximum number of opened instrumented sockets. use 0                       slave off socket once slave connects. due   --socket=name       socket file use connection performance-schema-max-socket-classes                      10 performance-schema-max-socket-instances                    -1 socket                                                     /var/lib/mysql/mysql.sock

what possibly going wrong?


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

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

Why does math.random(999999999999) returns 1 in Lua? -

i tried: print(math.random(999999999999)) , has printed 1 . also math.random() includes 999999999999 printing same thing. examples: print(math.random(1.999999999999)) » 1 print(math.random(1999999999999)) » 1 for k,v in next,{math.random(999999999999), math.random(1999999999999), math.random(2.999999999999)} print(v) end » 1 local n = math.random(999999999999) print(n==1) » true then think understood (if know lua of course). can explain me? @edits: the lua version i'm using 5.2. i tried print(math.random(-999999999999)) , printed 111711452 . looks worked positive number. this problem surely because math.random treats input arguments passed in lua 5.1 and/or 5.2. [mathlib.c] 1 : as may know in c , standard int can represent values -2,147,483,648 2,147,483,647 . adding +1 2,147,483,647 , in use-case, overflow , wrap around value giving -2,147,483,648 . end result negative since you're multiplying positive negative number. ther...
Read more