Link to home
Create AccountLog in
Avatar of fosiul01
fosiul01Flag 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

Avatar of blue_hunter
blue_hunter
Flag of Malaysia image

You may change the cursor

mysql>
into
somethings like

server1>

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.
Avatar of fosiul01

ASKER

thats a idea ...

how to do that ??
but can it be done automatically just after loggin ??

ASKER CERTIFIED SOLUTION
Avatar of blue_hunter
blue_hunter
Flag of Malaysia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account