Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 808461" data-attributes="member: 82144">Re: Re : TvService seems to fail connecting MySQLHi and welcome PierreC <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />That error is TV Server saying you can't use localhost. TV Server won't let you use localhost because the settings get copied to all clients that connect to the TV Server. Those clients could be different PCs for which localhost does not mean &quot;the computer with TV Server installed&quot; like it does on the actual TV Server. Don't use localhost or 127.0.0.1 - it flat out won't work.Using Pierre_France is correct, but you either haven't given enough privilege to root yet or you haven't actually created the schema/database for TV Server to use. You must create the database manually if using an existing MySQL installation. Then the user (root in this case) must be granted all privileges on that schema from any PC. Note that you may also need to grant certain privileges on the MySQL system schema. The security with MySQL is a little finnicky - at least be sure you grant permissions on the schema/database *and* for all hosts.mm</blockquote>

[QUOTE="mm1352000, post: 808461, member: 82144"] [b]Re: Re : TvService seems to fail connecting MySQL[/b] Hi and welcome PierreC :) That error is TV Server saying you can't use localhost. TV Server won't let you use localhost because the settings get copied to all clients that connect to the TV Server. Those clients could be different PCs for which localhost does not mean "the computer with TV Server installed" like it does on the actual TV Server. Don't use localhost or 127.0.0.1 - it flat out won't work. Using Pierre_France is correct, but you either haven't given enough privilege to root yet or you haven't actually created the schema/database for TV Server to use. You must create the database manually if using an existing MySQL installation. Then the user (root in this case) must be granted all privileges on that schema from any PC. Note that you may also need to grant certain privileges on the MySQL system schema. The security with MySQL is a little finnicky - at least be sure you grant permissions on the schema/database *and* for all hosts. mm [/QUOTE]

Verification