2019-11-09, 12:14
(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 doshow 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?