20.26 MySQL Remote User Permissions
On any host in domain togaware.com user kayon would like to connect to the customers database with select privileges on the MySQL server running on alpine.togaware.com.
You can arrange this as follows. The first insert adds this user’s password to the users table. The second then gives this user access to a particular database.
On alpine.togaware.com:
alpine$ mysql -u root -pYYYYYY mysql
mysql> insert into user (host,user,password)
-> values ('%.togaware.com', 'kayon', password('XXXXXX'));
Query OK, 1 row affected (0.00 sec)
mysql> insert into db (host,db,user,select_priv)
-> values ('%.togaware.com', 'customers', 'kayon', 'Y');
Query OK, 1 row affected (0.00 sec)
mysql> exit
alpine$ mysqladmin -u root -pYYYYYY reloadThen on inco.togaware.com, for example:
Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0
