[BlueOnyx:04298] Re: MySQL/phpmyadmin error

[Trond Husø]

Can you check the value for my.cnf in /etc/ (maybe /etc/mysql/ )
bind-address

If it is marked out, mark it in and restart mysql

If it is marked in, mark it out and restart mysql

- Then check if you can connect through myphpadmin

-t-



On Sun, 2010-04-18 at 12:19 -0500, Don Teague wrote:
> That shows me my current user/pass to mysql ... connection via command
> line has always worked.
> 
> Many, many attempts to change the password in the GUI have failed.
> 
> On Sat, Apr 17, 2010 at 11:43 PM, Greg Kuhnert
> <greg.kuhnert at theanchoragesylvania.com> wrote:
> > I have seen something like this once before recently. In the other case,
> > BX got out of sync with mysql after a mysql database restore. To check
> > the details in the BX database, follow the steps below:
> >
> > Step 1. Login to CCE
> > /usr/sausalito/bin/cceclient
> >
> > Step 2: Find the system object - "find system"
> > 100 CSCP/0.80
> > 200 READY
> > find System
> > 104 OBJECT 3
> > 201 OK
> >
> > In the line above we got the object # 3 for the system object.
> >
> > Step 3: Now - lets get mysql settings. The get command below will need
> > to have the same object number you found above for the system object.
> >
> > get 3.mysql
> > 102 DATA NAMESPACE = "mysql"
> > 102 DATA oldpass = "myoldpassword"
> > 102 DATA username = "root"
> > 102 DATA dump = ""
> > 102 DATA CLASSVER = "1.2"
> > 102 DATA delete = ""
> > 102 DATA newpass = "mynewpassword"
> > 102 DATA mysqluser = "root"
> > 102 DATA onoff = "1260254639"
> > 102 DATA password = ""
> > 102 DATA dumpsize = "- n/a -"
> > 102 DATA changepass = "1267708176"
> > 102 DATA dumpdate = "- n/a -"
> > 102 DATA enabled = "1"
> > 201 OK
> > bye
> > 202 GOODBYE
> >
> > Step 4: Try to connect to mysql with the settings found in the database
> > above. Use the username found in the mysqluser field, and try using the
> > password found in "newpass". If it works, I am puzzled .... but if it
> > doesnt work, you've found your culprit. Just do a password change in the
> > gui, and all will be fixed.
> > _______________________________________________
> > Blueonyx mailing list
> > Blueonyx at blueonyx.it
> > http://www.blueonyx.it/mailman/listinfo/blueonyx
> >
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx


-- 
Trond Husø
-----------------------------
PHP-developer
Linux (Ubuntu/Fedora/CentOS) user and Administrator
www.trondhuso.no