List:General Discussion« Previous MessageNext Message »
From:Wybo Date:August 20 2014 9:16pm
Subject:Re: how to access Synology's mysql (mariadb) on the command line
View as plain text  
Yes, that worked - thank you very much!

On 2014-08-20 22:51, shawn l.green wrote:
> Hello Wybo,
>
> I cleansed your reply and cc:'ed the list again to share the answer.
>
> On 8/20/2014 4:24 PM, Wybo wrote:
>> Hi Shawn,
>>
>> Thanks for your prompt reply - I suppose I'll have to do that query via
>> phpMysqlAdmin. When I do that, the only host that appears is localhost.
>> However, when I browse the user table, I also see %edited%, which is the
>> hostname of the synology station, see the attached screenshot (%also edited%).
> Does this
>> mean that I have to add a new entry in this table? If so, can I do that
>> via phpMysqlAdmin?
>>
>
> Yes, you will need to use your phpMysqlAdmin session to issue an
> appropriate GRANT command so that the 'wybo' user can login from
> 'wybo.fritz.box'.
>
> Example -
>
> GRANT <the permissions you want to give> on *.* to
> 'wybo'@'wybo.fritz.box' IDENTIFIED BY 'password goes here in plain text'


-- 
Wybo
Thread
how to access Synology's mysql (mariadb) on the command lineWybo20 Aug 2014
  • Re: how to access Synology's mysql (mariadb) on the command lineshawn l.green20 Aug 2014
Re: how to access Synology's mysql (mariadb) on the command lineshawn l.green20 Aug 2014
  • Re: how to access Synology's mysql (mariadb) on the command lineWybo20 Aug 2014