Uniform Server Myphperror

[Xiolo]

I get a messange when i star the server that says MYSQL ERROR:acces denied for user "Otera@localhots" database connection failed. PLEASE HELP!
i use:
*uniform sever
*OTServ 8.70 r.6052 TFS
*tibia 8.70
*tell me if you need more info

Here is my config.lua

SQL type
-- options: mysql, sqlite, odbc or pgsql
sql_type = "mysql"

-- SQL connection part
sql_db = "db.s3db"
-- sql_db = "otserv" -- use this for MySQL/PgSQL
-- sql_db = "Your Source" -- ODBC

-- Additional connection settings for mysql, pgsql and odbc
sql_host = "localhost"
sql_port = 3306
--- sql_port = 5432 -- use this for PgSQL
sql_user = "Otera"
sql_pass = "******"

PLEASE TELL ME WHAT TO CHANGE TY

 

[Znote]

http://otland.net/f138/znotes-video-tutorials-ot-servers-137957/

 

[Xiolo]

znote i actually followed your tutorials to create mysql and all of that but i dont use tfs 8.5 like you do, i use 8.7 and i need to get the conf right cause yours is diferent. thank you for help any way.

 

[Znote]

My video tutorials is using latest TFS 0.2 for client 9.1 not 8.5.

And it illustrates how I fix the database connection.

It should work with regular Otserv as well. :/

Enter phpmyadmin - make a new user

give user localhost, write secure password
give user all permissions and create database with same name

then in config.lua write username, database, the secured password and localhost and it should work fine.

 

[Xiolo]

Do you think there could be any posible way that the error come with the server i downloaded? and if its that do you have any other ot 8.7 instead of OTServ 8.70 r.6052 TFS?