Mysql Administrator Issue

[TheMovieman]

Hi all,

 

For the first since switching to DSL, I tried to look at my database via MySQL Administrator. Now, while I can log in, it won't show my available databases and instead there's nothing listed and the dot in the lower left corner is red and does nothing. I'm new to this and didn't know if I needed to change port settings or what. I'm using a 2Wire Router/Modem, btw.

 

Any help would be appreciated

[TCH-Don]

When you first set it up

didn't you have to authorize your IP in CPanel / MySQL Databases, Access Hosts ?

DId you add the new IP ?

[TheMovieman]

Yeah, I went in and added the IP address to allow the access.

[TheMovieman]

Oh, and I had set it up before I got DSL (I was using dial-up). And while it will log in but will not "fetch" my databases.

[TheMovieman]

I would've edited my post above, but there's not button to do so...

 

 

Anyways, it's able to retrieve my server status. I still don't understand why it won't retreive my database info and I've tried a few things and searched around the Net but still nothing. I'm sure it has something to do with my modem/router but I even tried checking around that in the firewall.

 

For now I can use cpanel, but it's easier using MySQL Admin.

[TCH-Bruce]

Change the IP to allow field to a % and see if that works. That is a wildcard to allow any host to connect. Let us know if you still have problems.

[TheMovieman]

Do I do this in cpanel or the MySQL Admin? I've added the % wildcard to "Access Hosts" in cpanel but that did nothing either. I also looked over the MySQL Adm and I didn't see any fields there. If the former, it's still not showing my DBs.

[erisande]

Do I do this in cpanel or the MySQL Admin? I've added the % wildcard to "Access Hosts" in cpanel but that did nothing either. I also looked over the MySQL Adm and I didn't see any fields there. If the former, it's still not showing my DBs.

I had something like this happen. My suggestion:

Go into: CPANEL > MySQL Databases

 

At the bottom, see "Add users to your databases"

 

Re-add the user to the database. (no need to delete the user and readd, JUST readd.)

 

I do not guarantee this will work, but it made a big difference to me twice. I hope I helped some.

[TheMovieman]

Thanks erisande! Worked perfectly