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:ssganesan@stripped]
Sent: Monday, 9 May 2005 5:24 PM
To: mysql@stripped
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/mysql?unsub=1
