host not allowed connect with mariadb
#5
(2019-11-09, 11:32)black_eagle Wrote:
(2019-11-09, 11:16)ikkeenjij36 Wrote: Yes i did give the user all privs to read and write with grant all

If you log into the mariadb server as that user and then do show grants; what does the output say ?

It should be something like this
sql:
MariaDB [(none)]> show grants;
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@%                                                                                            |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)


Sounds like you may have only granted privileges for that user on the local machine, instead of network wide.  

How do i do that?
by ssh or in the phpadmin ?
i made it on localhost ,or should i make it on any host? with %?
removed mariadb5 and 10 on syno
reinstalled mariadb 10
made a user eric grant all on %
now it connects to the maria db but it cant make a db on it now?
Reply


Messages In This Thread
RE: host not allowed connect with mariadb - by ikkeenjij36 - 2019-11-09, 12:14
Logout Mark Read Team Forum Stats Members Help
host not allowed connect with mariadb0