Page 1 of 1

Mysql convertion question

Posted: Tue Dec 13, 2005 2:25 am
by GUNN3R17
if the vault file i chose has data in it and the sql database has data in it will it combine the xps/one over writes the other/ or just not work?

is this set up right?
db=w3ft
table=war3users
user=root

Code: Select all

GRANT USAGE ON * . * TO 'root'@'38.113.137.7' IDENTIFIED BY '<amxx user password>' ; 
GRANT USAGE ON * . * TO 'root'@'war3ft.com' IDENTIFIED BY '<amxx user password>' ; 
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON `w3ft` . * TO 'root'@'38.113.137.7' ; 
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON `w3ft` . * TO 'root'@'war3ft.com' ;
so far i just get "Could not connect : Access denied for user 'root'@'38.113.137.7' (using password: YES)"

Posted: Tue Dec 13, 2005 8:44 am
by Geesu
That error message means you're trying to connect to my mysql server :P

You need to put the IP address of your server

Posted: Tue Dec 13, 2005 11:29 am
by erik2k3
instead of going with all the GRANT commands, you simply could do the follwing per phpmyadmin :

create a new user which has acces to the MySQL server from ALL hosts ( this includes wc3ft.com ) then run the vault conversion, after that restrict the acces for this user to just your gameserver, then it`l work

Posted: Tue Dec 13, 2005 2:30 pm
by GUNN3R17
Geesu wrote:That error message means you're trying to connect to my mysql server :P

You need to put the IP address of your server
OHHH....(slaps self upside the head)...lol...thanks geesu...im just alittle blind..lol

and eric...i have never used phpmyadmin before but i saw i pic i think you posted and im gona try that out to...looks very useful

thanks for all your guys help

but if the vault file i chose has xp data in it and the sql database has xp data in it; will it combine the xps?...i guess i'll find out when i have time to try it out though

Posted: Tue Dec 13, 2005 9:49 pm
by Geesu
combine, by overwriting current data