Failed to create database #62

New Issue

rkiller666 · 2023-11-05T23:53:03Z

rkiller666 commented

2023-11-05 23:53:03 +00:00

Failed to create databases! (MySQLdb.OperationalError) (1045, "Access denied for user 'aime'@'localhost' (using password: YES)")
(Background on this error at: https://sqlalche.me/e/14/e3q8)

I'm not entirely sure what to adjust for core.yaml, I changed the sha2_password from False to "password" but I can't seem to build database.

Failed to create databases! (MySQLdb.OperationalError) (1045, "Access denied for user 'aime'@'localhost' (using password: YES)") (Background on this error at: https://sqlalche.me/e/14/e3q8) I'm not entirely sure what to adjust for core.yaml, I changed the sha2_password from False to "password" but I can't seem to build database.

Midorica commented

2023-11-05 23:55:02 +00:00

Hello,

Regarding the sha2_password trigger, it is either True or False, not a password.

You would but the database user's password inside the proper field instead.

Hello, Regarding the sha2_password trigger, it is either True or False, not a password. You would but the database user's password inside the proper field instead.

rkiller666 commented

2023-11-05 23:59:05 +00:00

I've changed sha2_password to True and entered my SQL password under password: "password" under database but same issue happens

rkiller666 commented

2023-11-06 00:14:11 +00:00

is the database username this?

this..PNG

8.0 KiB

rkiller666 commented

2023-11-06 00:24:12 +00:00

I have MySQL Server 8.0.35 instead of MySQL Server 8.0.29

I can only download MySQL Server 8.0.28 and MySQL Server 8.0.30, will this affect the setup?

I have MySQL Server 8.0.35 instead of MySQL Server 8.0.29 I can only download MySQL Server 8.0.28 and MySQL Server 8.0.30, will this affect the setup?

rkiller666 commented

2023-11-06 00:56:51 +00:00

I'm sorry, I've tried 8.0.30 and 8.0.35 where every possible option I have changed to "aime" and sha2_password I have attempted with true and false. I still can't seem to build database, any help will be greatly appreciated

Midorica commented

2023-11-06 01:59:06 +00:00

If you used the commands that was in the Windows setup guide, leave sha2_password to False otherwise it will not work

rkiller666 commented

2023-11-06 02:18:27 +00:00

If you used the commands that was in the Windows setup guide, leave sha2_password to False otherwise it will not work

I followed the windows setup guide, left sha2_password to False, input the root password as database password but I still can't build database. Following the setup guide, I have no clue what to change username or name under database to, I'm assuming they remain "aime"?
"Leave everything under Windows Service as default and hit Next >" according to this step

> If you used the commands that was in the Windows setup guide, leave sha2_password to False otherwise it will not work I followed the windows setup guide, left sha2_password to False, input the root password as database password but I still can't build database. Following the setup guide, I have no clue what to change username or name under database to, I'm assuming they remain "aime"? "Leave everything under Windows Service as default and hit Next >" according to this step

Midorica commented

2023-11-06 02:43:25 +00:00

It really depends on what you wrote on that line of code
CREATE USER 'aime'@'localhost' IDENTIFIED BY 'MyStrongPass.';

If you wrote exactly this.... the username would be aime and the password would have been MyStrongPass.

It really depends on what you wrote on that line of code `CREATE USER 'aime'@'localhost' IDENTIFIED BY 'MyStrongPass.';` If you wrote exactly this.... the username would be aime and the password would have been MyStrongPass.

rkiller666 commented

2023-11-06 02:45:50 +00:00

Holy shit it worked. Thank you soo much, my tech illiterate ass can't read code well

rkiller666 closed this issue

2023-11-06 02:45:50 +00:00

Sign in to join this conversation.