GNU/Linux Desktop Survival Guide by Graham Williams
Desktop Survival Project Home Preface Advocacy History Distributions Installation Basic Survival Wajig Audio AbiWord APM Backup Bash Booting Cameras CD Chinese ChRoot Clock Commercial Conference Management Configuration CRON CVS Databases DIA Directories Disks Documentation DVD Email Eye of Gnome Evolution File Systems Firewalls Floppy Disks Fonts Ghemical GIMP Glade Gnome GnuCash Gnumeric GQView Graphics Groups HTML Editors ImageMagick Initialisations on Booting Java KDE Kernels Keyboard Konqueror KVM Switch LaTeX Log System Login Magellan Mathematics Memory Modems Mounting Devices MS/Windows Music MySQL Nautilus Networks NFS NT File System OpenOffice.org Oracle Packages Partitions Passwords PDF Photos PPP Presentations Printing Python R Remote Desktops Rsync Samba Scanning Science Security SH File System Sketch Spell SPlus Spruce SSH SUDO Subversion Swap Themes USB Video Virtualization Web Word X XML Sample Installations Troubleshooting Index

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 reload

Then on inco.togaware.com, for example:

  inco$ mysql -h alpine -u kayon -pXXXXXX customers -e 'show tables'