ok so I got my server up and I was reading a post that said: Open a DOS shell and enter 'mysql -u root -p' to launce the mysql client. Enter your password when prompted.
Enter "use wotlk_realmd;"
Enter "select id, username, tbc from account;"
This shows the database table id, your account username, and the tbc variable (which is probably 0 or 1) for all the accounts.
Find the account you want to change and note the id value.
Assume your 'id' was 123. The mysql statement would be:
update account set tbc=2 where id=123;
so I did it and it gives me this error: Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Owner>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 83
Server version: 5.0.67-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use wotlk_realmd;
ERROR 1049 (42000): Unknown database 'wotlk_realmd'
mysql>
so does anyone know how I can upgrade my account to wotlk
try to use a third prog party to admin your mysql database like phpmyadmin if u have a webserver linked with it !
