Mysql convertion question

[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)"

[Geesu]

That error message means you're trying to connect to my mysql server

You need to put the IP address of your server

[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

[GUNN3R17]

That error message means you're trying to connect to my mysql server

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

[Geesu]

combine, by overwriting current data