# Help with MySQL and YAML

**URL:** <https://www.ruby-forum.com/t/help-with-mysql-and-yaml/114909>\
**Category:** Rails\
**Created:** [September 18, 2007, 7:06pm UTC](https://www.ruby-forum.com/t/help-with-mysql-and-yaml/114909 "2007-09-18T19:06:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rubynut](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/8e8cbc/32.png) [@rubynut](https://www.ruby-forum.com/u/rubynut)\
**Post date:** [September 18, 2007, 7:06pm UTC](https://www.ruby-forum.com/t/help-with-mysql-and-yaml/114909/1 "2007-09-18T19:06:12Z")

</div>

i have a MySQL instance running on port 3307, how to change the  
default port setting??in database.yml?

and where to get the all setting options(host, password, adapter etc.)  
in database.yml?is there a cocument?

---

<div class="post-metadata">

**Author:** ![rubynut](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/8e8cbc/32.png) [@rubynut](https://www.ruby-forum.com/u/rubynut)\
**Post date:** [September 18, 2007, 7:11pm UTC](https://www.ruby-forum.com/t/help-with-mysql-and-yaml/114909/2 "2007-09-18T19:11:14Z")

</div>

The options differ based on the connection adapter. Here is the one for  
mysql:

[http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/MysqlAdapter.html](http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/MysqlAdapter.html)

The options listed at the top can be used in database.yml.

Ruby N. wrote:

> i have a MySQL instance running on port 3307, how to change the  
> default port setting??in database.yml?
> 
> and where to get the all setting options(host, password, adapter etc.)  
> in database.yml?is there a cocument?
> 
> >

–  
Sincerely,

William P.