• Community
  • Products
  • Jira
  • Questions
  • JIRA MySQL Connection Error: null, message from server: "Host 'myserver.domain.com' is not allowed to connect to this MySQL server"

JIRA MySQL Connection Error: null, message from server: "Host 'myserver.domain.com' is not allowed to connect to this MySQL server"

Hi All

So I am now starting the JIRA/MySQL installation and setup.

I have reached the point of Running the JIRA setup. When I test the connection I get the following message:

null, message from server: "Host 'myserver.domain.com' is not allowed to connect to this MySQL server"


MySQL and JIRA are on the same PC.

I have created a jiradbuser and granted all permissions (using Navicat)

I have created the jiradb which is visible in Navicat (although at this stage has no tables)

All help gratefully received

Nick

1 answer

1 accepted

This widget could not be displayed.

From: http://dev.mysql.com/doc/refman/5.5/en/access-denied.html

{quote}

  • If the following error occurs when you try to connect from a host other than the one on which the MySQL server is running, it means that there is no row in the user table with a Host value that matches the client host:

    Host ... is not allowed to connect to this MySQL server

    You can fix this by setting up an account for the combination of client host name and user name that you are using when trying to connect.

    If you do not know the IP address or host name of the machine from which you are connecting, you should put a row with '%' as the Host column value in the user table. After trying to connect from the client machine, use a SELECT USER() query to see how you really did connect. Then change the '%' in the user table row to the actual host name that shows up in the log. Otherwise, your system is left insecure because it permits connections from any host for the given user name.

    On Linux, another reason that this error might occur is that you are using a binary MySQL version that is compiled with a different version of the glibc library than the one you are using. In this case, you should either upgrade your operating system or glibc, or download a source distribution of MySQL version and compile it yourself. A source RPM is normally trivial to compile and install, so this is not a big problem.

{quote}

Thanks Radu

Blindingly obvious when you know what the answer is!!! There was a simple miss-match between the user host setting and the one I was trying i.e. localhost vs. myservername

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

112 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you