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, madu...@gmail.com <madu...@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.sha...@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 <eroomy...@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, "madu...@gmail.com" <madu...@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=eroomy...@gmail.com > >>>> > >>>> > >> > >> > >> > >> > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com > > -- Thanks Suresh Kuna MySQL DBA