# MySQL user does not work after disable/re-enable virtual server in virtualmin

**URL:** <https://forum.virtualmin.com/t/mysql-user-does-not-work-after-disable-re-enable-virtual-server-in-virtualmin/61613>\
**Category:** Virtualmin\
**Created:** [November 25, 2019, 10:19am UTC](https://forum.virtualmin.com/t/mysql-user-does-not-work-after-disable-re-enable-virtual-server-in-virtualmin/61613 "2019-11-25T10:19:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sputnik0](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/sputnik0/32/1346_2.png) [@sputnik0](https://forum.virtualmin.com/u/sputnik0)\
**Post date:** [November 25, 2019, 10:19am UTC](https://forum.virtualmin.com/t/mysql-user-does-not-work-after-disable-re-enable-virtual-server-in-virtualmin/61613/1 "2019-11-25T10:19:56Z")

</div>

When I disable and re-enable a virtualserver the MySQL user refuses to work afterwards. I managed to get it working by using a MySQL query: alter user ‘user’@'localhost identified by ‘password’;. So I suspect something goes wrong with re-enabling the password.

Details about my server:

- Ubuntu 18.04 LTS
- MySQL 5.7 (default for 18.04 release)
- Installed through install.sh script. The only thing I’ve changed from the base configuration are setting the server to php-fpm handler.

---

<div class="post-metadata">

**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\
**Post date:** [April 30, 2020, 6:12am UTC](https://forum.virtualmin.com/t/mysql-user-does-not-work-after-disable-re-enable-virtual-server-in-virtualmin/61613/2 "2020-04-30T06:12:09Z")

</div>

Closed on April 30, 2020, 6:12am UTC


