[otrs] MySQL Admin Problems

[Emily Flynn]

Thanks for your answer Laurent.  It turns out I was logging into the
database with the default MySQL 'user' as opposed to 'root'.  So when I
logged in as root admin, all was fine, I changed passwords, created a user,
and I can go about managing the database.  

I'm actually running otrs on an XPSP2 machine, and I tried PHPMyAdmin
already, but I had difficulties installing the PHP.  During the installation
of PHP, a list of available extensions are given and It's recommended to
install only the necessary extensions as problems can arise if you install
everything (I did try that - and problems did indeed arise..).  

I couldn't find out which were the correct extensions to install (this was
my first encounter with PHP) and when someone suggested the desktop GUI
MySQL Administrator, I thought I'd try that. 

I still would have like to get PHP installed, as it could be something I'd
look into working with.  

If anyone knows what extensions I should install, I'd gladly take any
advice!

Thanks again

-Emily


-----Original Message-----
From: otrs-bounces at otrs.org [mailto:otrs-bounces at otrs.org] On Behalf Of
Laurent Minost
Sent: 06 November 2007 11:03
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] MySQL Admin Problems

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
> 

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/