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 ??

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.


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.


Avatar of blue_hunter
Flag of Malaysia image

You may change the cursor

somethings like


check out this link

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


thats a idea ...

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

Avatar of blue_hunter
Flag of Malaysia image

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