# How do I set a custom MySQL IP address?

**URL:** https://community.zammad.org/t/how-do-i-set-a-custom-mysql-ip-address/2601
**Category:** Technical assistance
**Created:** [June 8, 2019, 1:28pm UTC](https://community.zammad.org/t/how-do-i-set-a-custom-mysql-ip-address/2601 "2019-06-08T13:28:14Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![MrGeneration](https://community.zammad.org/user_avatar/community.zammad.org/mrgeneration/32/9260_2.png) [@MrGeneration](https://community.zammad.org/u/MrGeneration)
#### Post date: [June 10, 2019, 12:34am UTC](https://community.zammad.org/t/how-do-i-set-a-custom-mysql-ip-address/2601/5 "2019-06-10T00:34:04Z")

</div>

Welcome.  
First, here’s some lecture for you:  
[https://community.zammad.org/t/asking-for-help-on-community/2262/2](https://community.zammad.org/t/asking-for-help-on-community/2262/2)

> [@Rocky](#):
>
> I ignored the rake db:seed errors and continued installation.

Secondly, your installation is not finished with ignoring that.

> [@Rocky](#):
>
> ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect string value: ‘\xD0\x91\xD1\x8A\xD0\xBB…’ for column ‘name’ at row 1: INSERT INTO `locales` (`locale`, `alias`, `name`, `created_at`, `updated_at`) VALUES (‘bg’, ‘’, ‘Bulgarian (Български)’, ‘2019-06-08 14:01:58.807000’, ‘2019-06-08 14:01:58.807000’) /opt/zammad/.rvm/gems/ruby-2.4.4/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `\_query’

You might want to ensure that you’re using an UTF-8 based database.  
You’ll run in more and more errors, if you don’t fix that.

(I’ll ignore the other problems you experience, because the above needs to be fixed first)

> [@Rocky](#):
>
> But there is nothing in there to tell me how to customize database IP address, how do I change the database IP address? I have a dedicated MySQL server and don’t want to run it on localhost.

You’ll need to add `host: xyz` to your database.yml.  
Please note that we had better experience with postgresql.

---

_[View the full topic](https://community.zammad.org/t/how-do-i-set-a-custom-mysql-ip-address/2601)._