Hi,
I have been used MySQL on Windows no problem. Now we start to use non-RPM Linux.
I installed MySQL followed manual. But the fact is different than manual told.
My problem is: if I put my.cnf in /etc/ dir, the socket file is always generated in /tmp/,
named mysql.sock. But when client try to connect to server, get message "Cannot connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock'. Even though in my.cnf
setup
socket file=/var/run/mysqld/mysqld.sock or start option setup to
that dir. But the server works fine, generates binary log file at that time.
If I put my.cnf in /etc/mysql/ dir, after start the server, although client is able to
connect to server at this setting, but there is no binary log file generated from server
any more.
Any one has success configured server, could you let me know what I can do or let me know:
1) Where do you put your my.cnf file?
2) Where do you setup socket file dir in your my.cnf? (in all 3 sections: mysql, mysqld,
client)
3) How do you start server (use mysql.server or mysqld_save) if it has affect?
Thanks advance,
Lisa
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ