MySQL Bugs: #49580: Can't start server from within workbench

Bug #49580	Can't start server from within workbench
Submitted:	10 Dec 2009 11:29	Modified:	22 Jan 2010 15:04
Reporter:	Nidhi Shrotriya	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.10, 5.2.14	OS:	Linux (ubuntu 9.04, 9.10)
Assigned to:		CPU Architecture:	Any

Description:
Manage server instances -> New
server1 -> 
connection1 (TCP/IP, 127.0.0.1, 3307, root, nidhi)
System Profile -> Leave the defaults (/etc/my.cnf)

Server administration -> server1 -> ok -> server is not running

Configuration tab -> update as 
port 3307
basedir /home/nidhi/mysql-builds/mysql-5.1
datadir /home/nidhi/mysql-builds/mysql-5.1/data

Apply the changes to /etc/my.cnf.

Go to start server tab -> Start server -> asks super user password -> given 

doesn't start the server. 

How to repeat:
As mentioned in the description.

This looks like something is wrong with you setup.

I would bet there is /home/nidhi/mysql-builds/mysql-5.1/etc/my.cnf

Anyway, please try to start server manually by the command you configured in Workbench.

My gut feeling is this will fail too.

So first try to start the server via console and after you got this done try the same command via Workbench again and let us know if it works or not.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I am still able to reproduce this with 5.2.14 on Ubuntu 9.10. I can use the same commands to start/stop server from outside workbench. Can stop the same from inside workbench but start doesn't work.

Server is running as :
----------------------
nidhi@nidhi-laptop:~/mysql-builds/mysql-5.1.41$ bin/mysqld_safe --no-defaults --port=3308 &
[1] 2688
~/mysql-builds/mysql-5.1.41$ ./bin/mysqladmin -u root password 'nidhi' --socket=/tmp/mysql.sock

Workbench Home-> Manage server instances -> create new server instance as server1 with connection as

conn1
TCP/IP 
Host 127.0.0.1, 
Port 3308
Username : root
password: nidhi

System Profile:
---------------------
Profile template ->Custom
Configuation file -> empty (removed)
Section in config file -> empty (removed)

Start mysql -> home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld_safe --no-defaults --port=3308 &
Stop mysql -> /home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqladmin --host=127.0.0.1 --port=3308 --user=root --password='nidhi' shutdown

Use sudo to execute start/stop -> unchecked 
close

Go to Server Administration -> server1-> 'Server is not running' -> startup tab -> click 'start server' ----doesn't start the server

Start the server with same command copied from System Profile outside workbench ----server started and seen as 'running inside workbench 

click on 'stop server' works from inside workbench, but start server doesn't.

nidhi@nidhi-laptop:~/mysql-builds/mysql-5.1.41$ bin/mysqld_safe --no-defaults --port=3308
&
[1] 2688
~/mysql-builds/mysql-5.1.41$ ./bin/mysqladmin -u root password 'nidhi'
--socket=/tmp/mysql.sock

In Workbench you need to use the whole path.

In your example:

/home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld_safe --no-defaults --port=3308

and

/home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqladmin -u root password 'nidhi'
--socket=/tmp/mysql.sock

Susanne,

Offcourse, the whole path was used in workbench (as very clearly mentioned in my updates. Please have a look under 'System Profile' in my updates). The relative path was used under 'Server is running:', which clearly meant that it was started from outside to show that I am able to do it from outside workbench (as was asked by you). Wasn't it obvious ?

Start mysql -> home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld_safe --no-defaults
--port=3308 &
Stop mysql -> /home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqladmin --host=127.0.0.1 --port=3308 --user=root --password='nidhi' shutdown

Closing as it(full path) works with 'mysqld' (not with mysqld_safe) and with also specifying --datadir and --basedir 
/home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld --no-defaults --datadir=/home/nidhi/mysql-builds/mysql-5.1.41/data --basedir=/home/nidhi/mysql-builds/mysql-5.1.41 --port=3308