# How login on mysql

**URL:** <https://forum.mattermost.com/t/how-login-on-mysql/504>\
**Category:** Troubleshooting\
**Created:** [November 10, 2015, 5:06pm UTC](https://forum.mattermost.com/t/how-login-on-mysql/504 "2015-11-10T17:06:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ihateslack](https://avatars.discourse-cdn.com/v4/letter/i/839c29/32.png) [@ihateslack](https://forum.mattermost.com/u/ihateslack)\
**Post date:** [November 10, 2015, 5:06pm UTC](https://forum.mattermost.com/t/how-login-on-mysql/504/1 "2015-11-10T17:06:56Z")

</div>

Hello, I just install mattermost with docker one line.

¿How can enter on mysql database for get all the conversations? My boss want export all every week.

---

<div class="post-metadata">

**Author:** ![coreyhulen](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/coreyhulen/32/25_2.png) [@coreyhulen](https://forum.mattermost.com/u/coreyhulen)\
**Post date:** [November 10, 2015, 8:27pm UTC](https://forum.mattermost.com/t/how-login-on-mysql/504/2 "2015-11-10T20:27:31Z")

</div>

Something like  
`docker exec -ti mattermost-dev /bin/bash`  
`$> mysql`

---

<div class="post-metadata">

**Author:** ![soethet](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@soethet](https://forum.mattermost.com/u/soethet)\
**Post date:** [September 23, 2016, 9:39am UTC](https://forum.mattermost.com/t/how-login-on-mysql/504/3 "2016-09-23T09:39:37Z")

</div>

Please help me.  
 ![](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex020/uploads/mattermost/original/1X/6c22bd5bff7dc09f84aa57e68a7aa8d1d902e5e9.PNG) I want to enter Mysql.

---

<div class="post-metadata">

**Author:** ![albercuba](https://avatars.discourse-cdn.com/v4/letter/a/34f0e0/32.png) [@albercuba](https://forum.mattermost.com/u/albercuba)\
**Post date:** [September 30, 2016, 1:59pm UTC](https://forum.mattermost.com/t/how-login-on-mysql/504/4 "2016-09-30T13:59:59Z")

</div>

to access your MySQL type:

`mysql -u USERNAME -p`

you are typing:

`$> mysql`

and you do not need to type “`&>`”

---

<div class="post-metadata">

**Author:** ![albercuba](https://avatars.discourse-cdn.com/v4/letter/a/34f0e0/32.png) [@albercuba](https://forum.mattermost.com/u/albercuba)\
**Post date:** [September 30, 2016, 2:05pm UTC](https://forum.mattermost.com/t/how-login-on-mysql/504/6 "2016-09-30T14:05:18Z")

</div>

To export a database in MySQL you need to do this:

Assuming your MySQL username is USERNAME and your database name is DATABASE.

Then export your database by typing this:

`mysqldump -u USERNAME -p DATABASE > DATABASE.sql`

---

<div class="post-metadata">

**Author:** ![soethet](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@soethet](https://forum.mattermost.com/u/soethet)\
**Post date:** [October 1, 2016, 2:15am UTC](https://forum.mattermost.com/t/how-login-on-mysql/504/7 "2016-10-01T02:15:05Z")

</div>

How Could I know Username and password and database name?  
 ![](https://us1.discourse-cdn.com/flex020/uploads/mattermost/original/1X/be24255019bed85006b79bc14eb43e93b146dcaf.PNG)