win764位系统怎么安装mysql

win764位系统怎么安装mysql,第1张

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等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!

欢迎分享,转载请注明来源:内存溢出

原文地址:https://54852.com/sjk/9295190.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2023-04-26
下一篇2023-04-26

发表评论

登录后才能评论

评论列表(0条)

    保存