Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 I broke MySQL when I upgraded.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 22 July 2005 :  12:04:22  Show Profile
Just upgraded to the latest version of MySQL by following the instructions here and now I'm getting an "Access Denied" error when trying to connect to the database in ASP. I think I may need to recreate username & password I was using but don't know where to do this. UPDATE: Tried uninstalling and reinstalling and now I can't start the MySQL service (Error 1067: The service terminated unexpectedly).


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Edited by - Shaggy on 22 July 2005 12:27:54

Podge
Support Moderator

Ireland
3775 Posts

Posted - 22 July 2005 :  12:44:32  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
This happened to me recently. The problem was resolved for me when I did the following.

1. Disabled the MySql Service
2. Open MySqlAdministrator
3. Click on Service Control (left)
4. Click the Configure Service Tab
5. Change "Display Name" to something else e.g. MySQL41 instead of MySql
6. Click Apply
7. Restart server

Still haven't found out how to completely remove the "old" service.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 22 July 2005 :  12:49:47  Show Profile
Unfortunately the login that apparently got wiped/diabled during the first attempted install was the login I used to get into MySQL Admin. Tried reinstalling again, selecteing a different name for the service when configuring but still the same problem.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 22 July 2005 :  13:28:52  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
If you email me the rdc & MySql login details I can have a look. You should have been given an option to choose a new root password during re-install.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 25 July 2005 :  05:22:47  Show Profile
Sent! Much appreciated, man


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 25 July 2005 :  18:13:47  Show Profile  Visit Gremlin's Homepage
Newer versions have changed the password hashing system. First try just resetting the root password using this info

http://dev.mysql.com/doc/mysql/en/resetting-permissions.html

Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 26 July 2005 :  05:15:04  Show Profile
Thanks Gremlin, tried that but am still unable to login to MySQL Admin or Explorer or start the MySQL service.

UPDATE: Managed to get the service started by switching the configuration from Multifunctional Database to Non-Transactional Database (which doesn't sound right to me) but now the configuration wizard gives the follwing error when trying to apply the security settings and I'm told localhost is not allowed to connect to the MySQL server when trying to connect through ASP.
quote:
The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1130
Host 'localhost' is not allowed to connect to this MySQL server

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. [done] Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings. [done]

If you are re-installing after you just installed the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case, please select skip now and re-run the Configuration Wizard from the start menu. [done]
UPDATE: Tried resetting the password according to the link above and now I'm back to where I was, unable to start the service but still getting the error about localhost not being allowed to connect when I try to open the database with ASP. I am completely lost here, trying things I find with Google blindly, probably making things worse.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Edited by - Shaggy on 26 July 2005 06:30:11
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 26 July 2005 :  07:53:25  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
I'll have a look later when I get home.

BTW, that was exactly the problem that I had. Have you tried my first suggestion above?

Also, you will be importing the "live" database (which is currently on another server) at a later stage. Correct ?

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 26 July 2005 :  07:59:36  Show Profile
Thanks, man. Yeah, I've tried your initial suggestion but I can't login to MySQL Admin as root nor the other user. And, yeah, we'll be grabbing another copy of the database from the current server when we make the final move but there's a copy of the "data" folder as it was before I started tinkering on the dektop, if need be.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 27 July 2005 :  05:30:39  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Sent you an email late last night.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 28 July 2005 :  06:07:50  Show Profile
Received and replied. Many thanks, man


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 28 July 2005 :  06:37:39  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
I don't have access to my email at work. I'll check it when I get home.


Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 28 July 2005 :  06:41:39  Show Profile
Cool, ta.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 28 July 2005 :  10:31:49  Show Profile
'Ray, managed to fix the new issues after an extensive days Googling. For anybody else who may receive an error telling them to upgrade their MySQL client after upgrading to MySQL 4.1, there's two things you need to do:

01. Make sure you have the latest MyODBC Connector installed.

02. Follow the instructions in the link Gremlin posted above but, instead of passing your desired password through the PASSWORD function, pass it through old_PASSWORD.

And the rest of my problems were soplved simply by using MySQL Admin to give the user I was trying to connect as full permissions on the relevant database.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07