Reset Mysql root password on windows

Apr 15

SuspenceMysql, Windows No Comments

reseting a mysql password on windows

1.  stop mysql

2.  Open a command prompt by selecting Start>   run>   typing in cmd

3.  Changed directory to C:\program files\mysql\MySQL Server 5.1_orig\bin by running
cd “C:\program files\mysql\MySQL Server 5.1_orig\bin”

4.  Started mysql from the command line with:
mysqld –defaults-file=”C:\Program Files\MySQL\MySQL Server 5.1\my.ini” –skip-grant-tables

5.  Opened a 2nd command prompt

6.  Changed directory to C:\program files\mysql\MySQL Server 5.1_orig\bin

7.  log into mysql by typing
mysql

8.  select the database
USE mysql

9.  update the password
UPDATE user SET password=(‘ ‘) WHERE user=’root’;

10. exit mysql

11. kill the mysql service running in the first command prompt with
taskkill /F /IM mysqld.exe

12. Start mysql normally

13.  from the command prompt or the mysql command line client connect to mysql
mysql -uroot -p
just hit enter for the password

14.  update permissions
GRANT all on *.* to root@’localhost’ identified BY ‘newpassword’;
GRANT all on *.* to root@’%’ identified BY ‘newpassword’;
flush PRIVILEGES;

15. exited out of mysql

16.  tested new password with
mysql -uroot -p
this time entering the password specified.

MySql Upgrade on Windows

Apr 15

SuspenceMysql, Windows No Comments

A quick way to upgrade mysql on a windows server without using an installer

1.  download the mysql-noinstall 32/64 bit version from  mysql

2.  stop mysql

3.  Extract the folder to c:\program files\mysql

4.  Renam the MySQL Server 5.1 folder to MySQL Server 5.1_orig

5.  rename the extracted folder to MySQL Server 5.1

6.  copy C:\program files\mysql\MySQL Server 5.1_orig\data to C:\program files\mysql\MySQL Server 5.1\data

7.  copy C:\program files\mysql\MySQL Server 5.1_orig\my.ini to C:\program files\mysql\MySQL Server 5.1\my.ini

8.  Start mysql

9.  Open a command prompt by selecting Start>   run>   typing in cmd

10.  Change directory to C:\program files\mysql\MySQL Server 5.1_orig\bin by running
cd “C:\program files\mysql\MySQL Server 5.1_orig\bin”

11.  upgrade mysql by running
mysql_upgrade
This syncs up the databases with the newly installed version.

Migrate from IIS7 to IIS7

Mar 12

SuspenceIIS, Windows No Comments

log into the originating server, open a command prompt and run:

cd %windir%\system32\inetsrv

appcmd add backup backupname

Then copy over %windir%\system32\inetsrv\backup\backupname from the originating server to the server you’re migrating too.

on the ending server open up a command prompt and run:

cd %windir%\system32\inetsrv

appcmd restore backupname

Then update any IPs/file paths in IIS.