[DiscordArchive] /* SQL Error (1007): Can't create database 'acore_world'; database exists */ Where could i delete th
[DiscordArchive] /* SQL Error (1007): Can't create database 'acore_world'; database exists */ Where could i delete th
Original source
/* SQL Error (1007): Can't create database 'acore_world'; database exists */ Where could i delete the previous database ?
rektbyfaith
03-07-2023, 11:33 AM #1Archived author: Deleted User • Posted: 2023-03-07T11:33:46.544000+00:00
Original source
/* SQL Error (1007): Can't create database 'acore_world'; database exists */ Where could i delete the previous database ?
Original source
either in terminal or using gui client
rektbyfaith
03-07-2023, 11:34 AM #2Archived author: Rymercyble • Posted: 2023-03-07T11:34:30.603000+00:00
Original source
either in terminal or using gui client
Original source
terminal would be Mysql CMD ?
rektbyfaith
03-07-2023, 11:36 AM #3Archived author: Deleted User • Posted: 2023-03-07T11:36:16.142000+00:00
Original source
terminal would be Mysql CMD ?
Original source
terminal/cli/cmd and other names that window where u type commands one of which is access to mysql
rektbyfaith
03-07-2023, 11:37 AM #4Archived author: Rymercyble • Posted: 2023-03-07T11:37:53.789000+00:00
Original source
terminal/cli/cmd and other names that window where u type commands one of which is access to mysql
Original source
Thanks. I´ll google on how to delete the existing database. i think..
rektbyfaith
03-07-2023, 11:39 AM #5Archived author: Deleted User • Posted: 2023-03-07T11:39:27.919000+00:00
Original source
Thanks. I´ll google on how to delete the existing database. i think..
Original source
if u are not experienced it would be probably easier to use some client like heidi
rektbyfaith
03-07-2023, 11:40 AM #6Archived author: Rymercyble • Posted: 2023-03-07T11:40:08.545000+00:00
Original source
if u are not experienced it would be probably easier to use some client like heidi
Original source
I am in HeidiSQL. thats the place the error popped up
rektbyfaith
03-07-2023, 11:40 AM #7Archived author: Deleted User • Posted: 2023-03-07T11:40:29.592000+00:00
Original source
I am in HeidiSQL. thats the place the error popped up
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_general_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_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;
Upon trying to do this.
rektbyfaith
03-07-2023, 11:40 AM #8Archived author: Deleted User • Posted: 2023-03-07T11:40:43.425000+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_general_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_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;
Upon trying to do this.
Original source
on left side u should see all databases u got
rektbyfaith
03-07-2023, 11:41 AM #9Archived author: Rymercyble • Posted: 2023-03-07T11:41:23.499000+00:00
Original source
on left side u should see all databases u got
Original source
Should mention i did same stuff before without errors. Got the game even booted.
rektbyfaith
03-07-2023, 11:41 AM #10Archived author: Deleted User • Posted: 2023-03-07T11:41:29.062000+00:00
Original source
Should mention i did same stuff before without errors. Got the game even booted.
1 Guest(s)
1 Guest(s)