[DiscordArchive] How do you change the database password? Is this these lines in world.conf?
[DiscordArchive] How do you change the database password? Is this these lines in world.conf?
Original source
How do you change the database password? Is this these lines in world.conf?
![[Image: image.png?ex=690c2030&is=690aceb0&hm=9d4...c3aff74be&]](https://cdn.discordapp.com/attachments/284406375495368704/1179092473633587320/image.png?ex=690c2030&is=690aceb0&hm=9d4150fa89b230dc6f61301842910b457cc709aebf80f29d555fee0c3aff74be&)
rektbyfaith
11-28-2023, 04:12 PM #1Archived author: Cyanide • Posted: 2023-11-28T16:12:32.327000+00:00
Original source
How do you change the database password? Is this these lines in world.conf?
Original source
password and user has to be set at your mysql or mariadb server. then change in the uncommented lines. these are the lines without '#'
rektbyfaith
11-28-2023, 04:28 PM #2Archived author: Aloy • Posted: 2023-11-28T16:28:28.374000+00:00
Original source
password and user has to be set at your mysql or mariadb server. then change in the uncommented lines. these are the lines without '#'
Original source
example auth: if your user is "user" and password "password, then the line is 127.0.0.1;3306;user;password;auth
rektbyfaith
11-28-2023, 04:29 PM #3Archived author: Aloy • Posted: 2023-11-28T16:29:59.590000+00:00
Original source
example auth: if your user is "user" and password "password, then the line is 127.0.0.1;3306;user;password;auth
Original source
Thank you SO MUCH! ❤️ I found this command on stackoverflow so if anyone in the future control-Fs a similar issue here's the solution:
Open your DB and HeidiSQL
Run this as a Query substituting your password into the ('somepassword'):
```SET PASSWORD FOR 'root'@'localhost' = PASSWORD('somepassword'); ```
Then edit the fields in Auth and World Configs (not the ## ones)
rektbyfaith
11-28-2023, 04:30 PM #4Archived author: Cyanide • Posted: 2023-11-28T16:30:51.247000+00:00
Original source
Thank you SO MUCH! ❤️ I found this command on stackoverflow so if anyone in the future control-Fs a similar issue here's the solution:
Open your DB and HeidiSQL
Run this as a Query substituting your password into the ('somepassword'):
```SET PASSWORD FOR 'root'@'localhost' = PASSWORD('somepassword'); ```
Then edit the fields in Auth and World Configs (not the ## ones)
Original source
FYI, SET PASSWORD is deprecated in 5.7 and removed in 8.0 (apparently)
rektbyfaith
11-28-2023, 04:33 PM #5Archived author: Revision • Posted: 2023-11-28T16:33:14.286000+00:00
Original source
FYI, SET PASSWORD is deprecated in 5.7 and removed in 8.0 (apparently)
Original source
![[Image: image.png?ex=690c2515&is=690ad395&hm=80e...b7f343543&]](https://cdn.discordapp.com/attachments/284406375495368704/1179097729641746492/image.png?ex=690c2515&is=690ad395&hm=80e9bf15dbc35a5a788b284934f0cadb0084625056e83efbff33769b7f343543&)
rektbyfaith
11-28-2023, 04:33 PM #6Archived author: Revision • Posted: 2023-11-28T16:33:25.377000+00:00
Original source
Original source
You should use `ALTER USER 'root'@'localhost' IDENTIFIED BY 'insertpasswordhere';`
rektbyfaith
11-28-2023, 04:33 PM #7Archived author: Revision • Posted: 2023-11-28T16:33:56.076000+00:00
Original source
You should use `ALTER USER 'root'@'localhost' IDENTIFIED BY 'insertpasswordhere';`
Original source
and FLUSH PRIVILEGES; at the end
rektbyfaith
11-28-2023, 04:34 PM #8Archived author: Aloy • Posted: 2023-11-28T16:34:38.888000+00:00
Original source
and FLUSH PRIVILEGES; at the end
Original source
Not required
rektbyfaith
11-28-2023, 04:37 PM #9Archived author: Revision • Posted: 2023-11-28T16:37:20.628000+00:00
Original source
Not required
1 Guest(s)
1 Guest(s)