List:General Discussion« Previous MessageNext Message »
From:madunix@gmail.com Date:August 23 2011 9:40am
Subject:Re: mysql
View as plain text  
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
#socket         = /tmp/mysqld.sock
user            = "root"
pass            = "%password%"

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
#socket         = /tmp/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user            = mysql
socket          = /var/run/mysqld/mysqld.sock
#socket         = /tmp/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 10.5.1.100
#bind-address            = 0.0.0.0
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1

log_error                = /var/log/mysql/error.log

# Here you can see queries with especially long duration
#log_slow_queries       = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/


root@server1:/var/run/mysqld# /etc/init.d/mysql status
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql status

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the status(8) utility, e.g. status mysql
mysql respawn/post-start, (post-start) process 16836
root@server1:/var/run/mysqld# /etc/init.d/mysql stop
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql
mysql stop/waiting
root@server1:/var/run/mysqld# /etc/init.d/mysql status
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql status

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the status(8) utility, e.g. status mysql
mysql stop/waiting
root@server1:/var/run/mysqld# /etc/init.d/mysql status
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql status

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the status(8) utility, e.g. status mysql
mysql stop/waiting
root@server1:/var/run/mysqld# ps -ef | grep mysql
root     17018  6569  0 12:15 pts/1    00:00:00 grep --color=auto mysql
root@server1:/var/run/mysqld# ps -ef | grep mysqld
root     17022  6569  0 12:15 pts/1    00:00:00 grep --color=auto mysqld

root@server1:/var/run/mysqld# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
mysql stop/post-start, process 19215
        post-start process 19216


root@server1:/var/log/mysql# tail -f error.log
110823 12:33:00 [Note] Plugin 'FEDERATED' is disabled.
110823 12:33:00  InnoDB: Started; log sequence number 0 1754746
110823 12:33:00 [ERROR] Can't start server: Bind on TCP/IP port:
Cannot assign requested address
110823 12:33:00 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
110823 12:33:00 [ERROR] Aborting

110823 12:33:00  InnoDB: Starting shutdown...
110823 12:33:06  InnoDB: Shutdown completed; log sequence number 0 1754746
110823 12:33:06 [Note] /usr/sbin/mysqld: Shutdown complete

110823 12:33:30 [Note] Plugin 'FEDERATED' is disabled.
110823 12:33:30  InnoDB: Started; log sequence number 0 1754746
110823 12:33:30 [ERROR] Can't start server: Bind on TCP/IP port:
Cannot assign requested address
110823 12:33:30 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
110823 12:33:30 [ERROR] Aborting

110823 12:33:30  InnoDB: Starting shutdown...

oot@server1:/var/log/mysql# mysql -uroot -p -h127.0.0.1 -P3306
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)













On Tue, Aug 23, 2011 at 11:55 AM, Adarsh Sharma
<adarsh.sharma@stripped> wrote:
> Follow the steps :-
>
> 1. Check mysqld is running or not
>
>> /etc/init.d/mysql status
>
> 2. If not > /etc/init.d/mysql start
>
> If error occurs , check the logs & usually this error means ur server is not
> running at the moment.
>
>
> Good Luck !
>
> Claudio Nanni wrote:
>>
>> You have 2 options: use tcp/ip or find the right .sock file
>>
>> use this:
>> mysql -uUSER -p -h127.0.0.1 -P3306
>>
>> or check in the my.cnf where the server creates the .sock file
>> you have to use the same with the local client.
>>
>> Ciao Mad!
>>
>> Claudio
>>
>>
>>
>> 2011/8/23 Andrew Moore <eroomydna@stripped>
>>
>>
>>>
>>> That's too bad. How did you configure things? What trouble shooting have
>>> you
>>> done so far?
>>> On Aug 23, 2011 9:18 AM, "madunix@stripped" <madunix@stripped>
> wrote:
>>>
>>>>
>>>> When I try to start my mysql DB I keep getting the following message:
>>>> "Can't connect to local MySQL server through socket
>>>> '/var/run/mysqld/mysqld.sock'"
>>>>
>>>> Thanks
>>>>
>>>> --
>>>> MySQL General Mailing List
>>>> For list archives: http://lists.mysql.com/mysql
>>>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>>>
>>>>
>>
>>
>>
>>
>
>
Thread
mysqlmadunix@gmail.com23 Aug
  • Re: mysqlAndrew Moore23 Aug
    • Re: mysqlClaudio Nanni23 Aug
      • Re: mysqlAdarsh Sharma23 Aug
        • Re: mysqlmadunix@gmail.com23 Aug
          • Re: mysqlSuresh Kuna23 Aug
            • Re: mysqlmadunix@gmail.com23 Aug