[otrs] MySQL Admin Problems

[Laurent Minost]

Hi,

Your problem seems to be only related with bad/insufficient privileges 
accorded to your otrs user.

phpMyAdmin is a web-based tool to easily manage MySQL servers, it could 
help on your case : http://www.phpmyadmin.net/

You will probably also need to read some documentations about MySQL 
Administration, you will find many howtos on Google, this one can be a 
beginning : 
http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic_MySQL_Configuration

Basic steps of the OTRS installation procedure can also be useful since 
it seems all is not properly configure on your current installation :
http://doc.otrs.org/2.2/en/html/c267.html

Best regards,

Laurent MINOST


Emily Flynn a écrit :
> Hi,
> 
>  
> 
> I’m running OTRS 2.1.7, and I’ve been having a problem with Apache 
> failing.  So I want to upgrade to 2.2 hoping this might fix it.   What 
> this entails is backing up the MySQL database, uninstalling the current 
> version of OTRS, and then reinstalling the new one, making sure to copy 
> over my config files. 
> 
>  
> 
> Now, I’m not knowledgeable of MySQL at all, so I want to use a 
> user-friendly application to work with the database in order to avoid 
> errors.  I downloaded and installed MySQL tools from the MySQL website, 
> and the Administrator tool is picking up the MySQL database using the 
> default OTRS Username and Password.  The Administrator isn’t connecting 
> to the database correctly however, when I so into User Administration, I 
> get the following error:
> 
>  
> 
> ‘A MySQL error was encountered.  The message is: Could not fetch user 
> names.  The following error occurred:  SELECT command denied to user 
> ‘otrs’@’localhost’ for table ‘user’ (1142).
> 
>  
> 
> As far as I can find out, this means that the proper user privileges 
> have not been set for the database, but I don’t know how to fix this, or 
> how to adjust and save the correct config files.
> 
>  
> 
> If someone could point me in the right direction, I’d really appreciate 
> it. 
> 
>  
> 
> Thanks!
> 
>  
> 
> Emily
>