MySQL Forums
Forum List  »  Install & Repo

mysql 5.1.73 server on RHEL 6.7 client to get running
Posted by: Kerstin Volkenand
Date: September 09, 2016 08:00AM

I cant get mysql 5.1.73 running on RHEL 6.7 client .
content from log below and config

Log
view /var/log/mysqld.log

160909 15:11:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160909 15:11:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160909 15:11:23 InnoDB: Initializing buffer pool, size = 8.0M
160909 15:11:23 InnoDB: Completed initialization of buffer pool
160909 15:11:23 InnoDB: Started; log sequence number 0 44233
160909 15:11:23 [ERROR] Can't start server : Bind on unix socket: Address already in use
160909 15:11:23 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
160909 15:11:23 [ERROR] Aborting

160909 15:11:23 InnoDB: Starting shutdown...
160909 15:11:28 InnoDB: Shutdown completed; log sequence number 0 44233
160909 15:11:28 [Note] /usr/libexec/mysqld: Shutdown complete

160909 15:11:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

mysql_upgrade
root@oc8800070412 ~]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--host=127.0.0.1' '--socket=/var/lib/mysql/mysql.sock'
mysqlcheck: Got error: 2003: Can't connect to MySQL server on '127.0.0.1' (111) when trying to connect
FATAL ERROR: Upgrade failed

[root@oc8800070412 ~]# rpm -qa|grep mysql
mysql-5.1.73-5.el6_7.1.x86_64
mysql-libs-5.1.73-5.el6_7.1.x86_64
mysql-server-5.1.73-5.el6_7.1.x86_64
mysql-connector-java-5.1.17-6.el6.noarch
[root@oc8800070412 ~]#


user hsqldb
all mysql folders have the owner
hsqldb:x:96:96::/var/lib/hsqldb:/sbin/nologin

no socket under /var/lib open


[root@oc8800070412 ~]# netstat -an|grep LISTEN|grep /var
unix 2 [ ACC ] STREAM LISTENING 19547 /var/run/libvirt/libvirt-sock
unix 2 [ ACC ] STREAM LISTENING 19549 /var/run/libvirt/libvirt-sock-ro
unix 2 [ ACC ] STREAM LISTENING 16630 /var/run/cups/cups.sock
unix 2 [ ACC ] STREAM LISTENING 16761 @/var/run/hald/dbus-6TqyrzBfhN
unix 2 [ ACC ] STREAM LISTENING 16716 /var/run/acpid.socket
unix 2 [ ACC ] STREAM LISTENING 16188 /var/run/rpcbind.sock
unix 2 [ ACC ] STREAM LISTENING 16393 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 17442 /var/run/sdp
unix 2 [ ACC ] STREAM LISTENING 16754 @/var/run/hald/dbus-15kfxHi24X
[root@oc8800070412 ~]# find / -type s|grep /var/run

/var/run/rpcbind.sock
/var/run/dbus/system_bus_socket
/var/run/cups/cups.sock
/var/run/libvirt/libvirt-sock-ro
/var/run/libvirt/libvirt-sock
/var/run/sdp
/var/run/portreserve/socket


/etc/init.d/mysqld start
FAILED



my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=hsqldb
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
password=hsqldb
port=3306
host=127.0.0.1
socket=/var/lib/mysql/mysql.sock

~

Options: ReplyQuote


Subject
Written By
Posted
mysql 5.1.73 server on RHEL 6.7 client to get running
September 09, 2016 08:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.