Description:
Manage server instance -> New -> server4 -> choose connection (TCP/IP, 127.0.0.1, root). Update System Profile -> update
Mysql start up -> /home/nidhi/mysql-builds/mysql-5.1/bin/mysqld_safe --defaults-file=/etc/my.cnf
Mysql stop -> /home/nidhi/mysql-builds/mysql-5.1/bin/mysqladmin --user=root --socket=/tmp/mysql.sock shut
Check Mysql status -> Leave blank.
Now go to Server Administration -> choose server4 -> 'shows server is not running' -> click on Start Server -> starts server as seen below
nidhi@nidhi-laptop:~/mysql-builds/mysql-5.1$ ps -aef|grep mysql
nidhi 24053 6729 0 16:33 pts/1 00:00:00 /bin/bash /usr/bin/mysql-workbench
nidhi 24057 24053 0 16:33 pts/1 00:00:00 /bin/sh /usr/bin/catchsegv /usr/bin/mysql-workbench-bin
nidhi 24059 24057 5 16:33 pts/1 00:00:37 /usr/bin/mysql-workbench-bin
nidhi 24061 1 0 16:33 pts/1 00:00:00 /usr/bin/python /usr/share/mysql-workbench/sshtunnel.py
nidhi 28161 24059 0 16:45 pts/2 00:00:00 /bin/bash -c /home/nidhi/mysql-builds/mysql-5.1/bin/mysqld_safe --defaults-file=/etc/my.cnf 2>&1 > /tmp/tmpgTSUSG; echo CMDRESULT$? >> /tmp/tmpgTSUSG
nidhi 28162 28161 0 16:45 pts/2 00:00:00 /bin/sh /home/nidhi/mysql-builds/mysql-5.1/bin/mysqld_safe --defaults-file=/etc/my.cnf
nidhi 28207 28162 1 16:45 pts/2 00:00:00 /home/nidhi/mysql-builds/mysql-5.1/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/home/nidhi/mysql-builds/mysql-5.1 --datadir=/home/nidhi/mysql-builds/mysql-5.1/var --log-error=/home/nidhi/mysql-builds/mysql-5.1/var/nidhi-laptop.err --pid-file=/home/nidhi/mysql-builds/mysql-5.1/var/nidhi-laptop.pid
But the log says :
--------------------------
2009-12-18 16:45:01 - Trying to start server...
2009-12-18 16:45:32 - Could not open required defaults file: /etc/my.cnf
Fatal error in defaults handling. Program aborted
WARNING: Defaults file '/etc/my.cnf' not found!
Could not open required defaults file: /etc/my.cnf
Fatal error in defaults handling. Program aborted
WARNING: Defaults file '/etc/my.cnf' not found!
2009-12-18 16:45:32 - Checking server status: Server is stopped.
still shows server is stopped and Start server button, so you can't stop it.
All other tabs show 'server is not running'
How to repeat:
As mentioned in description.
