[gentoo-user] MySql administrator

[gentoo-user] MySql administrator

[Rupert Young (Restart)]

[-- Attachment #1: Type: text/plain, Size: 153 bytes --]

Hi,

 

After upgrading mysql to 4.0.25 I can no longer access the db from my PC
using MySql administrator. Any ideas?

 

Regards,

 

Rupert Young

 


[-- Attachment #2: Type: text/html, Size: 2326 bytes --]

Re: [gentoo-user] MySql administrator

[Norberto Bensa]

Rupert Young (Restart) wrote:
> After upgrading mysql to 4.0.25 I can no longer access the db from my PC
> using MySql administrator. Any ideas?

I don't use mysql administrator myself but:

Have you re-emerged mysql administrator?
What interface is mysql administraror using (127. or something else)?
Does mysql have permissions to that interface? 
Is your current installed version of mysql administrator compatible with mysql 
4.0.25?

Regards
-- 
Norberto Bensa
4544-9692
Ciudad de Buenos Aires, Argentina
-- 
gentoo-user@gentoo.org mailing list

RE: [gentoo-user] Tomcat JSP access - was MySql administrator

[Rupert Young (Restart)]

The more serious problem was that my JSPs were not able to access the
database as they had before. This error is from my log

DCP: Error-1 in sql connection:java.sql.SQLException: DCP: Couldn't get the
connection:url=jdbc:mysql://192.168.1.40/webshop

However, when I change to jdbc:mysql://localhost/webshop it works. So in my
major emerging upgrade something about the network access has changed (maybe
nothing to do with mysql).

Any ideas where these settings are?

Regards,
 
Rupert Young

> -----Original Message-----
> From: Norberto Bensa [mailto:nbensa@gmx.net]
> Sent: 26 September 2005 03:20
> To: gentoo-user@lists.gentoo.org
> Cc: Rupert Young (Restart)
> Subject: Re: [gentoo-user] MySql administrator
> 
> Rupert Young (Restart) wrote:
> > After upgrading mysql to 4.0.25 I can no longer access the db from my PC
> > using MySql administrator. Any ideas?
> 
> I don't use mysql administrator myself but:
> 
> Have you re-emerged mysql administrator?
> What interface is mysql administraror using (127. or something else)?
> Does mysql have permissions to that interface?
> Is your current installed version of mysql administrator compatible with
> mysql
> 4.0.25?
> 
> Regards
> --
> Norberto Bensa
> 4544-9692
> Ciudad de Buenos Aires, Argentina
> --
> gentoo-user@gentoo.org mailing list



-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Tomcat JSP access - was MySql administrator

[Norberto Bensa]

Rupert Young (Restart) wrote:
> DCP: Error-1 in sql connection:java.sql.SQLException: DCP: Couldn't get the
> connection:url=jdbc:mysql://192.168.1.40/webshop
>
> However, when I change to jdbc:mysql://localhost/webshop it works. 

It seems mysql is only accepting connections on 127.0.0.1 (localhost)


> Any ideas where these settings are?

Look in /etc/mysql/my.cnf and /etc/mysqlaccess.conf


>
> Regards,
>
> Rupert Young

Regards,

-- 
Norberto Bensa
4544-9692
Ciudad de Buenos Aires, Argentina
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] MySql administrator

[Daniel da Veiga]

This is far more a MySQL question than a Gentoo one. Have you located
a script called mysql_fix_privileges somewhere? I believe there was a
change in password format from the version you had and the upgraded
one. Maybe start the server with the OLD_PASSWORD parameter to test...

And check the version for Administrator, maybe you need an upgrade too.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
gentoo-user@gentoo.org mailing list