phpMyAdmin fails/doesn't create new account

[Otfan125]

Hello there my friends, It has been a while since I've come along

I had a question regarding phpMyAdmin; when I create a new "account row" with new information on it, it doesn't seem to "save" in any way because when I try using those credentials to enter the tibia world, It states that my password/id is incorrect.

The way I did it was click on my Database on phpMyAdmin, go to the row that "accounts" is on and select "insert", I manually enter the desired information and then click save. However when I exit out of phpMyAdmin and try every single combination of ID/Name/Password in the Tibia "Enter Game", It doesn't seem to be working.

I get a feeling that I'm missing something, and to make an account I need to do more than just create a new row of information in "accounts"

Thank you for reading and for your future help

 

[Raggaer]

I dont really understand you error... can you show a pic or be more concrete =d

 

[Otfan125]

Thank you so much for your fast reply
I'm trying to get a server running, but I'm pretty new to the whole "server hosting" stuff, but not so "new" I would say to SQL, but I guess it would seem so with my mistakes.

Anyways, I'm basically trying to create a new account for my server. If I enter my OT with no password or account name, It gives me an empty character list. So what I did was try to create a new account in phpMyAdmin, here's what I did. http://postimg.org/image/g1k9ytygr/

I think that would be sufficient enough for the server to read the database and say "Oh there exist an account with the credentials 1/1, so I should be able to log in with 1/1" But that doesn't happen! It just tells me that my account name/password is incorrect

Thanks again for your reply!

 

[Zothion]

you might need to add it in some more places, or you added it wrong
either way i would recommend you get an AAC like Znotes and just run it locally with like UniServer, super easy

 

[HalfAway]

I think that would be sufficient enough for the server to read the database and say "Oh there exist an account with the credentials 1/1, so I should be able to log in with 1/1" But that doesn't happen! It just tells me that my account name/password is incorrect

What server do you use?

Check for the password encryption in config.lua and make sure the account's password got the same encryption in the database.

If you create a character at PHPMyAdmin, make sure you set the account's id on the characters account id.

 

[Raggaer]

Thank you so much for your fast reply
I'm trying to get a server running, but I'm pretty new to the whole "server hosting" stuff, but not so "new" I would say to SQL, but I guess it would seem so with my mistakes.

Anyways, I'm basically trying to create a new account for my server. If I enter my OT with no password or account name, It gives me an empty character list. So what I did was try to create a new account in phpMyAdmin, here's what I did. http://postimg.org/image/g1k9ytygr/

I think that would be sufficient enough for the server to read the database and say "Oh there exist an account with the credentials 1/1, so I should be able to log in with 1/1" But that doesn't happen! It just tells me that my account name/password is incorrect

Thanks again for your reply!

You probably are using an encryption in config.lua =)

 

[Otfan125]

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "milk"
mysqlPort = 3306
mysqlSock = ""



that's what i have for MySQL in my config.lua... For my localhost I'm not using a password for my root account at localhost... and now that I tried to "change password" in order to create a password, It's now telling me "Access Denied" and doesn't even ask me to enter a password or anything

"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."