Quote:
Originally Posted by valaerosilantix
ok, I had this trouble for a short time before I realized that SQL is case sensitive
|
MySQL is only as case sensitive as the OS it's on. If you're running Windows then you don't need to worry about having the correct case. If you're running the MySQL server on Linux then you do.
Quote:
Originally Posted by Mrfolx
Query OK, 0 rows affected <0.03 sec>
|
If it said that 0 rows were affected (which it did) then it never added your user. I've run into that myself. For some reason it wouldn't create users for me through the command line. I would suggest using a program similar to PHPMyAdmin (only if you have a web server on that computer too) or MySQL-Front to create the user.
Or, if you wanna try it again then use the syntax below (just run the first line if your database is on the same computer as
World.exe and
Zone.exe).
Quote:
GRANT ALL on [database].* to '[username]'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;
GRANT ALL on [database].* to '[username]'@'%' IDENTIFIED BY '[password]' WITH GRANT OPTION;
|
Just be sure to replace the bold text with your database name, username, and password.