Access denied for user 'root'@'localhost' #1610

New Issue

OVERLORD · 2026-02-05T01:25:25+03:00

OVERLORD commented

2026-02-05 01:25:25 +03:00

Originally created by @gabdel1 on GitHub (Mar 27, 2020).

So, I did the manual installation, all went ok, migrations ran seamlessely, but when I try to open the website on the browser, ignition throws this error at me:

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from users where system_name = public limit 1)

I tried everything from setting write permissions, to changing the host to 127.0.0.1 and anything else I could think of.

Originally created by @gabdel1 on GitHub (Mar 27, 2020). So, I did the manual installation, all went ok, migrations ran seamlessely, but when I try to open the website on the browser, ignition throws this error at me: > SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from `users` where `system_name` = public limit 1) I tried everything from setting write permissions, to changing the host to 127.0.0.1 and anything else I could think of.

OVERLORD added the 🐕 Support label 2026-02-05 01:25:25 +03:00

OVERLORD closed this issue

2026-02-05 01:25:29 +03:00

OVERLORD commented

2026-02-05 01:25:32 +03:00

@ssddanbrown commented on GitHub (Mar 28, 2020):

Hi @gabdel1,
What operating system are you running and what exact database system/version are you using?

I know on modern Ubuntu installations that you need to be the root system user to be able to use the root mysql user. Have you tried creating a new, non-root, mysql user for BookStack?

@ssddanbrown commented on GitHub (Mar 28, 2020): Hi @gabdel1, What operating system are you running and what exact database system/version are you using? I know on modern Ubuntu installations that you need to be the root system user to be able to use the `root` mysql user. Have you tried creating a new, non-root, mysql user for BookStack?

OVERLORD commented

2026-02-05 01:25:35 +03:00

@gabdel1 commented on GitHub (Mar 28, 2020):

I am on Ubuntu 18.04 .. And you are right, it was root account that caused the problem. I created a new user granted them access to the DB and all is good now!

Thank you very much.

@gabdel1 commented on GitHub (Mar 28, 2020): I am on Ubuntu 18.04 .. And you are right, it was root account that caused the problem. I created a new user granted them access to the DB and all is good now! Thank you very much.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#1610