Hello.
I'm currently trying to configure OTRS, and I'm bumping into this error in the step2 of installer.pl:
Can't connect to database, read comment!
Host 10.100.30.2 is not allowed to connect to this MariaDB server
Already gave permissions to the root user to connect itself to the DB:
Grants for root@10.100.30.2 |
+---------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.100.30.2' IDENTIFIED BY PASSWORD '*72F294A362AC9B9C3FA02F4B1E513F41A3AB414E' WITH GRANT OPTION |
Tried to connect through remotly and it works as well:
myuser@10.100.30.2 ~$ mysql -u root -h 'serverotrs.mydomain -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 98
Server version: 5.5.60-MariaDB MariaDB Server
I can't find nothing in the logs and I really can't understand why I can't connect
Can anyone help me?
Thanks a lot
Installing: Host 'serverotrs.mydomain' is not allowed to connect to this MariaDB server
Moderator: crythias
-
- Znuny superhero
- Posts: 621
- Joined: 24 Feb 2012, 03:58
- Znuny Version: LTS and Features
- Real Name: Mo Azfar
- Location: Kuala Lumpur, MY
- Contact:
Re: Installing: Host 'serverotrs.mydomain' is not allowed to connect to this MariaDB server
The app and db in same server ? if yes, try to use 127.0.0.1 or localhost
If not, perhaps, root login is disabled for remote.
Do create empty otrs db with user/password, then choose use existing db instead
good luck
If not, perhaps, root login is disabled for remote.
Do create empty otrs db with user/password, then choose use existing db instead
good luck