Reply to thread

Message

<blockquote data-quote="PierreC" data-source="post: 808454" data-attributes="member: 116626">Re : TvService seems to fail connecting MySQLHello, I also experience the same problem : TV server configuration cannot connect to my MySQL database.Note that I didn't install MySQL from the MediaPortal standard installation, since I already have a MySQL 5.5 server running on my computer.&nbsp; I can access my other databases using MySQL Workbench 5.2 CE (the GUI) without any problems.I have followed the tips provided in previous posts, that is :a) replacing the Hostname : localhost with the name of my computer (Pierre_France)b) creating a new user in MySQL Workbench and giving it all accesses and privileges.But it doesn't work.&nbsp; I also checked the firewall and my Norton Internet Security 2011 is not causing the problem. I have granted privilege to the specific programs and even if I desable the firewall, I am still unable to connect to the DB.An interesting fact thought is that the error message is different according to the hostname I specifed :If I specify «localhost», the I get the error message : Specify server name : Please specify a valid hostname or IP address for the server. I also tried «localhost:3306» without any further success.If I specify «Pierre_France», as the hostname, I get : Connection failed! Host 'Pierre_France&quot; is not allowed to connect to this MySQL server even if I had granted user root with the privilege to connect to any DB schema from any host.In both cases, the user was «root» with my own password.I can send the logs if necessary.Can anyone help please? Thanks in advance!</blockquote>

[QUOTE="PierreC, post: 808454, member: 116626"] [b]Re : TvService seems to fail connecting MySQL[/b] Hello, I also experience the same problem : TV server configuration cannot connect to my MySQL database. Note that I didn't install MySQL from the MediaPortal standard installation, since I already have a MySQL 5.5 server running on my computer. I can access my other databases using MySQL Workbench 5.2 CE (the GUI) without any problems. I have followed the tips provided in previous posts, that is : a) replacing the Hostname : localhost with the name of my computer (Pierre_France) b) creating a new user in MySQL Workbench and giving it all accesses and privileges. But it doesn't work. I also checked the firewall and my Norton Internet Security 2011 is not causing the problem. I have granted privilege to the specific programs and even if I desable the firewall, I am still unable to connect to the DB. An interesting fact thought is that the error message is different according to the hostname I specifed : If I specify «localhost», the I get the error message : Specify server name : Please specify a valid hostname or IP address for the server. I also tried «localhost:3306» without any further success. If I specify «Pierre_France», as the hostname, I get : Connection failed! Host 'Pierre_France" is not allowed to connect to this MySQL server even if I had granted user root with the privilege to connect to any DB schema from any host. In both cases, the user was «root» with my own password. I can send the logs if necessary. Can anyone help please? Thanks in advance! [/QUOTE]

Verification