Hi,

I'm new to both MySQL and Linux (Ubuntu), and having come from a Microsoft
(Windows/SQL Server) background am finding even trivial operational issues
tough to overcome. Surprisingly Google doesn't help since all pages seem to
assume some level of Linux/MySQL experience already.

Assuming this is the best place to ask:

1) How do I use SQL Administrator to edit startup parameters? It says that
the file is not writable. I've previously used sudo with an editor to do
make a change (specifically the IP binding). Am I missing the point? Are you
not supposed to use Administrator to make these changes? Why is it there
then?

2) Since I'm running my development server on VMWare (with a Windows host -
not quite ready to cut Windows out of my life right yet!) MySQL doesn't seem
to be able to start with a valid IP binding (or something) while Linux is
booting. In short I have to restart MySQL on each reboot by going to
System->Admin->Services and unchecking and rechecking the relevant MySQL
service - there are three mysql, mysql-ndb, mysql-ndb-mgr. What are they all
for? Is there a better way to do this?

3) What's the difference between MySqld and MySqld_safe in the config file?
Where should I make changes?

4) Why does "SHOW VARIABLES LIKE 'lower_case_table_names'" return 0 when in
SQL Administrator mysql_safe says it's set to 1?

Apologies in advance for the trivial questions - I'd like to stick to Linux
and MySQL for development so hopefully these are just teething issues.

Shak

On Mon, 9 Jun 2008 19:55:08 +0100, Shak wrote:
> Hi,
>
> I'm new to both MySQL and Linux (Ubuntu), and having come from a Microsoft
> (Windows/SQL Server) background am finding even trivial operational issues
> tough to overcome. Surprisingly Google doesn't help since all pages seem to
> assume some level of Linux/MySQL experience already.
>
> Assuming this is the best place to ask:
>
> 1) How do I use SQL Administrator to edit startup parameters? It says that
> the file is not writable. I've previously used sudo with an editor to do
> make a change (specifically the IP binding). Am I missing the point? Are you
> not supposed to use Administrator to make these changes? Why is it there
> then?

Start SQL Administrator with sudo. Then it'll have the magic powers to
do unspeakable things to the config files, just like your editor got its
unspeakable powers when you did it that way.

--
"'I'm not sleeping with a jr. high schooler! I have a life-sized doll that
looks like one.' Uh huh. That sounds SO much less pathetic."
-- Piro's Conscience www.megatokyo.com