TRIUMF Grid System Management Documentation

MySQL Notes

  • setting a mysql root user password:
    # mysqladmin -u root password 'xxxxxxxx'
  • creating a user:
    # grant SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER
    on put_name_of_db_here.*
    to some_user@localhost identified by 'yourPassword',
     some_user@'192.168.1.%' identified by 'yourPassword';