
1、 MySQL Community Server 5610
2、解压到d:\MySQL(路径自己指定)
3、在d:\MySQL下新建myini配置文件,内容如下:
配置文件开始
# MySQL Server Instance Configuration File
#----------------------------------------------------------------------
# Generated by the MySQL Server Instance ConfigurationWizard
#
#
# Installation Instructions
#----------------------------------------------------------------------
#
#
# CLIENT SECTION
#----------------------------------------------------------------------
#
# The following options will be read by MySQL clientapplications
# Note that only client applications shipped by MySQLare guaranteed
# to read this section If you want your own MySQLclient program to
# honor these values, you need to specify it as anoption during the
# MySQL client library initialization
#
[client]
port=3306
[mysql]
default-character-set=gbk
# SERVER SECTION
#----------------------------------------------------------------------
#
# The following options will be read by the MySQL ServerMake sure that
# you have installed the server correctly (see above)so it reads this
# file
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory All paths are usuallyresolved relative to this
basedir="d:\MySQL\"
#Path to the database root
datadir="d:\MySQL\Data"
[WinMySQLadmin]
Server="d:\MySQL\bin\mysqldexe"
# The default character set that will be used when anew schema or table is
# created and no character set is defined
default-character-set=gbk
# The default storage engine that will be used whencreate new tables when
default-storage-engine=INNODB
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# The maximum amount of concurrent sessions the MySQLserver will
# allow One of these connections will be reserved fora user with
# SUPER privileges to allow the administrator to logineven if the
# connection limit has been reached
max_connections=100
1、运行mysql安装文件。
2、 按Next,然后选择安装方式,有"Typical(默认)"、"Complete(完全)"、"Custom(用户自定义)",选择第二个选项"Custom",下一步,MySQL Server(mysql服务器),Developer Components(开发者部分),Debug Symbols(调试符号),Server data files(服务器数据文件)默认
3、改变安装路径;原路径是"C:\Program Files\MySQL\MySQL Server 55\",也可以修改为:"E:\Program Files\MySQL Server 55\"。下一步,安装,会d出窗口,点下一步,再点下一步,选择"Launch the MySql instance Configuration Wizard",意思是启动MySQL实例配置向导,再点击Finish,再点下一步,Detailed Configuration(详细配置)和Standard Configuration(标准配置),选择详细配置,下一步
4、选择服务器类型,"Developer Machine(开发测试类,mysql占用很少资源)"、"Server Machine(服务器类型,mysql占用较多资源)"、"DedicatedMySQL Server Machine(专门的数据库服务器,mysql占用所有可用资源)",根据自己的类型选择,测试软件选"Developer Machine",服务器选"Server Machine",下一步。
5、选择创建MySQL表时使用的表处理器,"Multifunctional Database"(通用多功能型,好,同时使用InnoDB和MyISAM储存引擎)、"Transactional Database Only"(服务器类型,专注于事务处理,主要使用InnoDB只偶尔使用MyISAM,一般)、"Non-Transactional DatabaseOnly"(非事务处理型,较简单,完全禁用InnoDB储存引擎,将所有服务器资源指派给MyISAM储存引擎),随自己的用途而选择[13]
首先你需要是administror ,系统管理员:实现方法可以开始-》附件-》命令提示符,右击命令提示符,选择:按系统管理员身份运行。
之后你启动sql命令: net start mysql
如果要禁止,停止使用sql,命令:net stop mysql
当然你如果安装mysql,名称是自定义的,那要按照你自定义的名字来,比如net start mysql56。
在win7下还是可以用net start mysql来启动mysql服务!
1、在开始菜单的搜索框中输入cmd,然后右键单击,并选择以管理员身份运行!
如果每天都要启动mysql服务,这样不是很麻烦?所以按照下面来做:
2、右键单击cmd选择“附到开始菜单(U)”;这时就可以到开始菜单上找到cmd了,
3、右击选择属性,选择快捷方式,再选择高级,再选择以管理员身份运行,再单击确定即可!
以上就是关于win764位系统怎么安装mysql全部的内容,包括:win764位系统怎么安装mysql、win7怎么安装mysql5.7.13压缩、如何在win7下启动mysql等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)