Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
Vince LaMonica wrote: On Fri, 15 Nov 2002, Edwin Raj wrote: } [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password } 'simple' } /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed } error: 'Can't connect to local MySQL server through socket } '/tmp/mysql.sock' (111)' } Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Looks like the error message is pretty clear - mysqld is not running. MySQL is a client/server application - there is a server that needs to run, and then the client can connect to that server. You need to make sure that mysqld is running. Since it appears you're on a linux box, you can run this command: ps aux |grep mysql [Edwinraj@edwinraj Edwinraj]$ ps aux | grep mysql root 1176 0.0 0.0 1676 0 ? SW 11:27 0:00 [safe_mysqld] mysql 1200 0.0 0.0 10572 36 ? S 11:27 0:00 [mysqld] mysql 1202 0.0 0.0 10572 36 ? S 11:27 0:00 [mysqld] mysql 1203 0.0 0.0 10572 36 ? S 11:27 0:00 [mysqld] Edwinraj 1826 0.0 0.8 1360 516 pts/1 S 15:13 0:00 grep mysql So I assume the server is running If nothing comes up, then you need to start mysqld. It may reside in /usr/sbin. You should probably check the MySQL manual: http://www.mysql.com/doc/en/Post-installation.html Yes went through it and this is what I get [root@edwinraj mysql]# ./scripts/mysql_install_db Installing all prepared tables 021115 16:06:37 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h edwinraj.naturesoft.com password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com and also [root@edwinraj mysql]# ./bin/safe_mysqld --user=mysql [1] 1953 [root@edwinraj mysql]# Starting mysqld daemon with databases from /usr/local/mysql-3.23.52-pc-linux-gnu-i686/data 021115 16:07:31 mysqld ended Any ideas Thanks for the reply Edwin HTH, /vjl/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
Hello Friends, I have installed mysql version 3.23.52 binary file. The installation went well without any errors but when I type mysql in the command prompt I get this error. Can someone help me fix this. Am using red hat 6.2 version Rgds Edwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
If this could help to analyse the problem, when I try to create a password this is the message I get [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password 'simple' /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Edwin Raj wrote: Hello Friends, I have installed mysql version 3.23.52 binary file. The installation went well without any errors but when I type mysql in the command prompt I get this error. Can someone help me fix this. Am using red hat 6.2 version Rgds Edwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (111)
On Fri, 15 Nov 2002, Edwin Raj wrote: } [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password } 'simple' } /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed } error: 'Can't connect to local MySQL server through socket } '/tmp/mysql.sock' (111)' } Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Looks like the error message is pretty clear - mysqld is not running. MySQL is a client/server application - there is a server that needs to run, and then the client can connect to that server. You need to make sure that mysqld is running. Since it appears you're on a linux box, you can run this command: ps aux |grep mysql If nothing comes up, then you need to start mysqld. It may reside in /usr/sbin. You should probably check the MySQL manual: http://www.mysql.com/doc/en/Post-installation.html HTH, /vjl/ -- Vince LaMonica UC Irvine, School of Social Ecology W3 Developer * 116 Social Ecology I, Irvine, CA 92697 [EMAIL PROTECTED] http://www.seweb.uci.edu/techsupport No matter what happens, somebody will find a way to take it too seriously. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php