Re: mysql.server ignoring my.cnf?

2001-02-27 Thread Sinisa Milivojevic
Joel Gwynn writes: I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql

Re: mysql.server ignoring my.cnf?

2001-02-27 Thread Joel Gwynn
As far as my fuzzy memory of the install process goes, the install_db script made the /etc/mysql directory and put the my.cnf file there. In the my.cnf file, it says # You can copy this to one of: # /etc/mysql/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options

mysql.server ignoring my.cnf?

2001-02-26 Thread Joel Gwynn
I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql starts, it seems to ignore this

mysql.server ignoring my.cnf?

2001-02-26 Thread Joel Gwynn
I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql starts, it seems to ignore this

mysql.server ignoring my.cnf?

2001-02-26 Thread Kent Hoover
Tried /etc/my.cnf in place of /etc/mysql/my.cnf ? Cheers, Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

mysql.server ignoring my.cnf?

2001-02-26 Thread Kent Hoover
Sorry. Sent the last message before I was done If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their contents will override what you have set in /etc/my.cnf. Cheers, Kent - Before posting, please check:

Re: mysql.server ignoring my.cnf?

2001-02-26 Thread Joel Gwynn
I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME are concerned, I don't see them when I do 'printenv'. Is there another way to find out if those may be set, and by what? thanks. At 02:33 PM 2/26/01 -0500, Kent Hoover wrote: Sorry. Sent the last message before I was

Re: mysql.server ignoring my.cnf?

2001-02-26 Thread Kyle Hayes
make sure that you set the sock parameter in both the [client] and [mysqld] sections of the configuration file. This is one of my favorite errors :-/ Best, Kyle On Monday 26 February 2001 12:04, Joel Gwynn wrote: I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME

Re: mysql.server ignoring my.cnf?

2001-02-26 Thread Joel Gwynn
While that is definitely the kind of pinheaded mistake that I'm used to making, that's not what's happening. I just looked at the file again and mysql.server is also ignoring things like the pid file and the log file :( thanks anyway At 12:51 PM 2/26/01 -0800, you wrote: make sure that you

Re: mysql.server ignoring my.cnf?

2001-02-26 Thread Kent Hoover
Joel: I'll take another shot. Do you have spaces in your command? Remove them. Change : socket = /var/run/mysqld/mysqld.sock To: socket=/var/run/mysqld/mysqld.sock Cheers, Kent - Before posting, please