Can't Open Database

[flixer]

Hi guys,

I have a really strange problem here. My webhost recently changed the server/IP of my webserver. I can log into my control panel and use phpmyadmin to work on my database fine.

However, I cant open the database using sqlyog. I have entered the new IP into the connection details – the strangest thing is, it DOES connect to the database SERVER but when I try to open the database I get the error:

Error No.1044

Access denied for user '[email protected]' to database 'databasename'

I really dont want to go back to using phpmyadmin, so any help is much appreciated,

regards

[navyashree.r]

Hi,

You must have at least SELECT privilege (as a global privilege or a SCHEMA/COLUMN privilege, to be able to see any data).

Please go through the below FAQ links,

http://www.webyog.com/faq/content/23/42/en…ror%20no%201044

http://www.webyog.com/faq/content/23/41/en…ses_tables.html

Regards,

Navya

[peterlaursen]

Let me add that if you use 'shared hosting' you may not be able to use SQLyog for user/privileges management.

It is common with shared hosting that users can only be managed from the webbased admin panel available.

[flixer]

Hmmm. I am using the same user account that I use via the control panel/phpmyadmin. Yes peterlaursen it is a shared hosting package, but its always been so, and SQLyog has always worked perfectly.

This is quite annoying, I will have to log into my control panel and phpmyadmin and take another look at my privilege settings again, but the fact is I have not touched any of this, the only thing that has changed is the server IP. Looks like I will have to contact my webhost again and see if they can help me any further.

Any further suggestions appreciated.

[peterlaursen]

“and SQLyog has always worked perfectly.”

If so something must have changed on the server! I think only the helpdesk could tell what it is. The privileges system on sahred hosting can be a little complicated – because not only MySQL privileges are involved but also OS/file system privileges

[flixer]

I have spoken to the webhost techies again. Unfortunately because I can administrate my database perfectly fine with the control panel/phpmyadmin there is nothing else they can do for me. Im rather disappointed with there response because they have always being extremely helpful in the past.

I will perhaps try creating a new saved connection with SQLyog and see if it makes any difference, but it looks like i'll have to go back to crappy phpmyadmin 🙁

[flixer]

WERHOOOOOOOO – just created a new user in my control panel, added it to the access list for my database and then added the new username/password to sqlyog and I can now open the database!!!!! 😀

No idea why the original user account wouldnt work, it has full priviledges, anyhow, i'll just use this new account for sqlyog 😀

[Author]

Posts