Re: How to modify the

Le 10/09/2019 14:38, Lew Pitcher a écrit :
> ZOT wrote:
>
>> command prompt?
>> I am using several database servers and it's a bit confusing having them
>> all indicating:
>> MariaDB [mysql]>
>>
>> Is there a way to modify the 'MariaDB' to something reflecting the
>> machine it's running on?
>> something like
>> Server2 [mysql]
>> ?
>> Many thanks
>
> Use the
> prompt
> command, and see
> https://mariadb.com/kb/en/library/mysql-command-line-client/#prompt-command
> for the appropriate options
>
> For example:
> MariaDB [mysql]> prompt \h:\t
> PROMPT set to '\h:\t'
> localhost:
>
Many thanks, it work.
I have placed this in my .my.cnf
[mysql]
prompt=\h [\d]:

and it work!
Thanks again.
Andre

-- 
Les politiciens sont imprévoyants, les électeurs sans mémoire.