Not allowed to connect to my database.

Questions & Answers
1

Whilst attempting to connect to my database i get this log. (its not an error with the scripting. just the connection).

MySql.Data.MySqlClient.MySqlException: Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.Driver.Open () [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in <filename unknown>:0 
UnityEngine.Debug:Log(Object)
playerLogin:Awake() (at Assets/SCRIPTS/playerLogin.cs:54)

How can I allow it to connect?

2

Below are two questions on SO with the same error message with solutions provided in them.

The basic gist of all those solutions is the access rights of the user which you need to modify.

  1. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  2. Host is not allowed to connect to this mysql server when making a local connection [closed]