首页 >>  正文

mysql重启服务命令

来源:baiyundou.net   日期:2024-09-27

一、下载MySQL

首先,去数据库的官网http://www.mysql.com下载MySQL。

点击进入后的首页如下: 

然后点击downloads,然后选择MySQL Community (GPL) Downloads 。等到下图:

选择MySQL Community Server

这边注意选择安装包版本

MYSQL两种安装方式教程:

  1. msi安装包自动安装教程;
  2. zip包解压配置安装教程;

鼠标一直滚到最下方,可供选择的下载安装包有2个(放心,别看安装包是32bit的,它也能兼容64位),选择比较大的那个安装包;

点击download进入下载页面选择No thanks, just start my download就可以开始下载了,当然你要是想注册也可以注册一下。

二、安装MySQL

打开刚刚下载好的安装包,开始安装MySQL。 
选择 I accept 然后点击next进入下一步。

第一个选项

第二个选项

第三个选项

第四个选项

最后一个选项(这个可以选择安装目录的)


笔者在这里给一点建议:

经过查阅最后一个可以选择安装目录,建议选最后一个

你自己看看情况吧,应该拿捏的准

选择好之后点击next,可以选择我们的路径配置,然后next,第一次安装可能没有下面的Path Conflicts配置这一步,不慌!没有这一步的直接跳过!让他默认就好!!!!!!!!!!或者你可以退出然后重新安装就有了

根据我需求选了三个通用的,以后如果需要别的还可以点击安装包添加的。Next

选择安装路径记得填写


这里直接点击execute执行就可以了,执行完后点击next进入下一步。

一路Next直到

请记住你的端口号,如果端口号被占用记得修改,继续一路Next

设置账号密码,添加用户,请务必记得密码,

·

一路lNext

最后跳出

安装成功(建议删除安装包)

如果出现下面情况,需要依次选上出现的条目并双击(或者点击下方Execute按钮)进行安装必要控

安装成功!!!
现在我们的mysql命令只能在安装目录的bin文件夹中使用,我们配置一下环境变量,在全局中使用


点击确定,配置好之后,我们就可以在全局中使用mysql命令!

win+R打开窗口输入cmd回车打开命令行!
输入mysql -u root -p回车
输入密码:我们在配置时设置的密码。如果密码不正确可试一下空密码直接回车


2.问题总结
1.启动server时启动不成功
答:修改服务
2.设置了密码,登陆时输入密码不正确
答:密码设置失败,为空密码
3.如果安装失败一次想重新安装一定要清理干净,包括注册表!!

如何设置中文

 

语言调整方法百:

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.

如果你屏幕够大

 

安装错了如何卸载(可以在这里添加需要安装的包)

打开你下载的安装包

全选 Next,一路Next,全部继续无脑就完事了。

然后剩下的去程序和功能内卸载

","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":"hbase","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安装教程

宣胡苗2933windows无法启动mysql服务该怎么解决?? -
郦进申18441652290 ______ 尊敬的问友:在本地计算机无法启动MYSQL服务错误1067进程意外终止 这种情况一般是my.ini文件配置出错了你可以删除系统目录下的my.ini文件, 把下面的内容重新写入my.ini文件...

宣胡苗2933怎样 重启 mysql 服务器
郦进申18441652290 ______ 开始-运行-输入:services.msc-点确定-找到MySQL-在上面右键-重新启动. 这样就行了

宣胡苗2933MySQL Server 5.1如何运行数据库 -
郦进申18441652290 ______ 如果确定安装成功的话可以在command窗口(开始、运行、输入cmd)打开、管理MySQL,相关命令如下:启动MySQL服务:net start mysql停止MySQL服务:net stop mysql重启MySQL服务:net r...

宣胡苗2933centos mysql怎么启动服务 -
郦进申18441652290 ______ 常用命令如下: 启动mysql服务 service mysqld start 停止mysql服务 service mysqld stop 重启mysql服务 service mysqld restart 查看mysql服务状态 service mysqld status

宣胡苗2933windows如何重启MySQL服务、修改Mysql密码 -
郦进申18441652290 ______ 2.启动:输入 net stop mysql3.停止:输入 net start mysql 提示:Windows下不能直接重启(restart),只能先停止,再启动.修改mysql密码:方法一:通过MySQL命令行,可以修改MySQL数据库的密码,下面就为您详细介绍该MySQL命令行,...

宣胡苗2933如何启动和关闭mysql? -
郦进申18441652290 ______ linux下: 比如我的mysql是用源码方式安装在/usr/local/mysql 自动:将/usr/local/mysql/share/mysql/mysql.server拷贝到/etc/rc.d/init.d/下,然后 chkconfig --add mysql.server就可以开机就启动mysql服务了. 手动:以root身份执行/usr/local/mysql/...

宣胡苗2933mysql sever怎么启动 -
郦进申18441652290 ______ 如果确定安装成功的话可以在command窗口(开始、运行、输入cmd)打开、管理MySQL,相关命令如下:启动MySQL服务:net start mysql 停止MySQL服务:net stop mysql 重启MySQL服务:net restart mysql (直接运行net会有更多命令提示...

宣胡苗2933如何打开/关闭mysql服务 -
郦进申18441652290 ______ 有朋友之前在知道里回答过了,我转给你看一下:方法一:netstartmysql(或者是其他服务名)方法二:在XP下启动MySQL服务MySql安装目录:“d:\MySql\”进入命令行输入窗口(Dos命令输入)进入“d:\MySql\bin”目录下运行“mysqld-uroot”命令.写法:d:\MySql\bin\mysqld-uroot(Enter)运行后在进程管理中有mysql的进程,运行成功(可能需要手动关闭命令窗口)然后在“d:\MySql\bin\”目录下运行“mysql”命令写法:d:\MySql\bin\(Enter)屏幕出现:mysql>然后就可以输入数据库语句.

(编辑:自媒体)
关于我们 | 客户服务 | 服务条款 | 联系我们 | 免责声明 | 网站地图 @ 白云都 2024