一、下载MySQL
首先,去数据库的官网http://www.mysql.com下载MySQL。
点击进入后的首页如下:
![](https://p0.ssl.img.360kuai.com/t018e826cf3308e395c.png?size=1377x914)
然后点击downloads,然后选择MySQL Community (GPL) Downloads 。等到下图:
![](https://p0.ssl.img.360kuai.com/t014e826a72fa7ad664.png?size=931x527)
选择MySQL Community Server
![](https://p0.ssl.img.360kuai.com/t01f742a0af46953c20.png?size=902x724)
这边注意选择安装包版本
MYSQL两种安装方式教程:
- msi安装包自动安装教程;
- zip包解压配置安装教程;
![](https://p0.ssl.img.360kuai.com/t01feff8c9d8f88ec9d.png?size=972x508)
鼠标一直滚到最下方,可供选择的下载安装包有2个(放心,别看安装包是32bit的,它也能兼容64位),选择比较大的那个安装包;
![](https://p0.ssl.img.360kuai.com/t013fe9ee67adf8b555.png?size=1032x576)
点击download进入下载页面选择No thanks, just start my download就可以开始下载了,当然你要是想注册也可以注册一下。
二、安装MySQL
打开刚刚下载好的安装包,开始安装MySQL。
选择 I accept 然后点击next进入下一步。
![](https://p0.ssl.img.360kuai.com/t01c426a8e0da6d2e9e.png?size=1178x889)
第一个选项
![](https://p0.ssl.img.360kuai.com/t0137b4e40589f03935.png?size=509x553)
第二个选项
![](https://p0.ssl.img.360kuai.com/t01408944cbc45f8fb8.png?size=521x75)
第三个选项
![](https://p0.ssl.img.360kuai.com/t01363ccc0eff4f6f5a.png?size=515x459)
第四个选项
![](https://p0.ssl.img.360kuai.com/t01e0a48a8dd672d97b.png?size=506x51)
最后一个选项(这个可以选择安装目录的)
![](https://p0.ssl.img.360kuai.com/t01482847cbf528a5bb.png?size=504x62)
笔者在这里给一点建议:
经过查阅最后一个可以选择安装目录,建议选最后一个
你自己看看情况吧,应该拿捏的准
选择好之后点击next,可以选择我们的路径配置,然后next,第一次安装可能没有下面的Path Conflicts配置这一步,不慌!没有这一步的直接跳过!让他默认就好!!!!!!!!!!或者你可以退出然后重新安装就有了
![](https://p0.ssl.img.360kuai.com/t01fb45edc52390c4bf.png?size=1178x889)
根据我需求选了三个通用的,以后如果需要别的还可以点击安装包添加的。Next
![](https://p0.ssl.img.360kuai.com/t01afa25ec231a5568c.png?size=762x568)
选择安装路径记得填写
![](https://p0.ssl.img.360kuai.com/t012b3ec82d5ce38153.png?size=1178x889)
这里直接点击execute执行就可以了,执行完后点击next进入下一步。
![](https://p0.ssl.img.360kuai.com/t01ca6c18e806db57bf.png?size=786x588)
一路Next直到
![](https://p0.ssl.img.360kuai.com/t01ca3eafe4a76fda55.png?size=1178x889)
请记住你的端口号,如果端口号被占用记得修改,继续一路Next
![](https://p0.ssl.img.360kuai.com/t01dee06b3a37d80373.png?size=1178x889)
设置账号密码,添加用户,请务必记得密码,
·![](https://p0.ssl.img.360kuai.com/t0190f4e09b95436c55.png?size=1178x889)
一路lNext
![](https://p0.ssl.img.360kuai.com/t01065c6a2affc17a95.png?size=1178x889)
最后跳出
![](https://p0.ssl.img.360kuai.com/t01b5b7aa009de3c729.png?size=1920x1020)
安装成功(建议删除安装包)
如果出现下面情况,需要依次选上出现的条目并双击(或者点击下方Execute按钮)进行安装必要控
![](https://p0.ssl.img.360kuai.com/t010da76ca53c3ec1e6.png?size=621x616)
安装成功!!!
现在我们的mysql命令只能在安装目录的bin文件夹中使用,我们配置一下环境变量,在全局中使用
![](https://p0.ssl.img.360kuai.com/t018e281ae11c421ec3.png?size=765x448)
点击确定,配置好之后,我们就可以在全局中使用mysql命令!
![](https://p0.ssl.img.360kuai.com/t010e6bfbf52b414353.png?size=375x368)
win+R打开窗口输入cmd回车打开命令行!
输入mysql -u root -p回车
输入密码:我们在配置时设置的密码。如果密码不正确可试一下空密码直接回车
![](https://p0.ssl.img.360kuai.com/t0131072e0befc34091.png?size=790x406)
2.问题总结
1.启动server时启动不成功
答:修改服务
2.设置了密码,登陆时输入密码不正确
答:密码设置失败,为空密码
3.如果安装失败一次想重新安装一定要清理干净,包括注册表!!
如何设置中文
![](https://p0.ssl.img.360kuai.com/t01e0a0021eff11b2de.png?size=1491x893)
语言调整方法百:
edit --> preferences --> appearance --> configure Fonts for : 选中Simplified Chinese OK ;
而且需要重启才能生效。
MySQL workbench怎么创建数据库度:
第1步:单击MySQLWorkbench.exe快捷方式,弹问出MySQLWorkbench界面;
第2步:单击菜单栏Database按钮,弹出下拉菜单,单答击Connect to Database;
第3步:单击OK按钮,输入数据库密码;
第4步:单击工具栏按钮(第四个回,即鼠标放在 上面显示Create a new schema in the connected server),创建数据库;
第5步:修改答数据库名字为sqltest,collation保持默认,单击确定;
第6步:其他选项保持默认,单击Apply;
第7步:其他选项保持默认,单击Finish;
第8步:可以看到Nav.
![](https://p0.ssl.img.360kuai.com/t01337c61d4a35bf481.png?size=1028x739)
如果你屏幕够大
![](https://p0.ssl.img.360kuai.com/t0181a25e8fb2d96508.png?size=1920x1040)
安装错了如何卸载(可以在这里添加需要安装的包)
打开你下载的安装包
![](https://p0.ssl.img.360kuai.com/t014f3c2c0cedc5532e.png?size=1178x889)
全选 Next,一路Next,全部继续无脑就完事了。
![](https://p0.ssl.img.360kuai.com/t01e8ad4d80c387fd50.png?size=1178x889)
然后剩下的去程序和功能内卸载
![](https://p0.ssl.img.360kuai.com/t01bbf855c3b324f807.png?size=1772x382)
","gnid":"99b6d77f7c3f8a524","img_data":[{"flag":2,"img":[{"desc":"","height":"914","title":"","url":"https://p0.ssl.img.360kuai.com/t018e826cf3308e395c.png","width":"1377"},{"desc":"","height":"527","title":"","url":"https://p0.ssl.img.360kuai.com/t014e826a72fa7ad664.png","width":"931"},{"desc":"","height":"724","title":"","url":"https://p0.ssl.img.360kuai.com/t01f742a0af46953c20.png","width":"902"},{"desc":"","height":"508","title":"","url":"https://p0.ssl.img.360kuai.com/t01feff8c9d8f88ec9d.png","width":"972"},{"desc":"","height":"576","title":"","url":"https://p0.ssl.img.360kuai.com/t013fe9ee67adf8b555.png","width":"1032"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t01c426a8e0da6d2e9e.png","width":"1178"},{"desc":"","height":"553","title":"","url":"https://p0.ssl.img.360kuai.com/t0137b4e40589f03935.png","width":"509"},{"desc":"","height":"75","title":"","url":"https://p0.ssl.img.360kuai.com/t01408944cbc45f8fb8.png","width":"521"},{"desc":"","height":"459","title":"","url":"https://p0.ssl.img.360kuai.com/t01363ccc0eff4f6f5a.png","width":"515"},{"desc":"","height":"51","title":"","url":"https://p0.ssl.img.360kuai.com/t01e0a48a8dd672d97b.png","width":"506"},{"desc":"","height":"62","title":"","url":"https://p0.ssl.img.360kuai.com/t01482847cbf528a5bb.png","width":"504"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t01fb45edc52390c4bf.png","width":"1178"},{"desc":"","height":"568","title":"","url":"https://p0.ssl.img.360kuai.com/t01afa25ec231a5568c.png","width":"762"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t012b3ec82d5ce38153.png","width":"1178"},{"desc":"","height":"588","title":"","url":"https://p0.ssl.img.360kuai.com/t01ca6c18e806db57bf.png","width":"786"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t01ca3eafe4a76fda55.png","width":"1178"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t01dee06b3a37d80373.png","width":"1178"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t0190f4e09b95436c55.png","width":"1178"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t01065c6a2affc17a95.png","width":"1178"},{"desc":"","height":"1020","title":"","url":"https://p0.ssl.img.360kuai.com/t01b5b7aa009de3c729.png","width":"1920"},{"desc":"","height":"616","title":"","url":"https://p0.ssl.img.360kuai.com/t010da76ca53c3ec1e6.png","width":"621"},{"desc":"","height":"448","title":"","url":"https://p0.ssl.img.360kuai.com/t018e281ae11c421ec3.png","width":"765"},{"desc":"","height":"368","title":"","url":"https://p0.ssl.img.360kuai.com/t010e6bfbf52b414353.png","width":"375"},{"desc":"","height":"406","title":"","url":"https://p0.ssl.img.360kuai.com/t0131072e0befc34091.png","width":"790"},{"desc":"","height":"893","title":"","url":"https://p0.ssl.img.360kuai.com/t01e0a0021eff11b2de.png","width":"1491"},{"desc":"","height":"739","title":"","url":"https://p0.ssl.img.360kuai.com/t01337c61d4a35bf481.png","width":"1028"},{"desc":"","height":"1040","title":"","url":"https://p0.ssl.img.360kuai.com/t0181a25e8fb2d96508.png","width":"1920"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t014f3c2c0cedc5532e.png","width":"1178"},{"desc":"","height":"889","title":"","url":"https://p0.ssl.img.360kuai.com/t01e8ad4d80c387fd50.png","width":"1178"},{"desc":"","height":"382","title":"","url":"https://p0.ssl.img.360kuai.com/t01bbf855c3b324f807.png","width":"1772"}]}],"original":0,"pat":"art_src_0,fts0,sts0","powerby":"cache","pub_time":1684375971000,"pure":"","rawurl":"http://zm.news.so.com/105dd098590927581f8554285d7f051b","redirect":0,"rptid":"ad4bdecf63215571","rss_ext":[],"s":"t","src":"大凡","tag":[{"clk":"ktechnology_1:mysql","k":"mysql","u":""}],"title":"超详细MySQL安装及基本使用教程_mysql安装教程
明温些1813windows10怎么用命令进入mysql数据库? -
广官肥17243933568 ______ 需要准备的材料分别是:windows10电脑、cmd工具、mysql软件. 1、首先,在windows10电脑上打开cmd工具. 2、进入到mysql安装目录的bin目录,例如:D:\xampp\mysql\bin. 3、输入mysql连接命令,例如:mysql -uroot. 4、按回车,此时就成功进入了mysql数据库.
明温些1813MYSQL安装到D盘后怎么启动?? -
广官肥17243933568 ______ 你难道用的绿色版的?呵呵, 自动启动的. 可以通过Windows的服务管理器查看.“开始”-“运行”,输入“services.msc”,回车.弹出Windows的服务管理器,然后就可以看见服务名为“mysql”的服务项了,其右边标明“已启动”,如...
明温些1813我安装好了MySQL.. 控制台却打不开... 有什么办法打开MySQL的控制台 -
广官肥17243933568 ______ 可能是缺少文件了,需要删除彻底了,再装一遍就可以了! 1, 卸载MySQL 2, 删除目录 C:\Documents and Settings\All Users\Application Data\MySQL 3, 重新安装MySQL
明温些1813怎么打开MYSQL数据库文件? -
广官肥17243933568 ______ OFFICE ACCESS 2000 OFFICE ACCESS 2003 都可以打开.MDB结尾的数据库 SQL数据库必须使用WINDOWS SQL打开 MYSQL数据库必须用MYSQL管理器打开. 除.MDB以外的数据库都是在安装软件的时候就打了相关操作的软件
明温些1813mysql默认安装怎样打开文件 -
广官肥17243933568 ______ MySQL安装完成后不象SQL Server默认安装在一个目录,它的数据库文件、配置文件和命令文件分别在不同的目录,了解这些目录非常重要,尤其对于Linux的初学者,因为 Linux本身的目录结构就比较复杂,如果搞不清楚MySQL的安装目录那...
明温些1813MySQL数据库的启动与打开 -
广官肥17243933568 ______ 您的mysql服务是不是没启动?先检查一下服务有没有启动,可以先用net mysql start启动下
明温些1813系统重装后怎么启动mysql -
广官肥17243933568 ______ 在CMD里面输入 mysqld install MySQL --defaults-file="D:\Program Files\MySQL\mysql-5.6.13-win32\my.ini" 这个是把MYSQL服务添加到系统服务中.注意修改路径.添加之后再用CMD net start mysql 就可以了 参考http://wenku.baidu.com/view/d99fd1df910ef12d2af9e73a.html
明温些1813如何用命令行进入mysql具体操作步骤 -
广官肥17243933568 ______ windows操作系统 先启动mysql,控制面板=》管理工具=》服务,找到mysql,启动 进入命令提示符,也就是黑窗口【运行里面输入 cmd 回车即可】 输入mysql -u root -p密码 【注意 -p 跟 密码之间没有空格】 ok,进入mysql了.limux操作系统,假设你的是 centos 进入终端.输入 service mysqld start mysql启动了,再输入 输入mysql -u root -p密码 【注意 -p 跟 密码之间没有空格】 ok,进入mysql了.
明温些1813怎么进入mysql命令行 -
广官肥17243933568 ______ 如果是通过yum或rpm包安装的 直接输入mysql就行 如果是源码安装的,输入你安装mysql的绝对路径
明温些1813mysql5.5.53源码安装好之后怎么进入mysql -
广官肥17243933568 ______ 先启动mysql D:\database\mysql-5.6.24-winx64\bin\mysqld --defaults-file=D:\database\mysql-5.6.24-winx64\my.ini然后登入mysql mysql -uroot -p修改密码 SET PASSWORD = PASSWORD('some password')