List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:August 23 2011 9:47am
Subject:Re: mysql
View as plain text  
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