Stuart Bird wrote:
> Andy
>
> "It could be as a simple as:
>
> mysql> create user 'your_username'@'%' identified by 'your_pass'; grant
> mysql> all on yourdb.* to 'your_user'@'%';"
>
> I'm not quite sure what you man by that as I am very new to MySql, could you
> elaborate a bit if you have the time.
>
Starting at a shell prompt:
mysql -uXXX -p
.. where XXX is your MySQL admin user. Once at the mysql command prompt:
create user 'YYY'@'%' identified by 'ZZZ';
.. will create user YYY (password ZZZ) with access from anywhere (which
is what the % means). You can limit it to a single host
('YYY'@'192.168.10.100') etc, the mysql docs will give you more choices.
grant all on AAA.* to 'YYY'@'%'
.. grants all privileges to the user (except the ability to grant
privileges to other users) to all tables on the AAA. database. In other
words the ability to query the database and update it. Replace AAA.*
with *.* for all tables in all databases.
Dunno how much that helps?
--
Mark Rogers
More Solutions Ltd :: 0845 45 89 555
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
