[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: Re: mysql
From: Suresh Kuna <sureshkumarilu () gmail ! com>
Date: 2011-08-23 9:59:48
Message-ID: CAFoB9SpyBSuMyyMWSq4GLxx-dik2B2+StqXCCVvoWm=ut7SnEA () mail ! gmail ! com
[Download RAW message or body]
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@gmail.com <madunix@gmail.com>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@orkash.com> 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@gmail.com>
> >>
> >>
> >>>
> >>> 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@gmail.com" <madunix@gmail.com>
> 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=eroomydna@gmail.com
> >>>>
> >>>>
> >>
> >>
> >>
> >>
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumarilu@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic