mysql
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=arch...@jab.org
Re: mysql
se 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 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 >> >> >>> >>> 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" 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=arch...@jab.org
Re: mysql
Thanks Suresh, Problem solved it was the bind address. On Tue, Aug 23, 2011 at 12:47 PM, Suresh Kuna 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, 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 attemptin
crash recovery
Hi, Lately I got this messgae in my errorLog file, need more datails why the DB was restarted! 120711 19:42:06 mysqld restarted 120711 19:42:06 [Warning] Asked for 196608 thread stack, but got 126976 120711 19:42:07 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 120711 19:42:07 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 4 4031987031. InnoDB: Doing recovery: scanned up to log sequence number 4 4031987031 InnoDB: Last MySQL binlog file position 0 78062804, file name ./sdc-bin.97 120711 19:42:07 InnoDB: Flushing modified pages from the buffer pool... 120711 19:42:07 InnoDB: Started; log sequence number 4 4031987031 /usr/sbin/mysqld: ready for connections. Version: '4.1.14-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) -mad
