List:General Discussion« Previous MessageNext Message »
From:madunix@gmail.com Date:August 23 2011 10:24am
Subject:Re: mysql
View as plain text  
Thanks Suresh, Problem solved it was the bind address.

On Tue, Aug 23, 2011 at 12:47 PM, Suresh Kuna <sureshkumarilu@stripped> wrote:
> Hello,
>
> Can you comment this line "bind-address            =
> 10.5.1.100" in the
> configuration file and start the mysqld sever.
>
> On Tue, Aug 23, 2011 at 3:10 PM, madunix@stripped <madunix@stripped>
> wrote:
>>
>> [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
>> >>>>
>> >>>>
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>>  http://lists.mysql.com/mysql?unsub=1
>>
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
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