MySQL 安装时可能出现的问题

It seems that the port 3306 is already in use.aer you sure you want to use this port?
安装过程中,如果出现该提示,请关闭mysql服务,再删除mysql服务(sc delete mysql ,出现[SC] DeleteService SUCCESS即删除成功),然后继续安装。

如果不删除mysql服务,后面会安装过程中还会报下面错误:Cannot create Windows Service for MySQL.Error:0,报这种错误就是因为mysql服务已经存在,无法重名创建服务。

如果创建完mysql服务后无法启动,报Mysql 本地计算机无法启动 mysql 服务 错误 1067:进程意外终止

解决方法:打开my.ini文件,找到default-storage-engine这一行,把它改成default-storage-engine=MyISAM


有时候缷载mysql时可能缷载不彻底,推荐缷载方法:

 (1) 开始-MySQL-MySQL Server 5.1-MySQL Server Instance Config Wizard--->Remove Instance。
(2)点击[开始]--[运行],输入services.msc回车,进入服务管理窗口。
(3)服务里面找到MySQL服务,将MySQL的服务给停止。
(4)点击[开始]--[运行],输入console回车进入控制面板,找到添加删除程序,找到MySQL选择卸载。
(5)这步很重要,之前不管我怎么卸载MYSQL清空残余文件都还是要输入原始密码,后来试试找了下注册表,清空后果然有效。
        删除注册表数据,通过regedit,删除以下几个文件【也可以在注册表里搜索mysql】:
        HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL
        HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL
        HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL
        HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services一般服务会以相同的名字(名字通常是MySQL)在这里显示一个主健,直接删除相关的键值便可。
(6)最后将MySQL安装目录和保存数据库数据的目录也删除。
         通常这两个目录分别在C:\program files\mysql 和 C:\Documents and Settings\All Users\Application Data【或C:/Documents and Settings/All Users/Application Data】(这个目录是不确定的,最好是在c盘里使用搜索“mysql”关键字来查找)。目录有可能是隐藏的,需要设置文件夹选项显示隐藏目录。
(7)重新启动机器。   
            到此原mysql已经被完全卸载。




PowerCommands 1.1 is a set of useful extensions for the Visual Studio 2008 adding additional functionality to various areas of the IDE. The source code is included and requires the VS SDK for VS 2008 to allow modification of functionality or as a reference to create additional custom PowerCommand extensions. Below is a list of the included in PowerCommands for Visual Studio 2008 version 1.1. Refer to the Readme document for additional command details and screenshots. Enable/Disable PowerCommands in Options dialog This feature allows you to select which commands to enable in the Visual Studio IDE. Point to the Tools menu, then click Options. Expand the PowerCommands options, then click Commands. Check the commands you would like to enable. Note: All power commands are initially defaulted Enabled. Format document on save / Remove and Sort Usings on save The Format document on save option formats the tabs, spaces, and so on of the document being saved. It is equivalent to pointing to the Edit menu, clicking Advanced, and then clicking Format Document. The Remove and sort usings option removes unused using statements and sorts the remaining using statements in the document being saved. Note: The Remove and sort usings option is only available for C# documents. Note: Format document on save and Remove and sort usings both are initially defaulted OFF. Clear All Panes This command clears all output panes. It can be executed from the button on the toolbar of the Output window. Copy Path This command copies the full path of the currently selected item to the clipboard. It can be executed by right-clicking one of these nodes in the Solution Explorer: The solution node; A project node; Any project item node; Any folder. Email CodeSnippet To email the lines of text you select in the code editor, right-click anywhere in the editor and then click Email CodeSnippet. Insert Guid Attribute This command adds a Guid attribute to a selected class. From the code editor, right-c
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值