<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<br>
<div class="moz-cite-prefix">On 19/04/18 06:08, Ashu Desai wrote:<br>
</div>
<blockquote type="cite" cite="mid:CABzWHuHuJuB6CO=NPfyZo4vWkk1OnBmHO97cRo94JJEdCgG33Q@mail.gmail.com">
<div dir="ltr"><br>
<div class="gmail_quote">
<div>mysql -h backend_ip -D mythconverg -u mythtv -p<br>
</div>
<div><br>
</div>
<div> </div>
<div>And it doesn't work. So then I try to do it on my backend - i can log in fine. However, when i do the standard mysql command: </div>
<div><br>
</div>
<div>
<div><font style="background-color:rgb(255,255,0)" color="#000000">MariaDB [mythconverg]> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";</font></div>
<div><font style="background-color:rgb(255,255,0)" color="#000000">ERROR 1044 (42000): Access denied for user 'mythtv'@'mythmaster' to database 'mythconverg'</font></div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>I am not sure where it got "mythmaster" from - since my.cnf has IP - and so does config.xml</div>
<div><br>
</div>
<br>
</div>
</div>
</blockquote>
This thread seems to have been derailed from the original post and possibly should be a new one.<br>
<br>
mythmaster is the hostname of your backend and is where you have logged into your database from - using your (mariadb) mythtv userid and password. That mythtv user does not have the necessary permissions to grant access to the mythconverg database. Specifically
- it appears you are trying to use that unprivileged mythtv user account to give itself permission to access the mythconverg database. Instead you will need to log in using a suitably privileged user most likely the root account created when you installed
mariadb.<br>
<br>
<br>
Re: remote access, also make sure you modify your mariadb config to bind to the ip address of the server it is installed on (the bind-address parameter). Out of the box it will bind to the loopback IP only for security.<br>
<a class="moz-txt-link-freetext" href="https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/">https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/</a><br>
</body>
</html>