Defaults for the mysql client

[Cameron Simpson]

On 21Mar2007 22:12, Uno Engborg <uno at webworks.se> wrote:
| Is it possible to set a user's default database for MySQL database?
| Instead of having an additional line of command, i.e:
| mysql> use database <database_name>
| the user should just type mysql and directly end up in the right database.
| the configuration should include database and password
| The reason I want this is that I want tobe able to create a login that 
| uses mysql
| as shell to allow for easy access to  a certain database.

Well, you can put the initial db on the command line:

  mysql database_name

so just make the initial shell a tiny shell script that runs mysql with
the right db name.
-- 
Cameron Simpson <cs at zip.com.au> DoD#743
http://www.cskk.ezoshosting.com/cs/

The ten thousand things
How long do any persist?
Netscape, too, has gone.
- Haiku Error Messages http://www.salonmagazine.com/21st/chal/1998/02/10chal2.html