Mysql convertion question

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
User avatar
GUNN3R17
Footman
Posts: 149
Joined: Wed Jul 06, 2005 5:24 pm
Location: Brea, CA
Contact:

Mysql convertion question

Post by GUNN3R17 » Tue Dec 13, 2005 2:25 am

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

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Dec 13, 2005 8:44 am

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

You need to put the IP address of your server
No Support via PM

erik2k3
Militia
Posts: 73
Joined: Wed Aug 03, 2005 6:34 am
Location: Germany / UK
Contact:

Post by erik2k3 » Tue Dec 13, 2005 11:29 am

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

User avatar
GUNN3R17
Footman
Posts: 149
Joined: Wed Jul 06, 2005 5:24 pm
Location: Brea, CA
Contact:

Post by GUNN3R17 » Tue Dec 13, 2005 2:30 pm

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

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Dec 13, 2005 9:49 pm

combine, by overwriting current data
No Support via PM

Post Reply