Avatar of fosiul01
fosiul01
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Can you add your own Comments in mysql startup ??

Hi
when you type, username and passwrod in mysql ..

mysql -uroot -ppassword

then we get bellow screen


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>



is there any way to insert some additional comments in their ??



reason : we have 3 mysql instances running in one server, I dont want my user to get confused in mysql console .. so it would be really handly if i can insert some extra information into that console .. like :

"This Mysql is only for Slave2"


please let me know if this is possible.

thanks

MySQL Server

Avatar of undefined
Last Comment
blue_hunter

8/22/2022 - Mon
blue_hunter

You may change the cursor

mysql>
into
somethings like

server1>

blue_hunter

check out this link
http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html

after the line as below, check on how you can setup the "prompt"

The prompt command reconfigures the default mysql> prompt. The string for defining the prompt can contain the following special sequences.
fosiul01

ASKER
thats a idea ...

how to do that ??
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
fosiul01

ASKER
but can it be done automatically just after loggin ??

ASKER CERTIFIED SOLUTION
blue_hunter

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question