[BlueOnyx:09602] Re: mysql password for the GUI

[Michael Stauber]

Hi Gerald,

> I can login to mysql in a shell, phpMyAdmin works in the GUI
> 
> I have tried everything imaginable, but the GUI still indicates
>    MySQL connection cannot be established. Check settings.

BlueOnyx stores the MySQL "root" password in the class named "MySQL". Not in 
the subclass "mysql" of "System".

[root at sol ~]# /usr/sausalito/bin/cceclient 
100 CSCP/0.80
200 READY

find MySQL
104 OBJECT 30
201 OK

get 30
102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "the_password"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1322331581"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1322331581"
102 DATA sql_port = "3306"
102 DATA OID = "30"
102 DATA sql_root = "root"
201 OK

Like Dudi said: If the password is correct and it doesn't work for the GUI, 
then access from "localhost" to MySQL may not be working. This could be 
because MySQL is either not configured to listen on localhost, or maybe 
someone removed the privileges for "root at localhost". Typically there are two 
"root" users for MySQL configured. One for "root at localhost" (user root 
connecting from localhost) and "root@*" (root connecting from anywhere else).

If the localhost "root" user of MySQL has been removed, it can be added again 
this way:

http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQZoom;ItemID=26

-- 
With best regards

Michael Stauber