Hi, Have you done a $ ps aux | grep mysql and checked the daemon is running? It sounds as if it hasn't started. If not, then you need to check the mysql log. It is probably in /var/log/mysqld.log or somewhere similar. You can look up the errors at http://dev.mysql.com/doc/mysql/en/index.html This is a most comprehensive manual and should get you going.
It may be that your /etc/my.cnf file has a different socket specified and the client (mysqladmin) is trying to use the default. Check your my.cnf file for the following line port = 3306 socket = /tmp/mysql.sock <------------------------------------ skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 8M thread_cache = 8 query_cache_size= 16M Yours may say something different. You can change it to /tmp/mysql.sock and restart the server and things should work. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: ganesan malairaja [mailto:[EMAIL PROTECTED] Sent: Monday, 9 May 2005 5:24 PM To: mysql@lists.mysql.com Subject: help .. setting up mysql i follow instruction from the http://www.linuxhelp.net/guides/lamp/ to install mysql i followed the steps but i get this error when i reach the testing phase.. can anyone help me.. i have trouble setting up the mysql server for almost 4 days.. every time of some error .. maybe this because i am still new to linux i am using suse 9.3 and mysql-standard-4.1.11-pc-linux-gnu-i686.tar.gz this is the error linux:/usr/local/src/mysql-standard-4.1.11-pc-linux-gnu-i686 # mysqladmin version 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! linux:/usr/local/src/mysql-standard-4.1.11-pc-linux-gnu-i686 # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) thank you guys -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
