zCI Computer Inventory System

Hi,

MySQL login also control the originating host. Please check whether the MySQL console works from zCI server.

This is sample GRANT command from MySQL documentation (% means all hosts):

After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts:

mysql> GRANT ALL PRIVILEGES ON . TO 'monty'@'localhost' -> IDENTIFIED BY 'somepass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON . TO 'monty'@'%' -> IDENTIFIED BY 'somepass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON . TO 'admin'@'localhost'; mysql> GRANT USAGE ON . TO 'dummy'@'localhost';

The accounts created by these GRANT statements have the following properties