Page tree

Create Read Only MySQL Users

Though the standard configuration includes a read-only ewreader MySQL user, it is only allowed to connect to the database from localhost and is re-created during installations and updates with a different password. As such it is not usable for external report engine connectivity.


If the database is recreated during upgrade this user will be lost and will have to be re-created.

This however only happens when the version of MySQL is upgraded and if the upgrade requires data to be recreated.

If in doubt, verify that external connectivity is retained after upgrade.

Follow These Steps


  1. From the Agiloft host log into embedded MySQL instance as administrative level user: 

    host:~ youruser$ /usr/local/EnterpriseWizard/mysql/bin/mysql -uroot
    -p --socket=/usr/local/EnterpriseWizard/mysql/ewdbsocket -A sw2_std
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 9033
    Server version: 5.0.67-log MySQL Community Server (GPL) 
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 
  2. Create a new user and grant appropriate read permissions: 

    mysql> create user <USER> identified by '<PASSWORD>';
    mysql> grant select on sw2_std.* to <USER>;
    mysql> exit 


    mysql> create user myuser identified by 'mypassword';
    mysql> grant select on sw2_std.* to myuser;
    mysql> exit
  3. Verify connectivity with the new user by logging into MySQL again: 

     <databaseServerHome>/bin/mysql -u_USER_ -p
    --socket=<databaseServerHome>/ewdbsocket -A sw2_std