[DiscordArchive] Do you have **#** in your password?
[DiscordArchive] Do you have **#** in your password?
Archived author: Nyeriah • Posted: 2023-03-14T08:50:34.521000+00:00
Original source
Do you have **#** in your password?
Archived author: Nyeriah • Posted: 2023-03-14T08:50:51.413000+00:00
Original source
That character breaks it
Archived author: Michael Crilly • Posted: 2023-03-14T08:52:35.238000+00:00
Original source
No I don't. Just trying something...
Archived author: Michael Crilly • Posted: 2023-03-14T08:56:05.560000+00:00
Original source
I thought perhaps it was because I didn't use the setup here: https://github.com/azerothcore/azerothco..._mysql.sql -- but that also has not solved the issue.
[Embed: azerothcore-wotlk/create_mysql.sql at master · azerothcore/azerothc...]
Complete Open Source and Modular solution for MMO. Contribute to azerothcore/azerothcore-wotlk development by creating an account on GitHub.
https://github.com/azerothcore/azerothco..._mysql.sql
Archived author: Michael Crilly • Posted: 2023-03-14T08:56:14.526000+00:00
Original source
SO back to square one.
Archived author: Michael Crilly • Posted: 2023-03-14T08:57:02.700000+00:00
Original source
I did clean up and run that script though, with modifications: ```DROP USER IF EXISTS 'acore_testing'@'localhost';
CREATE USER 'acore_testing'@'localhost' IDENTIFIED BY 'acore_testing' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON * . * TO 'acore_testing'@'localhost' WITH GRANT OPTION;
CREATE DATABASE `acore_world_testing_realm` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_characters_testing_realm` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
GRANT ALL PRIVILEGES ON `acore_world_testing_realm` . * TO 'acore_testing'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_characters_testing_realm` . * TO 'acore_testing'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'acore_testing'@'localhost' WITH GRANT OPTION;```
Archived author: Michael Crilly • Posted: 2023-03-14T08:57:21.237000+00:00
Original source
Which got me: ```MariaDB [(none)]> show grants for 'acore_testing'@'localhost';
+-------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for acore_testing@localhost |
+-------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `acore_testing`@`localhost` IDENTIFIED BY PASSWORD '*1D0F1C43C9324B71AC65DD70E1797452579317FA' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `acore_auth`.* TO `acore_testing`@`localhost` WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `acore_world_testing_realm`.* TO `acore_testing`@`localhost` WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `acore_characters_testing_realm`.* TO `acore_testing`@`localhost` WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.000 sec)
```
Archived author: Michael Crilly • Posted: 2023-03-14T08:57:27.054000+00:00
Original source
But alas the issue persists.
Archived author: Michael Crilly • Posted: 2023-03-14T08:57:35.142000+00:00
Original source
It's probably something silly/obvious.
Archived author: Michael Crilly • Posted: 2023-03-14T08:59:44.951000+00:00
Original source
Of course: ```-- Dumping structure for table acore_characters.pet_spell_cooldown
```