Hi I hope someone can help! I've been working on this a solid 2 days.
background info:
System: PII IBM PC300GL with 64 MB RAM and 8 GB hard disk
OS: Mandrake Linux 10.0, kernel 2.6.something
MySQL 4.0.4 that I installed off the Mandrake CD from RPMs.
I have MySQL-client, MySQL-server and MySQL-bench RPMs installed.
I type ./mysql.server start and get [ OK ] response.
I type mysqld_safe --user=mysql & and get "starting with databases ..." (whatever, but it looks like its running).
ps | grep mysqld returns about 20 entries.
So, I guess the server is running properly.
Now, when I type "mysqladmin version" I get this:
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
(according to find, no file with .sock exists on the machine). I tried creating it with vi and touch, and they disappear immediately. Go figure?!?
So I tried bunch of things, ran the mysql_db command to initialise the grants. Didn't help. Rebooted the machine, didn't help. Tried "telnet localhost 3306" and got "telnet: Unable to connect to remote host: Connection refused". "netstat -l | grep mysql" returns nothing.
Why isn't this socket thing working? I also copied my-small.cnf to /etc/my.cnf and in there it says to use socket /var/lib/mysql/mysql.sock, but as I stated, it doesn't exist and can't be created.
What's going on and how can I get this to work??
Thanks in advance.