在 windows 上安装免安装版的mysql
在 windows 上安装免安装版的 1、 下载路径 https://downloads.mysql.com/archives/community/ 2、 解压 3、复制 my-default.ini ,生成 my.ini 完整my.ini 文件如下 # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It‘s a template which will be copied to the # *** default location during install,and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server,else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set,remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed,experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M [client] port=3306 default-character-set=utf8 [mysqld] port=3306 character_set_server=utf8 #character_set_server=utf8 一定要这样写; basedir=E:Environmentmysql-5.6.30-winx64 #解压目录 datadir=E:Environmentmysql-5.6.30-winx64data #解压目录下data目录,必须为data目录 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 4、注册windows系统服务 解压目录下修改的my.ini文件安装成功后会提示服务安装成功。 注:my.ini文件放在MySQL解压后的根目录下移除服务命令为:mysqld remove5、启动MySQL服务 6、 修改 root 账号的密码 7、设置mysql远程访问: 8、 安装完成。可以 下载 “Navicat premium ” 来试试 远程连接。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
- powershell脚本执行绕过powershell下脚本执行限制(cmd下执行
- Windows移动 – Windows移动开发入门
- Windows及Android倍速播放视频软件下载
- .net – AppDomain.GetCurrentThreadID对于Windows API调用
- 创建客户端证书 – Windows
- Windows尝试使用asadmin启动GlassFish时,“系统找不到指定的
- Windows Phone 7 – 您可以在Windows 7手机上安装自己的应用
- IIS初始化(预加载),解决第一次访问慢,程序池被回收问题
- .net – Windows 10 Universal应用程序中的证书固定
- Win32 CMD批处理命令
- 在Windows上,绑定装载卷在docker-compose中的行为
- windows-server-2008-r2 – Windows Server 2008
- Windows XP中的Windows-xp – inno setup.exe失败
- Windows 10 携这三大新功能,五月震撼来袭。
- windows-8 – 解锁-bde应用程序未找到错误在Wind
- windows10环境下装ubuntu双系统,装显卡驱动,配
- windows-server-2008 – Windows 7客户端的RDP数
- windows-server-2008 – 请告知VPS配置选择(使用
- windows – SQL Plus:如何更改目录并显示当前工
- wcf – ClientCredentialType = Windows和= Ntlm