MySQL Bugs: #49095: not able to set up a new server instance

Bug #49095	not able to set up a new server instance
Submitted:	25 Nov 2009 11:48	Modified:	15 Mar 2010 21:55
Reporter:	Susanne Ebrecht	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:		OS:	Linux (Ubuntu)
Assigned to:		CPU Architecture:	Any

Description:
1) install server in your home

$ ./BUILD/compile-amd64-debug-max --prefix=/home/myhome/mysql-5.1 -c
make
make install

$ cd /home/myhome/mysql-5.1
$ mkdir etc
$ cd etc

$ echo -e -n "[mysqld]\nport=6951\nsocket=/tmp/mysql51.sock\n[client]\nport=6951\nsocket=tmp/mysql51.sock" > my.cnf

$ cd /home/myhome/mysql-5.1/libexec
$ -/mysqld --defaults-file=/home/myhome/mysql-5.1/etc/my.cnf &

2) Start Workbench
3) New Server Instance
4) Localhost => NEXT
5) Operating System ...
What the hell shall somebody fill here ....
Ok, Ubuntu Vendor package => NEXT
Test fails with 
Error:

No error is given here => NEXT
SELECT CONNECTION

User: myhome, host:127.0.0.1:6951 (test connection works fine)

=> NEXT
=> NEXT

Path to configuration file: /home/myhome/mysql-5.1/etc/my.cnf => Check path => 
The config file could not be found

Section in configuration file: here I totally failed because I have no clue what I should give here.

=> NEXT

Command to start the MySQL server: /home/myhome/mysql-5.1/libexec/mysqld
Question: Do I have to put --defaults-file=/home/myhome/mysql-5.1/etc/my.cnf or not?
Anyway, doesn't matter

Command to stop the MySQL server: /home/myhome/mysql-5.1/bin/mysqladmin shutdown
=> NEXT

Server Instance Name: bla => NEXT

In the overview: Path to configuration /etc/mysql/my.cnf <= That is not what I filled

Use sudo=YES

I never got a question here about sudo or not. Of course don't use sudo. My user don't has sudo rights at all. Don't try to make something as root or via sudo at all.

Additionally, I didn't found where to set the deamon (mysqld) owner/user. Of course in my example it is not mysql it is myhome.

So where is the system grapping the user for the daemon?

How to repeat:
See above

Suggested fix:
...

I also think this all fails same way when server is remote. Means when start/stop and my.cnf is remote and not in default path.

1) Workbench should work without root or sudo rights
  It does, really. Just uncheck sudo checkbox.
2) Workbench should accept server installed in home
  It does accept. You can edit config files. As for start/stop/status comamnds. For obvious reasons we can not provide them. If you managed to install server in a custom location, so you can put commands how to start and stop it, as well as check server status. Be aware that putting mysqld as a startup command will lock WB and it will terminate server as it is run in fg.
  
For example to check server status one can use: ps -C mysql -o cmd | wba_filter(<some pattern which appears in ps output by which you can uniquely identify your customly installed server>)

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".