Description:
The server does not honor ~/.my.cnf file if there are /etc/mysql/my.cnf
How to repeat:
Have a configuration in /etc/mysql/my.cnf
Have another configuration in ~/.my.cnf
Start the server:
$ ./sql/mysqld
100621 12:48:30 [Warning] One can only use the --user switch if running as root
100621 12:48:30 [Note] Buffered information: Performance schema disabled (reason: start parameters).
100621 12:48:30 [Note] Plugin 'FEDERATED' is disabled.
100621 12:48:30 [Note] Plugin 'ndbcluster' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
100621 12:48:31 InnoDB: highest supported file format is Barracuda.
100621 12:48:31 InnoDB 1.1.1 started; log sequence number 1595675
100621 12:48:31 [ERROR] ./sql/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
100621 12:48:31 [ERROR] Can't start server: can't create PID file: No such file or directory
Start the server explicilty with ~/.my.cnf:
./sql/mysqld --defaults-file=~/.my.cnf
100621 12:53:17 [Note] Buffered information: Performance schema disabled (reason: start parameters).
100621 12:53:17 [Note] Plugin 'FEDERATED' is disabled.
100621 12:53:17 [Note] Plugin 'ndbcluster' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
100621 12:53:17 InnoDB: highest supported file format is Barracuda.
100621 12:53:17 InnoDB 1.1.1 started; log sequence number 1595675
100621 12:53:18 [Note] Event Scheduler: Loaded 0 events
100621 12:53:18 [Note] ./sql/mysqld: ready for connections.
Version: '5.5.5-m3-debug' socket: '/home/alik/MySQL/var/mysql-trunk-bugfixing/mysqld.socket' port: 3307 Source distribution
