Normal
Have you changed something? Computer name? IP address? MySQL on this host? Or? ...In google i found similar problem:Problem: 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.Solution: 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 ’).Actions: 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 localhost ...
Have you changed something? Computer name? IP address? MySQL on this host? Or? ...
In google i found similar problem:
Problem: 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.
Solution: 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 ’).
Actions: 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 localhost ...