Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
MySQL Administrator problem - SOLVED!
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL Administrator problem - SOLVED!
MySQL Administrator problem - SOLVED!
07-08-2008 12:46 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hi
I've got two completely independent PlusNet accounts, Work and Home. For the purpose of this thread i will refer to them as work and home
I have MySQL Administrator installed on my PC at work and use it to connect to my work_pn database. I want to use it to connect to home_pn as well but i am having the following problem when i connect to MySQL Server instance.
Could not connect to the specified instance
MySQL Error Number 1045
Access denied for user 'home'@'work.plus.com' (Using password: YES)
Server Host: humbug.plus.net Port: 3306
Username: home
password: **********
All the info in the connection dialog is correct but it would appear that because i am at work, i can only access my work account because there isn't anywhere that i can find that i have specified 'home.plus.com' within MySQL Administrator
Can anybody help me out with this?
I've got two completely independent PlusNet accounts, Work and Home. For the purpose of this thread i will refer to them as work and home
I have MySQL Administrator installed on my PC at work and use it to connect to my work_pn database. I want to use it to connect to home_pn as well but i am having the following problem when i connect to MySQL Server instance.
Could not connect to the specified instance
MySQL Error Number 1045
Access denied for user 'home'@'work.plus.com' (Using password: YES)
Server Host: humbug.plus.net Port: 3306
Username: home
password: **********
All the info in the connection dialog is correct but it would appear that because i am at work, i can only access my work account because there isn't anywhere that i can find that i have specified 'home.plus.com' within MySQL Administrator
Can anybody help me out with this?
Message 1 of 5
(2,762 Views)
4 REPLIES 4
Re: MySQL Administrator problem
07-08-2008 6:06 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Are both accounts actually using humbug? PlusNet have 2 MySQL servers, the other one is called rumpus and a plusnet account may be assigned to use one or the other - this will be detailed in the MySQL activation email.
You are using the MySQL password detailed in the email and not your portal password?
You are using the MySQL password detailed in the email and not your portal password?
Message 2 of 5
(763 Views)
Re: MySQL Administrator problem
08-08-2008 8:14 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hi Peter
Yes, both work and home happen to be on the humbug server.
Yes, the password is the one that came from the dbcreator@plus.net email
The problem appears to be related to the fact that it knows to connect to 'work.plus.com' but i cant find anywhere that i have referenced that.
I've checked all the xml files in the install location, I've checked the registry and I've checked through all the options and config settings in MySQL Administrator. I cant find 'work.plus.com' anywhere so it must be server side in which case it must be related to the fact that i am connecting to my work broadband connection?
Hope this makes sense
Yes, both work and home happen to be on the humbug server.
Yes, the password is the one that came from the dbcreator@plus.net email
The problem appears to be related to the fact that it knows to connect to 'work.plus.com' but i cant find anywhere that i have referenced that.
I've checked all the xml files in the install location, I've checked the registry and I've checked through all the options and config settings in MySQL Administrator. I cant find 'work.plus.com' anywhere so it must be server side in which case it must be related to the fact that i am connecting to my work broadband connection?
Hope this makes sense
Message 3 of 5
(763 Views)
Re: MySQL Administrator problem
08-08-2008 8:35 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
It looks to me like the MySQL permissions have been set up to only allow you access from the relevant connection.
It may be possible to request access from another site, but I wouldn't hold your breath as it would be outside the realms of something that could be handled in Workplace.
Possibly worthwhile raising a ticket asking if you could have access from 'work'@'home.plus.com' and 'home'@'work.plus.com'
B.
It may be possible to request access from another site, but I wouldn't hold your breath as it would be outside the realms of something that could be handled in Workplace.
Possibly worthwhile raising a ticket asking if you could have access from 'work'@'home.plus.com' and 'home'@'work.plus.com'
B.
Message 4 of 5
(763 Views)
Re: MySQL Administrator problem
08-08-2008 10:24 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Solved 
I deleted both my home and work stored connections from within MySQL Administrator and closed it.
I re-launched it and entered the credentials for my home connection and it went in straight away, no probs. However, becasue this was not a stored connection, there were some areas i couldn't interact with. ie. Backup Schedule.
I added both home and work as stored connections and now everything is fine and i can very easily connect to either my home or work databases.
The help files don't explain any of this but i would definately recommend MySQL Administrator as it is far better, quicker and easier than the online method of administering your databases.

I deleted both my home and work stored connections from within MySQL Administrator and closed it.
I re-launched it and entered the credentials for my home connection and it went in straight away, no probs. However, becasue this was not a stored connection, there were some areas i couldn't interact with. ie. Backup Schedule.
I added both home and work as stored connections and now everything is fine and i can very easily connect to either my home or work databases.

The help files don't explain any of this but i would definately recommend MySQL Administrator as it is far better, quicker and easier than the online method of administering your databases.
Message 5 of 5
(763 Views)
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL Administrator problem - SOLVED!