SphereCommunity
MYSQL Connect Fail [SOLVED] - Printable Version

+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: MYSQL Connect Fail [SOLVED] (/Thread-MYSQL-Connect-Fail-SOLVED)



MYSQL Connect Fail [SOLVED] - Monty - 03-23-2013 11:33 PM

[SOLUTION I had to find web server which use MYSQL innoDB. Most server use MyISAM and it does not work]

Guys I need your help again.

I need connect my sphere to database and it fails. Everytime i use oracle database and this can no connect with sphere. Cry (So bad) I can not install mysql server on localhost so I registered on web server and create and configure database. I see in other topicks on spherecomunity someone use connect without password but i can not use this. It is problem?

**.***.***.** this is my ip i hide this Doubt

LOGS:
14:29:ERROR:MySQL connect fail: Access denied for user 'sphere'@'**.***.***.**' (using password: YES)
14:29:ERROR:Visit this link for more information: http://dev.mysql.com/doc/mysql/search.php?q=Access denied for user 'sphere'@'**.***.***.**' (using password: YES)
14:29:MySQL: Failed to Connect!

SPHERE.INI:
MYSQL=1
MySqlHost=sql.endora.cz:3311
MySqlUser=sphere
MySqlPassword=sphere
MySqlDatabase=server1

database is empty if someone want try hack it Big GrinD

sql.endora.cz:3311 this is web server i use more web servers but noone connect successfully


RE: MYSQL Connect Fail - Avatar - 03-24-2013 03:04 AM

the server that you use as mysql are supposed to be acceptable for your sphere server host. I mean you should add permisson in your mysql database to transfer your data into that mysql database. If you use phpmyadmin or alike , there is an option to create user. And in it, there is host step and you can state your sphere server host ip.