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

[Gerald Waugh]

Gerald Waugh wrote:
> Gerald Waugh wrote:
>> 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.
>>
>> Tried resetting password in the GUI, see below, appears to work but
>> still get the error
>>
>> Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET  1 . mysql
>> "oldpass" "=" "-1" "newpass" "=" "password" "mysqluser" "=" "root"
>> "changepass" "=" "1329083620"
>> Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET succeeded
>>
>> Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET  33
>> "sql_rootpassword" "=" "password" "sql_host" "=" "localhost" "timestamp"
>> "=" "1329083620" "savechanges" "=" "1329083620" "sql_port" "=" "3306"
>> "sql_root" "=" "root"
>>
>> Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET succeeded
>>
>> Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET  1 . mysql
>> "dumpsize" "=" "- n/a -" "dumpdate" "=" "- n/a -" "enabled" "=" "1"
>>
>> Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET succeeded
>>
>>
> this does not look good?
> 
> [root at sv2 ~]# /usr/sausalito/bin/cceclient
> 100 CSCP/0.80
> 200 READY
> find system
> 301 UNKNOWN CLASS system
> 401 FAIL
> 
> 

should be "find System"

find System
104 OBJECT 1
201 OK
get 1.mysql
102 DATA NAMESPACE = "mysql"
102 DATA oldpass = "passwd"
102 DATA username = "root"
102 DATA dump = "1329084857"
102 DATA CLASSVER = "1.2"
102 DATA delete = ""
102 DATA newpass = "passwd"
102 DATA mysqluser = "root"
102 DATA onoff = "1329086877"
102 DATA password = ""
102 DATA dumpsize = "2k"
102 DATA changepass = "1329086486"
102 DATA dumpdate = "Feb 12 2012 - 4:14 pm"
102 DATA enabled = "1"
201 OK

So that all looks OK, but still get the error
passwd above is the actual password I set the root password to.
MySQL connection cannot be established. Check settings.

-- 
Gerald