February 26th, 2013, 01:30 PM
Lots of Problems with MySQL
I have used MySQL before, but I am kind of new with it at the same time. I recently had to do a clean install on my PC so I lost my last configuration of MySQL and IIS and all that. I reinstalled and now I am having tons of different problems.
My first problem is, how do I change the SA password? I remember setting a password during setup, and I entered that password. I used the same password just incase, and it doesn't work at all and that is the only password it had me set and I don't even think it was for the SA account.
I am trying to install phpBB in IIS Express using Microsoft Web Platform Installer 4.5 and everytime I try to install it a box comes up asking for the SA Password for /.MySQL account and I trid the password and it doesn't work. So I can't login and I can't install anything with MySQL.
I looked it all up and I found an article that says to do this:
1. Start a Command Prompt as NT Authority\Network Service
- Open Command Prompt
- Type the following commands to create a new service that launches Task Manager (note the spaces after the equals sign): sc create MyService binPath= %WINDIR%\system32\taskmgr.exe type= interact type= own
- Right click on 'Computer' and go to 'Manage'
- Open up services and find MyService, right click on it and start it. (If you are in server 2008 it will ask you to view an interactive service message, click show me the message)
- When Task Manager appears, Select File ->New Task (Run..) and type cmd. You now have a cmd prompt running as NT Authorty/Network services
Enable the SA Account (if not active)
- In the command prompt type: osql -S TheNameOfYourSQLServer -E
- Type this where it displays 1> ALTER LOGIN sa ENABLE
- Type this where it displays 2> GO
Reset the SA Account's Password (if this is the first time it has been used, it may be blank already)
- In the command prompt, if you didn't do this is the last step, type: osql -S TheNameOfYourSQLServer -E
- Type this where it displays 1> sp_password NULL,'NewPassword','sa'
- Type this where it displays 2> GO
I have found some other ways of doing it, but they are mostly for 2005 or 2008 or something, I don't even know what version I am using. I just downloaded it fromt the MySQL site a couple days ago, its the most recent. Nothing is working though.
Let's start at the top, I am getting some errors! I can get sc create MyService binPath= %\WINDIR%\System32\taskmgr.exe type= interact type= own to be created but when I go to services to start it, it gets about 3/4 of the way done and the taskmanager pops up and then goes away once I see the error. I get the following error:
"Windows Could not start the MyService service on Local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion."
Whenever I type osql -S MySQLServer -E in the command prompt ran as administrator (MySQLServer is my servername) I get the following error:
C:\Windows\System32>osql -S MySQLServer -E
[SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server .
[SQL Server Native Client 10.0]Login timeout expired
[SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books online.
I found an article saying to go to the configuration manager and disable the Named Pipes but that didn't work so I enabled it again.
Like I said I have been searching for hours now and I can not figure this out for the life of me. I have never had this many problems!!
Any help will be apprecaited. Thanks in advance!
February 26th, 2013, 05:22 PM
I'm not really sure what you are talking about since it looks like you have mixed up MySQL and Microsoft SQL Server.
Most of the parts where you are talking about SA password and running the "osql ....", 2005 and 2008, etc are about Microsoft SQL Server.
But you have posted this question in the MySQL forum which has nothing to do with SQL Server.