Setup MySQL Database

You need database to be installed first before you can start using AxGui software product. To setup your database, you must first download and install MySQL, (See:http://www.mysql.com After that, do the followings at command lines. You need to be root of Linux or administrator of Windows to run this command.

Type this

    mysql

    mysql> CREATE DATABASE AXGUI;
    mysql> GRANT ALL PRIVILEGES ON AXGUI.* TO yourname@localhost IDENTIFIED BY '12345';
    mysql> FLUSH PRIVILEGES;

If you can't connect to mysql, login as root or administrator and try this instead

    mysql -u root

If you still can't connect to mysql as root, please try to supply the password with this command

    mysql -u root -p

In case you want to change your root password you may do this

    mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YourNewPassword');

Once you have successfully connected to mysql command line with root privilege, you may start creating your database with the following instruction. If you want to connect it remotely from any host then use '%' instead of host name.

    mysql> CREATE DATABASE AXGUI;
    mysql> GRANT ALL PRIVILEGES ON AXGUI.* TO 'yourname'@'%' IDENTIFIED BY '12345';
    mysql> FLUSH PRIVILEGES;

The above step will create 'AXGUI' as database name with the following login

    Username : yourname
    Password : 12345

To check whether the user has been created, run the following commands

    SELECT * FROM mysql.user;

In addition, if you want to grant more privilages for additional permission such as creating TRIGGER do the followings.

    mysql> GRANT CREATE TRIGGER ON AXGUI.* TO 'yourname'@'%';
    mysql> FLUSH PRIVILEGES;

to remove permission for creating TRIGGER do this

    mysql> REVOKE CREATE TRIGGER ON AXGUI.* FROM 'yourname'@'%';
    mysql> FLUSH PRIVILEGES;

or just do this

    mysql> GRANT ALL ON AXGUI.* TO 'yourname'@'%';
    mysql> FLUSH PRIVILEGES;

to remove privilages type this

    mysql> REVOKE ALL ON AXGUI.* FROM 'yourname'@'%';
    mysql> FLUSH PRIVILEGES;