Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf before it starts talking to
the server, and it can read any my.cnf file it likes. There's no way
you can mandate that a single my.cnf file gets used for both the server
and any client session connecting to it.
Instead of running mysql(1) directly, I'd run it via one of three
scripts, each of which sets up its environment so as to force mysql(1)
to read a different my.cnf file in each case. This will also let you
hard-code other information about each particular server that isn't
important to keep secret, like the login name and the DB name.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
