Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

[Edwin Raj]

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