Hye, I have a new OT and the OT don't have the schema.mysql and I have added him from other OT i had. I have caongigured de AAC and the shop system and all go very well, but went i go to test the server with the Mysql, when i run the server appears this mssg :
<code>
[05/08/2009 12:55:30] >> Testing SQL connection... MySQL.
[05/08/2009 12:55:30] > MySQL ERROR mysql_real_connect: Access denied for user 'root'@'localhost' (using password: NO)
[05/08/2009 12:55:30] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SqLite which doesn't require any connection.
</code>
I have configured well the config.lua, look :
<code>
-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "123"
sqlDatabase = "server"
sqlFile = "schema.mysql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTImeout = 10
passwordType = "plain"
</code>
Don't worry the pass i will change it xD
What can I do for resolve this, because tomorrow i need to put this OT in our Server for update all
Thanks for now !
<code>
[05/08/2009 12:55:30] >> Testing SQL connection... MySQL.
[05/08/2009 12:55:30] > MySQL ERROR mysql_real_connect: Access denied for user 'root'@'localhost' (using password: NO)
[05/08/2009 12:55:30] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SqLite which doesn't require any connection.
</code>
I have configured well the config.lua, look :
<code>
-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "123"
sqlDatabase = "server"
sqlFile = "schema.mysql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTImeout = 10
passwordType = "plain"
</code>
Don't worry the pass i will change it xD
What can I do for resolve this, because tomorrow i need to put this OT in our Server for update all
Thanks for now !