I have a serious error with my server which runs on fedora 9 and mysql 5 which is givingme the following error.....has anyone ever encountered it Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
start mysqld /etc/init.d/mysqld start On Mon, Nov 9, 2009 at 12:32 PM, Steve Muchai <smuchai@gmail.com> wrote:
On Mon, Nov 9, 2009 at 12:29 PM, saich <saiched@gmail.com> wrote: [...]
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
is mysqld running?
BR, S
-- Sent from my socks® _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
yeah it is running..i have restarted but still persistening same errror On Mon, Nov 9, 2009 at 12:35 PM, Chris Mwirigi <mwirigic@gmail.com> wrote:
start mysqld
/etc/init.d/mysqld start
On Mon, Nov 9, 2009 at 12:32 PM, Steve Muchai <smuchai@gmail.com> wrote:
On Mon, Nov 9, 2009 at 12:29 PM, saich <saiched@gmail.com> wrote: [...]
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
is mysqld running?
BR, S
-- Sent from my socks® _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Hi, Are you trying to connect using an IP address or localhost? Try with the IP address if using localhost. On Mon, Nov 9, 2009 at 12:39 PM, saich <saiched@gmail.com> wrote:
yeah it is running..i have restarted but still persistening same errror
On Mon, Nov 9, 2009 at 12:35 PM, Chris Mwirigi <mwirigic@gmail.com> wrote:
start mysqld
/etc/init.d/mysqld start
On Mon, Nov 9, 2009 at 12:32 PM, Steve Muchai <smuchai@gmail.com> wrote:
On Mon, Nov 9, 2009 at 12:29 PM, saich <saiched@gmail.com> wrote: [...]
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
is mysqld running?
BR, S
-- Sent from my socks® _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- Regards, Brian Ngure
seems that your my.cnf is pointing to a location where mysql.sock does not exitst you can either 1. locate mysql.sock and move it to /var/lib/mysql/mysql.sock, be sure to set its ownership and permissions to mysql 2. locate mysql.sock and update your my.cnf with the correct path to mysql.sock Regards On Mon, Nov 9, 2009 at 1:01 PM, Ukang'a Dickson <ukanga@gmail.com> wrote:
On Mon, Nov 9, 2009 at 12:52 PM, Brian Ngure < brian@mystique.boldlygoingnowhere.org> wrote:
Hi,
Are you trying to connect using an IP address or localhost? Try with the IP address if using localhost.
for localhost -> 127.0.0.1 should work
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
1. make sure that xampp is not running (in case you have that too) 2. check that you have mysql and mysql-server installed (yum install mysql mysqlserver) most people forget to install mysql-server after installing mysql 3. if your database does not have data, erase mysql and mysql-server then install them again. -- with Regards: Get your free technology e-magazine in pdf format: Tekniaonline: http://bit.ly/tekniaonline-2 A Campus Perspective, Comically wrapped in Satire : http://gramware.blogspot.com
participants (6)
-
Brian Ngure -
Chris Mwirigi -
Dennis Kioko -
saich -
Steve Muchai -
Ukang'a Dickson