mysql

mysql

am 23.08.2011 10:18:42 von madunix

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=gcdmg-mysql-2@m.gmane.org

Re: mysql

am 23.08.2011 10:31:30 von Andrew Moore

--20cf30050c2ebcbe9f04ab280570
Content-Type: text/plain; charset=ISO-8859-1

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" 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
>

--20cf30050c2ebcbe9f04ab280570--

Re: mysql

am 23.08.2011 10:36:55 von Claudio Nanni - TomTom

--20cf307d003e25f93204ab281984
Content-Type: text/plain; charset=ISO-8859-1

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, "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
> >
>



--
Claudio

--20cf307d003e25f93204ab281984--

Re: mysql

am 23.08.2011 10:55:35 von Adarsh Sharma

--------------020803040307010702080204
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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, "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
>>>
>>>
>
>
>
>


--------------020803040307010702080204--

Re: mysql

am 23.08.2011 11:40:41 von madunix

[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
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, "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=gcdmg-mysql-2@m.gmane.org

Re: mysql

am 23.08.2011 11:47:48 von sureshkumarilu

--20cf303a2cb5a7522404ab2916e2
Content-Type: text/plain; charset=ISO-8859-1

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 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
> 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, "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

--20cf303a2cb5a7522404ab2916e2--

Re: mysql

am 23.08.2011 12:24:08 von madunix

Thanks Suresh, Problem solved it was the bind address.

On Tue, Aug 23, 2011 at 12:47 PM, Suresh Kuna wr=
ote:
> Hello,
>
> Can you comment this line "bind-address         =C2=
=A0  =3D 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
> wrote:
>>
>> [client]
>> port            =3D 3306
>> socket          =3D /var/run/mysqld/mysqld.sock
>> #socket         =3D /tmp/mysqld.sock
>> user            =3D "root"
>> pass            =3D "%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          =3D /var/run/mysqld/mysqld.sock
>> #socket         =3D /tmp/mysqld.sock
>> nice            =3D 0
>>
>> [mysqld]
>> #
>> # * Basic Settings
>> #
>>
>> #
>> # * IMPORTANT
>> #   If you make changes to these settings and your system uses appa=
rmor,
>> you may
>> #   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
>> #
>>
>> user            =3D mysql
>> socket          =3D /var/run/mysqld/mysqld.sock
>> #socket         =3D /tmp/mysqld.sock
>> port            =3D 3306
>> basedir         =3D /usr
>> datadir         =3D /var/lib/mysql
>> tmpdir          =3D /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            =3D 10.5.1.100
>> #bind-address            =3D 0.0.0.0
>> #
>> # * Fine Tuning
>> #
>> key_buffer              =3D 16M
>> max_allowed_packet      =3D 16M
>> thread_stack            =3D 192K
>> thread_cache_size       =3D 8
>> # This replaces the startup script and checks MyISAM tables if needed
>> # the first time they are touched
>> myisam-recover         =3D BACKUP
>> #max_connections        =3D 100
>> #table_cache            =3D 64
>> #thread_concurrency     =3D 10
>> #
>> # * Query Cache Configuration
>> #
>> query_cache_limit       =3D 1M
>> query_cache_size        =3D 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        =3D /var/log/mysql/mysql.lo=
g
>> #general_log             =3D 1
>>
>> log_error                =3D /va=
r/log/mysql/error.log
>>
>> # Here you can see queries with especially long duration
>> #log_slow_queries       =3D /var/log/mysql/mysql-slow.log
>> #long_query_time =3D 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 abo=
ut
>> #       other settings you may need to change.
>> #server-id              =3D 1
>> #log_bin                   =
     =3D /var/log/mysql/mysql-bin.log
>> expire_logs_days        =3D 10
>> max_binlog_size         =3D 100M
>> #binlog_do_db           =3D include_database_na=
me
>> #binlog_ignore_db       =3D 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 =3D /var/lib/mysql/
>> #
>> # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
>> #
>> # ssl-ca=3D/etc/mysql/cacert.pem
>> # ssl-cert=3D/etc/mysql/server-cert.pem
>> # ssl-key=3D/etc/mysql/server-key.pem
>>
>>
>>
>> [mysqldump]
>> quick
>> quote-names
>> max_allowed_packet      =3D 16M
>>
>> [mysql]
>> #no-auto-rehash # faster start of mysql but no tab completition
>>
>> [isamchk]
>> key_buffer              =3D 16M
>>
>> #
>> # * IMPORTANT: Additional settings that can override those from this fil=
e!
>> #   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=3Dauto mysql
>> root@server1:/var/run/mysqld# ps -ef | grep mysqld
>> root     17022  6569  0 12:15 pts/1    00:=
00:00 grep --color=3Dauto 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
>> 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, "madunix@gmail.com"
>> >>> wrote:
>> >>>
>> >>>>
>> >>>> When I try to start my mysql DB I keep getting the following messag=
e:
>> >>>> "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=3Deroomydna@gmail.com
>> >>>>
>> >>>>
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>>  http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gm ail.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=3Dgcdmg-mysql-2@m.gmane.o rg