Locked Out Of MySQL

[jazzer386]

unamanic:

Re: http://www.witt-family.net/fedora/mysql-administrator.png

My Applications>Programming>MySQL Administrator doesn't look like that.

Instead, it is a much smaller box and it asks for:

1. Stored Connection;
2. Server Hostname;
3. Port;
4. Username; plus
5. Password.

In the bottom-left corner, there is a button called: "Details>>".

Any idea on what I can do to resolve this?

- j

[unamanic]

assuming you are an the same box as the server:
hostname: localhost
port: 3306
username: root
password: [mysql root password]

[jazzer386]

unamanic:

Thanks for the info.

It didn't quite work the way you described, but I do appear to have gotten access, to the MySQL Administrator you have posted.

So, thanks!

I need some time to examine this, now.

I'll let you know how it goes.

Thanks, again, though.

- j

[jazzer386]

MySQL appears to be able to log onto the database so long as I log on via "localhost", only.

"Could not connect to 'ipaddress'.
MySQL Error Nr. 1130.
Host '192.168.1.1' is not allowed to connect to this MySQL server."

Yes. The connection could ping via the ipaddress - just not connect.




Any thoughts on how to log on, via the ipaddress, so I could log on via my remote xp client?




- j

[jazzer386]

This appears to be different: This time, when trying to get my xp client to log onto my f9 machine's mysql database, an "error #10061" message was generated.

I tried googling around for a solution, but still haven't found one.

According to one site, 10061 means that MySQL is not listening, at port #3306.

This plus another site point to "bind-address", in my.cnf, as the culprit.

Yet, I have looked at my.cnf and found nothing about bind-address.

Another site blamed my password; apparently, the reason why I could log onto the database via "localhost" was because "localhost" involved no password. A remote host, however, did.

The site recommended using:

>mysql test -h localhost -u username -ppasswd
	- Access denied using PW (YES)

But I'm not sure why.

Does anyone know how to resolve a 10061?

- j

[jazzer386]

I'm leaving this issue and proceeding to the next task, on my f9 list of things to do.

I'm concluding that the 10061 error message is indicative of a bug that might be fixed in future updates.

Until then, I'll just rely on "localhost" (MySQL Administrator) instead of my remote xp client.

- j