On 21Mar2007 22:12, Uno Engborg <uno@xxxxxxxxxxx> 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@xxxxxxxxxx> 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
