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'
Research the GRANT command itself (and the other account management
commands) to see what else you can do while creating an account or
adjusting permissions.
http://dev.mysql.com/doc/refman/5.6/en/account-management-sql.html
Examples of the types of host patterns you can use are also in the
manual, here:
http://dev.mysql.com/doc/refman/5.6/en/account-names.html
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
