Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Special character in database.yml for password

Tags:

mysql

yaml

ruby-on-rails

I have my database password starting with a '*'. When i put this on my production server i get following error:

- syntax error on line 17, col 25: ` password: *---------'.Exception class:ArgumentError.

Thanks, Anubhaw

like image 901
Anubhaw Avatar asked Sep 14 '10 04:09

Anubhaw

People also ask

Does YAML accept special characters?

Use quotes in YAML if your value includes special characters. For example, these special characters may require quotes: {, }, [, ], ,, &, :, *, #, ?, |. -, <. >, =, !, %, @, \. It is not necessary to use quotes when a single special character is surrounded by spaces, for example, * with spaces on both sides.

How do you escape the special characters in YAML?

How do you escape quotes in YAML? In single quoted strings the single quote character can be escaped by prefixing it with another single quote, basically doubling it. Backslashes in single quoted strings do not need to be escaped.

1 Answers

The asterisk (*) has special meaning in YAML. Try using a quoted scalar:

password: '*-------'
like image 117
NullUserException Avatar answered Oct 02 '22 20:10

NullUserException
Sign in to Comment

Related questions

MySQL 8: ER_NOT_SUPPORTED_AUTH_MODE [duplicate]
How to get date from week number and day in sql?
Switch from JsonStringType to JsonBinaryType when the project uses both MySQL and PostgreSQL
Cannot convert from 'string' to 'Microsoft.EntityFrameworkCore.ServerVersion
How to download a live MySQL db into a local test db on demand, without SSH?
SQL Recursive Tables
How do I maintain PHP sessions across multiple domains on the same server?
How to model a Bayesian network or, more generally, a directed weighted graph, in SQL?
Sql date select rows within X seconds range of each other
iconv gives "Illegal Character" with smart quotes -- how to get rid of them?
For innodb table in MySQL, which is faster: varchar(255) or tinytext?
Using SUM so that NULL in columns make sum NULL
Java Exception Error - Sqlite preparedStatement.setBlob
MySQL Fulltext Stopwords Rationale
Any way to view ALTER TABLE after its been executed? -MySQL
In MATLAB can I convert a java boolean to a MATLAB logical?
SQL Replace Into question
Generate unique random alphanumeric characters that are 7 characters long
Does a transaction stop all race condition problems in MySQL?
binary log files analysis

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!