MySQL安装问题小结

一、mysql装完电脑里面没mysql相关服务

在完成安装Mysql5.6后，使用mysql时，打开cmd，输入net start mysql，提示服务名无效，查看服务列表,也结果找不到mysql相关的服务，可以用下面方法去解决。解决方案：1、打开cmd，切换到mysql的bin目录下 （这个需要根据自己电脑mysql安装位置查找，下面是我的电脑上mysql安装目录）

2、 C:\Program Files(x86)\MySQL5.6\bin>mysqld.exe -install

Service successfully installed.

3、 C:\Program Files(x86)\MySQL5.6\bin>net start mysqlMySQL 服务已经启动成功

4.现在打开服务列表，就可以看到mysql服务了。

二、mysql command line client打不开(闪一下消失)的解决办法

1、找到 mysql安装目录下的bin目录路径。
2、打开cmd，进入到bin目录的路径下，输入mysql -u root -p。

问题分析：
1、查看mysql command line client默认执行的一些参数。方法：开始->所有程序->MySQL->MySQL Server5.5->MySQL5.5 command line client,右键属性。
 

id="iframe_0.3353252683300525" src="data:text/html;charset=utf8,%3Cimg%20id=%22img%22%20src=%22http://www.2cto.com/uploadfile/2012/0908/20120908013118967.jpg?_=0.6828206260688603%22%20style=%22border:none;max-width:999px%22%3E%3Cscript%3Ewindow.onload%20=%20function%20()%20%7Bvar%20img%20=%20document.getElementById('img');%20window.parent.postMessage(%7BiframeId:'iframe_0.3353252683300525',width:img.width,height:img.height%7D,%20'http://www.cnblogs.com');%7D%3C/script%3E" frameborder="0" scrolling="no" style="margin: 0px; padding: 0px; border-style: none; width: 750px; height: 276px;">

 
2、注意看目标的内容。内容比较长，复制出来如下：

"G:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" "--defaults-file=G:\Program Files\MySQL\MySQL Server 5.5\my.ini" "-uroot" "-p"
 

id="iframe_0.12442073598504066" src="data:text/html;charset=utf8,%3Cimg%20id=%22img%22%20src=%22http://www.2cto.com/uploadfile/2012/0908/20120908013118256.jpg?_=0.5110011091455817%22%20style=%22border:none;max-width:999px%22%3E%3Cscript%3Ewindow.onload%20=%20function%20()%20%7Bvar%20img%20=%20document.getElementById('img');%20window.parent.postMessage(%7BiframeId:'iframe_0.12442073598504066',width:img.width,height:img.height%7D,%20'http://www.cnblogs.com');%7D%3C/script%3E" frameborder="0" scrolling="no" style="margin: 0px; padding: 0px; border-style: none; width: 382px; height: 482px;">

3、注意"--defaults-file=G:\Program Files\MySQL\MySQL Server 5.5\my.ini" "-uroot" "-p" 中指定的配置文件是 my.ini文件。

这里我们查看一下安装目录，即G:\Program Files\MySQL\MySQL Server 5.5，6个ini文件均不是 my.ini。

  id="iframe_0.160524359671399" src="data:text/html;charset=utf8,%3Cimg%20id=%22img%22%20src=%22http://www.2cto.com/uploadfile/2012/0908/20120908013118188.jpg?_=0.020910287043079734%22%20style=%22border:none;max-width:999px%22%3E%3Cscript%3Ewindow.onload%20=%20function%20()%20%7Bvar%20img%20=%20document.getElementById('img');%20window.parent.postMessage(%7BiframeId:'iframe_0.160524359671399',width:img.width,height:img.height%7D,%20'http://www.cnblogs.com');%7D%3C/script%3E" frameborder="0" scrolling="no" style="margin: 0px; padding: 0px; border-style: none; width: 750px; height: 560px;">

4.复制my-small.ini文件，更名为my-ini文件，保存。
 

id="iframe_0.26672318717464805" src="data:text/html;charset=utf8,%3Cimg%20id=%22img%22%20src=%22http://www.2cto.com/uploadfile/2012/0908/20120908013119719.jpg?_=0.5512181066442281%22%20style=%22border:none;max-width:999px%22%3E%3Cscript%3Ewindow.onload%20=%20function%20()%20%7Bvar%20img%20=%20document.getElementById('img');%20window.parent.postMessage(%7BiframeId:'iframe_0.26672318717464805',width:img.width,height:img.height%7D,%20'http://www.cnblogs.com');%7D%3C/script%3E" frameborder="0" scrolling="no" style="margin: 0px; padding: 0px; border-style: none; width: 750px; height: 348px;">

 
5.启动mysql command line client，问题解决。
 

id="iframe_0.04044116195291281" src="data:text/html;charset=utf8,%3Cimg%20id=%22img%22%20src=%22http://www.2cto.com/uploadfile/2012/0908/20120908013119326.jpg?_=0.8974881311878562%22%20style=%22border:none;max-width:999px%22%3E%3Cscript%3Ewindow.onload%20=%20function%20()%20%7Bvar%20img%20=%20document.getElementById('img');%20window.parent.postMessage(%7BiframeId:'iframe_0.04044116195291281',width:img.width,height:img.height%7D,%20'http://www.cnblogs.com');%7D%3C/script%3E" frameborder="0" scrolling="no" style="margin: 0px; padding: 0px; border-style: none; width: 472px; height: 191px;">