[Archive] HOW TO MIGRATE A SERVER (DIFFERENT COMPUTERS)
[Archive] HOW TO MIGRATE A SERVER (DIFFERENT COMPUTERS)
Original source
Right now, you are attempting to connect to databases with login trinity and password trinity. So, assuming that you want to keep using this default setting...:
Does account "trinity" exist on your new MySQL server?
Does it really have password "trinity"?
Does it have full access rights on all databases and all tables in them (so global full access rights would be the best)
Can it connect from localhost?
If you have no clue how to even find out answers to these main questions, you need to learn something about creating and managing accounts and access rights on MySQL server. For now I can make this more simple for you with this script.:
GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `auth` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
PS: You have mentioned your admin root account, which is created during installation. I do not recommend using that account for anything else than setting up MySQL server - so mainly for creating first, nondefault account which will actually be used. Root should not be used for common editing of data, and it definitely should not be used for accessing databases from apps like TrinityCore.
rektbyfaith
07-13-2017, 01:05 PM #11Archived author: Amaroth • Posted: 2017-07-13T13:05:57+00:00
Original source
Right now, you are attempting to connect to databases with login trinity and password trinity. So, assuming that you want to keep using this default setting...:
Does account "trinity" exist on your new MySQL server?
Does it really have password "trinity"?
Does it have full access rights on all databases and all tables in them (so global full access rights would be the best)
Can it connect from localhost?
If you have no clue how to even find out answers to these main questions, you need to learn something about creating and managing accounts and access rights on MySQL server. For now I can make this more simple for you with this script.:
GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `auth` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
PS: You have mentioned your admin root account, which is created during installation. I do not recommend using that account for anything else than setting up MySQL server - so mainly for creating first, nondefault account which will actually be used. Root should not be used for common editing of data, and it definitely should not be used for accessing databases from apps like TrinityCore.
1 Guest(s)
1 Guest(s)