I did discover that I had not set a user in /etc/my.cnf. Once I did that, the mysql.sock "file" was set up (doh! sorry about that).
Here's a portion of what I get when I do ls -l /var/lib/mysql (I'm omitting a bunch of mail-bin files):
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 21880
drwx------ 2 mysql mysql 4096 Nov 14 2002 9-5USA
-rw-rw---- 1 mysql mysql 25088 Jun 19 17:17 ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 10485760 Jun 19 17:17 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Jun 27 13:54 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 19 17:17 ib_logfile1
-rw-r--r-- 1 mysql mysql 46031 Jun 27 14:08 mail.9-5usa.org.err
-rw-rw---- 1 mysql mysql 4 Jun 27 13:54 mail.9-5usa.org.pid
-
-----
drwx------ 2 mysql mysql 4096 Nov 4 2002 mysql
srwxrwxrwx 1 mysql mysql 0 Jun 27 13:54 mysql.sock
drwx------ 2 mysql mysql 4096 Nov 4 2002 test
[EMAIL PROTECTED] root]#
Here are some portions of my /etc/my.cnf file:
[client] #password = your_password port = 3308 socket = /var/lib/mysql/mysql.sock user = root
# The MySQL server [mysqld] port = 3308 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8
I haven't really done anything to the file except add the root user and change the port from 3306 to 3308.
If I just type "mysql" at a shell prompt I get:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.13-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
The mysql daemon seems to have permissions set for root/root:
[EMAIL PROTECTED] root]# ls -l /usr/bin/mysqld_safe
-rwxr-xr-x 1 root root 9915 Jun 23 15:43 /usr/bin/mysqld_safe
[EMAIL PROTECTED] root]# ls -l /usr/libexec/mysqld
-rwxr-xr-x 1 root root 3202080 Jun 23 15:43 /usr/libexec/mysqld
[EMAIL PROTECTED] root]# ls -l /var/run/mysqld
total 0
[EMAIL PROTECTED] root]# ls -l /etc/rc.d/init.d/mysqld
-rwxr-xr-x 1 root root 1772 Jun 23 15:43 /etc/rc.d/init.d/mysqld
I hope this information helps. I know that I'm in 'way over my head!!!
Thanks very much to all who have responded. By the way, I wasn't sure which person was meant when referring to an e-mail message that had been bounced from a server. If it was from my server, please let me know; that may be something else I need to look into!
Kevin
John Nichel wrote: > What's the permissions on the /var/lib/mysql directory, and what > user/group is the mysql daemon set to run as in your my.cnf file? > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
