Host 'remoteserver' is not allowed to connect to this MySQL server"

[Venu Madhav]

Hi,

I have installed mysql 5.6 in 1 linux machine and jira 5.2.7 in another linux machine.

when I ran the setup wizard and connecting to mysql then it throwing the below error.

Error connecting to database

null, message from server: "Host 'rcolnx89193.noam.corp.frk.com' is not allowed to connect to this MySQL server"

I have created database by using create database testdb character set utf8 collate utf8_bin

create user act: create use 'jirauser' @'remoteservername' identified by 'jirauserpasword';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on jiradb.* TO 'jirauser'@'remoteservername'IDENTIFIED BY 'jirauser';

flush privileges

looking forward your greate quick response.

Thanks

Venu

[David at David Simpson Apps]

Perhaps replace 'jirauser'@'remoteservername' with 'jirauser'@'rcolnx89193.noam.corp.frk.com'

Certainly change the string 'remoteservername' in your SQL statement to something more useful ;)