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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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, > > > > Im running OTRS 2.1.7, and Ive 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, Im 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 isnt 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 > [EMAIL PROTECTED] 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 dont know how to fix this, or > how to adjust and save the correct config files. > > > > If someone could point me in the right direction, Id 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/ _______________________________________________ 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/
