Working Lan Server Working Smoothly

Lazzeraith · #1 10-13-2011, 04:42 AM

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');

after editing the values I get this error:

C:\eqemusource\trunk\EQEmuServer\EQEmuLoginServer\ login_util>INSERT INTO tblLogi
nServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, Last
IPAddress) VALUES('******', sha('******'), 'fakename@hotmail.com', now(),
'192.168.0.12');
'INSERT' is not recognized as an internal or external command,
operable program or batch file.

**Derision** · #2 10-13-2011, 03:01 PM

You need to paste the command into a MySQL command prompt:

Code:

C:\> mysql -u root -p peq
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 159
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, Last
IPAddress) VALUES('******', sha('******'), 'fakename@hotmail.com', now(),
'192.168.0.12');

I am assuming you called your database 'peq'. If not, change peq to whatever your database is called on the mysql command line.