Getting started with MySQL Limit and Offset Creating databases Backup using mysqldump Table Creation INSERT Error codes Stored routines (procedures and functions)Reserved Words String operations DELETE VIEW Indexes and Keys Date and Time Operations Comment Mysql LOAD DATA INFILE PREPARE Statements ALTER TABLE Joins UPDATE Change Password JSON MySQL Admin TRIGGERS Pivot queries Configuration and tuning Converting from MyISAM to InnoDB SELECT Create New User Group By UNION Drop Table Data Types Performance Tuning Events ENUM Install Mysql container with Docker-Compose Arithmetic Character Sets and Collations MyISAM Engine Many-to-many Mapping table Using Variables Log files Partitioning Clustering Security via GRANTs Backticks mysqlimport MySQL LOCK TABLE MySQL Unions ORDER BY MySQL client Mysql Performance Tips Temporary Tables Transaction Customize PS1 Dealing with sparse or missing data Dynamic Un-Pivot Table using Prepared Statement NULL Replication Connecting with UTF-8 Using Various Programming language.SSL Connection Setup Handling Time Zones Time with subsecond precision Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...Full-Text search Extract values from JSON type Regular Expressions Recover and reset the default root password for MySQL 5.7+One to Many JOINS: Join 3 table with the same name of id.Server Information Recover from lost root password

Customize PS1

Customize the MySQL PS1 with current database

In the .bashrc or .bash_profile, adding:

export MYSQL_PS1="\u@\h [\d]>"

make the MySQL client PROMPT show current user@host [database].

Custom PS1 via MySQL configuration file

In mysqld.cnf or equivalent:

[mysql]
prompt = '\u@\h [\d]> '

This achieves a similar effect, without having to deal with .bashrc's.

Contributors

Topic Id: 5795

Example Ids: 20414,24831

This site is not affiliated with any of the contributors.