I would like to change the prompt to my mariadb or mysql client.
I would like the prompt to be the contain of a variable like report_host or more, to something that can change like default_master_connection.
Does someone know how to do it?
MySQL MariaDB – Setting Prompt to a Variable
mariadbMySQL
Related Solutions
A mixture of the mysql/mariadb-Nameing has worked for me:
export DEBIAN_FRONTEND=noninteractive
debconf-set-selections <<< 'mariadb-server-5.5 mysql-server/root_password password rootpass'
debconf-set-selections <<< 'mariadb-server-5.5 mysql-server/root_password_again password rootpass'
Yes, all the basic optimizations in MySQL 5.5 apply to MariaDB 5.5.
However, starting with MariaDB 10, a real fork, not all improvements in 5.6 are in MariaDB codebase, and alternatively, MariaDB has some exclusive features (Hash JOINS). For now, those are not too different, that may change in the future. For a book, where most of the optimizations are regarding basic indexing, it may not be very relevant.
And you can always check the latest improvements online -blogs, wikis. This is a presentation I created for the newest MySQL 5.6 query optimizations techniques.
Have a look at this image for a visual representation (white zones are MariaDB-only). 5.6- and 5.7-only are not represented:
Related Question
- MariaDB – Cannot Set max_connections and wait_timeout in my.cnf
- MariaDB – How to Set Prompt for MariaDB 10.2 in my.cnf
- How to Clone Database in MariaDB Prompt Character
- Mysql: set variable in thesqldump
- MariaDB – Handling Warnings for Empty User Defined Variables
- Mysql – Multiple versions of thesql / mariadb
Best Answer
AFAIK MySQL prompt cannot be set to MySQL variables (Global or Session). The only options that can be used are documented at https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html (look towards the end of the documentation page for a full list).