[DiscordArchive] okie, as for sure, your database are exist?
[DiscordArchive] okie, as for sure, your database are exist?
Archived author: Pauz • Posted: 2023-09-26T05:53:52.757000+00:00
Original source
but you are open HeidiSQL and query acore user?
![[Image: image.png?ex=690c3817&is=690ae697&hm=b95...620ff9a79&]](https://cdn.discordapp.com/attachments/284406375495368704/1156106509747503114/image.png?ex=690c3817&is=690ae697&hm=b9579ee06af5df22516c27905f5d3e7ec16e629d01cb591839c71e9620ff9a79&)
Archived author: Pauz • Posted: 2023-09-26T05:54:31.396000+00:00
Original source
this part
![[Image: image.png?ex=690c3817&is=690ae697&hm=b95...620ff9a79&]](https://cdn.discordapp.com/attachments/284406375495368704/1156106509747503114/image.png?ex=690c3817&is=690ae697&hm=b9579ee06af5df22516c27905f5d3e7ec16e629d01cb591839c71e9620ff9a79&)
Archived author: Gordon McAllister • Posted: 2023-09-26T05:54:32.530000+00:00
Original source
I have no idea what im doing with Heidi
Archived author: Gordon McAllister • Posted: 2023-09-26T05:54:41.637000+00:00
Original source
ahh, i did thaty
Archived author: Gordon McAllister • Posted: 2023-09-26T05:54:43.100000+00:00
Original source
DROP USER IF EXISTS 'acore'@'localhost';
CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION;
CREATE DATABASE `acore_world` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON `acore_world` . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_characters` . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'acore'@'localhost' WITH GRANT OPTION;