home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
unable to connect to database all ports fine
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mm1352000" data-source="post: 1119770" data-attributes="member: 82144"><p>I don't know the correct configuration for the anonymous user, so recreating it properly would be difficult. If I were you I would try to undo whatever I had done.</p><p></p><p></p><p>...and unfortunately I don't know how to explain any clearer. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown :(" loading="lazy" data-shortname=":(" /></p><p></p><p>You have two options to solve this problem:</p><p></p><p>1. Change the "root" user configuration to allow the "root" user to connect from additional PCs.</p><p>2. Create a new user (or try to use your modified anonymous user) for MP and TV Server to use, <strong>and then configure MP and TV Server to use this user.</strong></p><p></p><p>For the first option, you simply change the "limit connectivity to hosts matching" from localhost/127.0.0.1/::1 to whatever you need it to be:</p><p>[ATTACH=full]160229[/ATTACH]</p><p></p><p>You might change it to "%" to enable root to connect from any PC... or you might specify the IP address of the PC that is your MP client for better security. Your choice.</p><p></p><p></p><p>For the second option, you create a new user as instructed in the post that I previously linked (I'm not able to give better instructions than are in that post).</p><p>To configure MP and TV Server to use that new user, you must update "c:\<strong>ProgramData</strong>\Team MediaPortal\<strong>MediaPortal TV Server</strong>\gentle.config" (this is a text file that can be opened in any text editor - notepad, wordpad etc.) and update the connection configuration.</p><p>The connection configuration is this line:</p><p><DefaultProvider name="MySQL" connectionString="Server=HTPC;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;" /></p><p></p><p>You need to change "User ID=root" to match the name of the new user account you create.</p><p>You need to change "Password=MediaPortal" to match the password for the new user account you create.</p><p></p><p>Repeat those changes for "c:\<strong>ProgramData</strong>\Team MediaPortal\<strong>MediaPortal</strong>\gentle.config" on the server and client, and the problem should be solved.</p></blockquote><p></p>
[QUOTE="mm1352000, post: 1119770, member: 82144"] I don't know the correct configuration for the anonymous user, so recreating it properly would be difficult. If I were you I would try to undo whatever I had done. ...and unfortunately I don't know how to explain any clearer. :( You have two options to solve this problem: 1. Change the "root" user configuration to allow the "root" user to connect from additional PCs. 2. Create a new user (or try to use your modified anonymous user) for MP and TV Server to use, [B]and then configure MP and TV Server to use this user.[/B] For the first option, you simply change the "limit connectivity to hosts matching" from localhost/127.0.0.1/::1 to whatever you need it to be: [ATTACH=full]160229[/ATTACH] You might change it to "%" to enable root to connect from any PC... or you might specify the IP address of the PC that is your MP client for better security. Your choice. For the second option, you create a new user as instructed in the post that I previously linked (I'm not able to give better instructions than are in that post). To configure MP and TV Server to use that new user, you must update "c:\[B]ProgramData[/B]\Team MediaPortal\[B]MediaPortal TV Server[/B]\gentle.config" (this is a text file that can be opened in any text editor - notepad, wordpad etc.) and update the connection configuration. The connection configuration is this line: <DefaultProvider name="MySQL" connectionString="Server=HTPC;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;" /> You need to change "User ID=root" to match the name of the new user account you create. You need to change "Password=MediaPortal" to match the password for the new user account you create. Repeat those changes for "c:\[B]ProgramData[/B]\Team MediaPortal\[B]MediaPortal[/B]\gentle.config" on the server and client, and the problem should be solved. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
unable to connect to database all ports fine
Contact us
RSS
Top
Bottom