Can't start mysql

neversleep · 2012-01-15 06:14:32

when I type "rc.d start mysqld" it displays busy for a while, then fails. At this point it does not generate an error message. I have changed the permissions of /var/lib/mysql recursively to 777. I have also created the mysqld directory in /var/run and given it 777 permissions. I hope I have included all the relevant files.

I have read every suggestion on the internet and gotten nowhere. Please help a noobus out. Thanks in advance.

/var/lib/mysql/localhost.err

120115 01:11:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120115  1:11:48 [Warning] One can only use the --user switch if running as root

120115  1:11:48 InnoDB: The InnoDB memory heap is disabled
120115  1:11:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120115  1:11:48 InnoDB: Compressed tables use zlib 1.2.5
120115  1:11:48 InnoDB: Initializing buffer pool, size = 128.0M
120115  1:11:48 InnoDB: Completed initialization of buffer pool
120115  1:11:48 InnoDB: highest supported file format is Barracuda.
120115  1:11:50  InnoDB: Waiting for the background threads to start
120115  1:11:51 InnoDB: 1.1.8 started; log sequence number 1595675
120115  1:11:51 [ERROR] Can't start server : Bind on unix socket: Permission denied
120115  1:11:51 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
120115  1:11:51 [ERROR] Aborting

120115  1:11:51  InnoDB: Starting shutdown...
120115  1:11:51  InnoDB: Shutdown completed; log sequence number 1595675
120115  1:11:51 [Note] /usr/bin/mysqld: Shutdown complete

120115 01:11:51 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.pid ended

/etc/rc.conf

#
# /etc/rc.conf - Main Configuration for Arch Linux
#

# -----------------------------------------------------------------------
# LOCALIZATION
# -----------------------------------------------------------------------
#
# LOCALE: available languages can be listed with the 'locale -a' command
# DAEMON_LOCALE: If set to 'yes', use $LOCALE as the locale during daemon
# startup and during the boot process. If set to 'no', the C locale is used.
# HARDWARECLOCK: set to "", "UTC" or "localtime", any other value will result
#   in the hardware clock being left untouched (useful for virtualization)
#   Note: Using "localtime" is discouraged, using "" makes hwclock fall back
#   to the value in /var/lib/hwclock/adjfile
# TIMEZONE: timezones are found in /usr/share/zoneinfo
#   Note: if unset, the value in /etc/localtime is used unchanged
# KEYMAP: keymaps are found in /usr/share/kbd/keymaps
# CONSOLEFONT: found in /usr/share/kbd/consolefonts (only needed for non-US)
# CONSOLEMAP: found in /usr/share/kbd/consoletrans
# USECOLOR: use ANSI color sequences in startup messages
#
LOCALE="en_US.UTF-8"
DAEMON_LOCALE="no"
HARDWARECLOCK="UTC"
TIMEZONE="America/New_York"
KEYMAP="us"
CONSOLEFONT=
CONSOLEMAP=
USECOLOR="yes"

# -----------------------------------------------------------------------
# HARDWARE
# -----------------------------------------------------------------------
#
# MODULES: Modules to load at boot-up. Blacklisting is no longer supported.
#   Replace every !module by an entry as on the following line in a file in
#   /etc/modprobe.d:
#     blacklist module
#   See "man modprobe.conf" for details.
#
MODULES=()

# Udev settle timeout (default to 30)
UDEV_TIMEOUT=30

# Scan for FakeRAID (dmraid) Volumes at startup
USEDMRAID="no"

# Scan for BTRFS volumes at startup
USEBTRFS="no"

# Scan for LVM volume groups at startup, required if you use LVM
USELVM="no"

# -----------------------------------------------------------------------
# NETWORKING
# -----------------------------------------------------------------------
#
# HOSTNAME: Hostname of machine. Should also be put in /etc/hosts
#
HOSTNAME="localhost"

# Use 'ip addr' or 'ls /sys/class/net/' to see all available interfaces.
#
# Wired network setup
#   - interface: name of device (required)
#   - address: IP address (leave blank for DHCP)
#   - netmask: subnet mask (ignored for DHCP) (optional, defaults to 255.255.255.0)
#   - broadcast: broadcast address (ignored for DHCP) (optional)
#   - gateway: default route (ignored for DHCP)
# 
# Static IP example
# interface=eth0
# address=192.168.0.2
# netmask=255.255.255.0
# broadcast=192.168.0.255
# gateway=192.168.0.1
#
# DHCP example
# interface=eth0
# address=
# netmask=
# gateway=

interface=eth0
address=
netmask=
broadcast=
gateway=

# Setting this to "yes" will skip network shutdown.
# This is required if your root device is on NFS.
NETWORK_PERSIST="no"

# Enable these netcfg profiles at boot-up. These are useful if you happen to
# need more advanced network features than the simple network service
# supports, such as multiple network configurations (ie, laptop users)
#   - set to 'menu' to present a menu during boot-up (dialog package required)
#   - prefix an entry with a ! to disable it
#
# Network profiles are found in /etc/network.d
#
# This requires the netcfg package
#
NETWORKS=(menu)
WIRELESS_INTERFACE="wlan0"
WIRED_INTERFACE="ethO"

# -----------------------------------------------------------------------
# DAEMONS
# -----------------------------------------------------------------------
#
# Daemons to start at boot-up (in this order)
#   - prefix a daemon with a ! to disable it
#   - prefix a daemon with a @ to start it up in the background
#
# If something other takes care of your hardware clock (ntpd, dual-boot...)
# you should disable 'hwclock' here.
#
DAEMONS=(hwclock syslog-ng @network crond net-auto-wired dbus acpid)

/etc/hosts

#
# /etc/hosts: static lookup table for host names
#

#<ip-address>	<hostname.domain.org>	<hostname>
127.0.0.1	localhost.localdomain	localhost
#::1		localhost.localdomain	localhost

# End of file

/etc/mysql/my.cnf

# MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
datadir		= /var/lib/mysql
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

neversleep · 2012-01-15 06:20:28

Son of a Bitch! Well, figured it out...

I had indeed created /var/run/mysqld with user and group mysql but had given it permissions 755. I changed it to 777. Got another error message complaining about permissions in var/run/daemons/mysqld so I 777'd that directory too and magic! It works. Please conjure an imp to come pat me on the back. That is 3 hours I can never have back. Thanks anyway.

Last edited by neversleep (2012-01-15 06:21:24)

neversleep · 2012-01-15 06:34:23

Well let me qualify that. I rebooted and tried again, cause I'm smart like that, and it failed. Come to find out the permissions on the /var/run/mysqld and /var/run/daemons had reverted to their old state. Why? Are they created on the fly or something? I changed them back and it worked again.

Stebalien · 2012-01-15 16:52:10

neversleep wrote:

120115 01:11:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120115 1:11:48 [Warning] One can only use the --user switch if running as root
...

Did you remember to run `rc.d start mysqld` as root?
And to answer your other question, /var/run and /run are recreated on boot (and stored in ram using tmpfs).

quazza · 2012-01-18 11:10:19

Hi,

I seem to have had an issue with mysql as well and it appears to be that I don't have a sock file as I have checked /var/run/mysqld for mysqld.sock and it does not exist so would that be what is stopping mysql server from starting and if so how do I create the sock file ??

Cheers

Quazza

Update - Actually I solved my problem to, it was to do with my log files filling up but that also led to the bigger problem of a failing HD oh what fun anyway got there before any major data loss.

Last edited by quazza (2012-01-20 08:09:26)

Arch Linux

#1 2012-01-15 06:14:32

Can't start mysql

#2 2012-01-15 06:20:28

Re: Can't start mysql

#3 2012-01-15 06:34:23

Re: Can't start mysql

#4 2012-01-15 16:52:10

Re: Can't start mysql

#5 2012-01-18 11:10:19

Re: Can't start mysql

Board footer