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
Installation, configuration support
Setup data connection - mySQL connection failed
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="ajs" data-source="post: 1265768" data-attributes="member: 68833"><p>Have you changed something? Computer name? IP address? MySQL on this host? Or? ...</p><p></p><p>In google i found similar problem:</p><p></p><p><strong>Problem</strong>: Connection to the MySQL server occurs with the error "Host‘ such and such ’is not allowed to connect to this MySQL server." This is due to the fact that the user on behalf of whom you are accessing the MySQL server does not have access to this server from the current IP address.</p><p><strong>Solution</strong>: in the user table, you need to allow the user access to the database either from a specific one (for example, ‘10 .10.10.10 ’@ @’ user ’) or from any IP address (‘% ’@’ user ’).</p><p><strong>Actions</strong>: In the console, log in to the MySQL server under the root username with its password, create (or modify, if it already exists) the user with the ability to connect to the database we need from any IP address and reload the permissions table:</p><p>[code]~# mysql -u root mysql -p[/code]</p><p>[code]mysql> GRANT ALL PRIVILEGES ON database.* TO username@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;</p><p>mysql> exit;[/code]</p><p>[code]~# mysqladmin -u root -p flush-privileges[/code]</p><p>Here database is the database to which we assign the rights to the user username with password password.</p><p></p><p>If MySQL and Mediaportal TV Server on one host, try change computer name in connect window to <strong>localhost </strong>...</p></blockquote><p></p>
[QUOTE="ajs, post: 1265768, member: 68833"] Have you changed something? Computer name? IP address? MySQL on this host? Or? ... In google i found similar problem: [B]Problem[/B]: Connection to the MySQL server occurs with the error "Host‘ such and such ’is not allowed to connect to this MySQL server." This is due to the fact that the user on behalf of whom you are accessing the MySQL server does not have access to this server from the current IP address. [B]Solution[/B]: in the user table, you need to allow the user access to the database either from a specific one (for example, ‘10 .10.10.10 ’@ @’ user ’) or from any IP address (‘% ’@’ user ’). [B]Actions[/B]: In the console, log in to the MySQL server under the root username with its password, create (or modify, if it already exists) the user with the ability to connect to the database we need from any IP address and reload the permissions table: [code]~# mysql -u root mysql -p[/code] [code]mysql> GRANT ALL PRIVILEGES ON database.* TO username@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; mysql> exit;[/code] [code]~# mysqladmin -u root -p flush-privileges[/code] Here database is the database to which we assign the rights to the user username with password password. If MySQL and Mediaportal TV Server on one host, try change computer name in connect window to [B]localhost [/B]... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Installation, configuration support
Setup data connection - mySQL connection failed
Contact us
RSS
Top
Bottom