[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: Re: mysql
From: "madunix () gmail ! com" <madunix () gmail ! com>
Date: 2011-08-23 10:24:08
Message-ID: CAMc13vC_eKELa_iq8usf-SPgPpTxMCustFnYLpvXjUPCj0Rofg () mail ! gmail ! com
[Download RAW message or body]
Thanks Suresh, Problem solved it was the bind address.
On Tue, Aug 23, 2011 at 12:47 PM, Suresh Kuna <sureshkumarilu@gmail.com> 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@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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic