[DiscordArchive] "...creating a user that you can use to access the databases and that user with the proper privilege
[DiscordArchive] "...creating a user that you can use to access the databases and that user with the proper privilege
Original source
/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MariaDB or MySQL (TCP/IP), username root, using password: Yes ... */
/* Can't connect to server on '127.0.0.1' (10061) */
/* Connecting to 127.0.0.1 via MariaDB or MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
SHOW VARIABLES;
/* Characterset: utf8mb4 */
SHOW /*!50002 GLOBAL */ STATUS;
SELECT NOW();
/* Connected. Thread-ID: 8 */
/* Reading function definitions from D:\Programs\HeidiSQL\functions-mysql.ini */
SHOW TABLES FROM `information_schema`;
SHOW DATABASES;
SHOW OPEN TABLES FROM performance_schema WHERE `in_use`!=0;
USE `performance_schema`;
/* Entering session "Unnamed" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='performance_schema';
SHOW TABLE STATUS FROM `performance_schema`;
SHOW FUNCTION STATUS WHERE `Db`='performance_schema';
SHOW PROCEDURE STATUS WHERE `Db`='performance_schema';
SHOW TRIGGERS FROM `performance_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='performance_schema';
/* Scaling controls to screen DPI: 125% */
/* File "create_mysql.sql" executed, with 9 queries and 3 affected rows */
/* 1 file(s) processed, in 00:00:00.0 */
rektbyfaith
02-16-2023, 11:26 AM #61Archived author: Kristodian • Posted: 2023-02-16T11:26:14.064000+00:00
Original source
/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MariaDB or MySQL (TCP/IP), username root, using password: Yes ... */
/* Can't connect to server on '127.0.0.1' (10061) */
/* Connecting to 127.0.0.1 via MariaDB or MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
SHOW VARIABLES;
/* Characterset: utf8mb4 */
SHOW /*!50002 GLOBAL */ STATUS;
SELECT NOW();
/* Connected. Thread-ID: 8 */
/* Reading function definitions from D:\Programs\HeidiSQL\functions-mysql.ini */
SHOW TABLES FROM `information_schema`;
SHOW DATABASES;
SHOW OPEN TABLES FROM performance_schema WHERE `in_use`!=0;
USE `performance_schema`;
/* Entering session "Unnamed" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='performance_schema';
SHOW TABLE STATUS FROM `performance_schema`;
SHOW FUNCTION STATUS WHERE `Db`='performance_schema';
SHOW PROCEDURE STATUS WHERE `Db`='performance_schema';
SHOW TRIGGERS FROM `performance_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='performance_schema';
/* Scaling controls to screen DPI: 125% */
/* File "create_mysql.sql" executed, with 9 queries and 3 affected rows */
/* 1 file(s) processed, in 00:00:00.0 */
Original source
If no error popped up though it succeeded
rektbyfaith
02-16-2023, 11:26 AM #62Archived author: Revision • Posted: 2023-02-16T11:26:17.898000+00:00
Original source
If no error popped up though it succeeded
Original source
dont see error
rektbyfaith
02-16-2023, 11:26 AM #63Archived author: Kristodian • Posted: 2023-02-16T11:26:27.786000+00:00
Original source
dont see error
Original source
Second line from the bottom is mentioning running the file and there were no errors
rektbyfaith
02-16-2023, 11:26 AM #64Archived author: Revision • Posted: 2023-02-16T11:26:31.999000+00:00
Original source
Second line from the bottom is mentioning running the file and there were no errors
Original source
okay tnx
rektbyfaith
02-16-2023, 11:26 AM #65Archived author: Kristodian • Posted: 2023-02-16T11:26:41.103000+00:00
Original source
okay tnx
Original source
now the database?
rektbyfaith
02-16-2023, 11:26 AM #66Archived author: Kristodian • Posted: 2023-02-16T11:26:56.757000+00:00
Original source
now the database?
Original source
If there are ever errors it will pop up with a little window saying so, just so you know for the future.
rektbyfaith
02-16-2023, 11:27 AM #67Archived author: Revision • Posted: 2023-02-16T11:27:01.650000+00:00
Original source
If there are ever errors it will pop up with a little window saying so, just so you know for the future.
Original source
You simply start authserver and worldserver and it'll import all the databases for you which is the recommended way of doing it.
rektbyfaith
02-16-2023, 11:27 AM #68Archived author: Revision • Posted: 2023-02-16T11:27:18.647000+00:00
Original source
You simply start authserver and worldserver and it'll import all the databases for you which is the recommended way of doing it.
Original source
You do have to update the realmlist after running authserver but I think that's in the guide and you'll reach it
rektbyfaith
02-16-2023, 11:27 AM #69Archived author: Revision • Posted: 2023-02-16T11:27:33.431000+00:00
Original source
You do have to update the realmlist after running authserver but I think that's in the guide and you'll reach it
Original source
Well, if you play on the same system you technically don't have to but it can't hurt for you to know in case you want others to join the server at some point
rektbyfaith
02-16-2023, 11:27 AM #70Archived author: Revision • Posted: 2023-02-16T11:27:50.642000+00:00
Original source
Well, if you play on the same system you technically don't have to but it can't hurt for you to know in case you want others to join the server at some point
1 Guest(s)
1 Guest(s)