2023-05-28 02:01:18

关于mysql64位的信息

本文目录一览：

64位win7系统如何安装MySQL

1、找到安装包，点击安装包 安装

2、选择Install MySql Product进入安装

3、同意协议，点击Next 进入下一步

4、跳过更新，继续安装，选择next，需拦稿要更新的可以更新

5、设置安装路径和数据库存储路径，以及安装的选择，这里选择FUll ，看个人意愿选择安装不同的安装类型

6、查看安装要求，满足皮衡卖所有要求，点击下一步，不满足的需要先安装，否则安装不成功！

7、下面进入正式的安装过程，每个过程等待几十秒钟，然后根据图片上的教程下一步就行了

8、设燃逗置端口号和服务器的类型，个人用户建议选择默认的

9、下一步，进入设置默认的密码和新建用户页面，密码不得少于4个字符

10、安装到最好的过程了，按照图片中指示来，直到安装完成

11、安装完成后，在开始菜单中找到MYSQL打开运行即可

[img]

驱魔猎人版征途mysql在64位机上运行不了

您问的是驱魔猎人版征途mysql在64位机上运行不了怎么办吗？方法如下：

出现问题提示，无法启动，需要启动时间很长。

第一步：Ctrl+E打开磨帆资源管理器，点击计算机，点击管理。

第二步：展开服务和应用程序缺郑，点击服务找到Mysql56，右击属性。

第三步：点击登陆，点击本地系统登陆。

5、第四步：回到服务启动MySql服务。

第五步：回到MySql的安装目录，点击mysql.exe。

第六步：输入s，出输出MySql的伏游颂基本信息，就说明启动完成。

mysql win7 64位 安装

1、 MySQL Community Server 5.6.10

官方网站下载mysql-5.6.10-winx64.zip

2、解压到d:\MySQL.（路径自己指定）

3、在d:\MySQL下新建my.ini配置文件，内容如下：

　姿孙枯　

*****************配置文件开始*********************

# 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 Server.Make 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\mysqld.exe"

# 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

# Query cache is used to cache SELECT results andlater return them

# without actual executing the same query once again.Having the query

# cache enabled may result in significant speedimprovements, if your

# have a lot of identical queries and rarely changingtables. See the

# "Qcache_lowmem_prunes" status variable tocheck if the current value

# is high enough for your load.

# Note: In case your tables change very often or ifyour queries are

# textually different every time, the query cache mayresult in a

# slowdown instead of a performance improvement.

query_cache_size=0

# The number of open tables for all threads.Increasing this value

# increases the number of file descriptors that mysqldrequires.

# Therefore you have to make sure to set the amount ofopen files

# allowed to at least 4096 in the variable"open-files-limit" in

# section [mysqld_safe]

table_cache=256

# Maximum size for internal (in-memory) temporarytables. If a table

# grows larger than this value, it is automaticallyconverted to disk

# based table This limitation is for a single table.There can be many

# of them.

tmp_table_size=26M

# How many threads we should keep in a cache forreuse. When a client

# disconnects, the client's threads are put in thecache if there aren't

# more than thread_cache_size threads frombefore. This greatly reduces

# the amount of thread creations needed if you have alot of new

# connections. (Normally this doesn't give a notableperformance

# improvement if you have a good threadimplementation.)

thread_cache_size=8

#*** MyISAM Specific options

# The maximum size of the temporary file MySQL isallowed to use while

# recreating the index (during REPAIR, ALTER TABLE orLOAD DATA INFILE.

# If the file-size would be bigger than this, theindex will be created

# through the key cache (which is slower).

myisam_max_sort_file_size=100G

# If the temporary file used for fast index creationwould be bigger

# than using the key cache by the amount specifiedhere, then prefer the

# key cache method. This is mainly used to force long character keys in

# large tables to use the slower key cache method tocreate the index.

myisam_sort_buffer_size=52M

# Size of the Key Buffer, used to cache index blocksfor MyISAM tables.

# Do not set it larger than 30% of your available memory,as some memory

# is also required by the OS to cache rows. Even ifyou're not using

# MyISAM tables, you should still set it to 8-64M asit will also be

# used for internal temporary disk tables.

key_buffer_size=40M

# Size of the buffer used for doing full table scansof MyISAM tables.

# Allocated per thread, if a full scan is needed.

read_buffer_size=64K

read_rnd_buffer_size=256K

# This buffer is allocated when MySQL needs to rebuildthe index in

# REPAIR, OPTIMZE, ALTER table statements as well asin LOAD DATA INFILE

# into an empty table. It is allocated per thread sobe careful with

# large settings.

sort_buffer_size=256K

#*** INNODB Specific options ***

innodb_data_home_dir="d:\MySQL\Data\INNODB\"

# Use this option if you have a MySQL server withInnoDB support enabled

# but you do not plan to use it. This will save memoryand disk space

# and speed up some things.

#skip-innodb

# Additional memory pool that is used by InnoDB tostore metadata

# information. If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS. As this is fast enough on most

# recent operating systems, you normally do not needto change this

# value. SHOW INNODB STATUS will display the currentamount used.

innodb_additional_mem_pool_size=2M

# If set to 1, InnoDB will flush (fsync) thetransaction logs to the

# disk at each commit, which offers full ACIDbehavior. If you are

# willing to compromise this safety, and you arerunning small

# transactions, you may set this to 0 or 2 to reduce diskI/O to the

# logs. Value 0 means that the log is only written tothe log file and

# the log file flushed to disk approximately once persecond. Value 2

# means the log is written to the log file at eachcommit, but the log

# file is only flushed to disk approximately once persecond.

innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering logdata. As soon as

# it is full, InnoDB will have to flush it to disk. Asit is flushed

# once per second anyway, it does not make sense tohave it very large

# (even with long transactions).

innodb_log_buffer_size=1M

# InnoDB, unlike MyISAM, uses a buffer pool to cacheboth indexes and

# row data. The bigger you set this the less disk I/Ois needed to

# access data in tables. On a dedicated databaseserver you may set this

# parameter up to 80% of the machine physical memorysize. Do not set it

# too large, though, because competition of thephysical memory may

# cause paging in the operating system. Note that on 32bit systems you

# might be limited to 2-3.5G of user level memory perprocess, so do not

# set it too high.

innodb_buffer_pool_size=77M

# Size of each log file in a log group. You should setthe combined size

# of log files to about 25%-100% of your buffer poolsize to avoid

# unneeded buffer pool flush activity on log fileoverwrite. However,

# note that a larger logfile size will increase thetime needed for the

# recovery process.

innodb_log_file_size=39M

# Number of threads allowed inside the InnoDB kernel.The optimal value

# depends highly on the application, hardware as wellas the OS

# scheduler properties. A too high value may lead tothread thrashing.

innodb_thread_concurrency=8

*****************配置文件结束*********************

配置文件也放在了附件里，大家可以根据需要修改。

重点是以下配置，其中datadir的目录名称必须是data，并且好像必须是MySQL目录下的data.之前自己制定了其他目录，一直出现1067的错误。

#Path to installation directory. All paths are usuallyresolved relative to this.

basedir="d:\MySQL\"

#Path to the database root

datadir="d:\MySQL\Data"

4、在windows环境变量里加入以下内容（方便执行命令行命令）

新建MYSQL_HOME="d:\MySQL\"

在Path里加入%MYSQL_HOME%\bin

5、将mysql注册为windows系统服务。具体操作是在命令行中执行以下命令：

mysqld install MySQL --defaults-file="d:\MySQL\my.ini"

移除服务为 mysqld remove

6、第5步成功后，在命令行启动mysql

c:net start mysql

win7 64位下如何安装配置mysql

1、 安装：

1先将mysql-noinstall-5.1.66-winx64.zip解压缩到 d:\appspace\mysql

2将其中的data 文件夹移动到d:/appspace/mysqlData 即mysql的 data路径为：d:/appspace/mysqlData/data

3my.ini配置文件有2个可选择的位置：

打开E:\appSpace\mysql \ my-large.ini (如果后面mysql出现1067错误，启动不了的话，可试着用my-huge.ini或其他), 在最后加上如下几行，然后另存为my.ini(C:\Windows).

#--------------------------------------------------------

[mysqld]

basedir=d:/appspace/mysql

datadir=d:/appspace/mysqlData/data

default-character-set=utf8

[WinMySQLAdmin]

Server=d:/appspace/mysql/bin/mysqld.exe

#default-character-set=utf8

[client]

default-character-set=utf8

#--------------------------------------------------------

4可以在mysql中查看设定的字符集（一定要在[mysqld] 中设定utf-8）：

mysql show variables like 'character%';

+--------------------------+-----------------------------------+

| Variable_name | Value |

+--------------------------+-----------------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | d:\appspace\mysql\share\charsets\ |

+--------------------------+-----------------------------------+

2 配置服务(命令行必须以administrator身份运行)

1）将MySQL 添加到服务中。

在Windows Run中输入cmd，这时上面有提示（cmd.exe），右键单击cmd.exe, 选择Run as administrator，进入路径： d:/appspace/mysql /bin

输运芦入庆悄顷 mysqld --install MySQL --defaults-file="C:\Windows\my.ini"

要指定defaults-file.

命令行中输入誉陆services.msc回车，可以看到MySQL已被添加到Services中，

Path to executable中的内容为

d:\appspace\mysql\bin\mysqld --defaults-file=C:\windows\my.ini MySQL

2）启动MySQL

在MySQL Service中点击Start按钮，或者在命令行（Run as administrator）中输入 net start mysql.

如果出现1067错误，启动不了，则重新检查my.ini文件（前面有描述）

3）关闭MySQL

在MySQL Service中点击Stop按钮，或者在命令行（Run as administrator）中输入 net stop mysql.

4）删除mysql服务

mysqld –remove

3 环境变量

将d:\appspace\ mysql\bin添加到Path中。

4 操作

登录数据库:

C:\Users\zhang10mysql -u root -p

Enter password: *** (密码初始值可设置为root或者为空)

进入mysql后，命令后以分号结尾。

显示所有的数据库模式:

mysql show databases;

新建一个数据库模式，指定编码utf-8，否则会出现乱码。

create database md11uft8 character set utf8;

选中此数据库md11utf8：

mysql use md11utf8;

创建一个表：

mysql create table basicinfo (id int primary key auto_increment, name varchar(30) not null, age int not null);

插入数据：

mysql insert into basicinfo(id, name, age) values('1','张三','30');

mysql insert into basicinfo(id, name, age) values('3','李四','25');

查询：

mysql select * from basicinfo;

+----+------+-----+

| id | name | age |

+----+------+-----+

| 1 | | 30 |

| 3 | | 25 |

+----+------+-----+

可看到name中的值没有显示（中文显示不了）。

在MySQL workbench中插入值，查询会正确显示。

但是在命令行中查询显示乱码（DOS不支持UTF8从MYSQL中显示），解决如下：

mysql set names gbk;

修改root的密码：

mysqluse mysql；

mysqlupdate user set Password=password('newpassword') where User='root';

mysqlflush privileges;

mysql区分32 和64位吗

mysql是区尘竖分肆亏32和64位的裂兄神有图为证

右键点击计算机，查看你的计算机系统是多少位

去官网下载相应的mysql安装包

安装完成即可

mysql安装教程多大

mysql安装教程64位的是334.7M。

MySQL关是一种关系数据库管理系统，所使用的 SQL 语言是用于访问数据库的最常用的标准化语言，其特点为体积小、速度快、总体拥有成本低派派。

尤其是开放源码这一特点，在 Web应用方面 MySQL 是最好的 RDBMS(Relational Database Management System：关系数据库管理系统)应用软件之一。

验证 MySQL 安装：

在成功安装 MySQL 后，一些基础表会表初始化，在服务器启动后，你可以通过简单的测试来验证 MySQL 是否工作毕简正常。

使用 mysqladmin 工具来获取服务器状态：

使用 mysqladmin 命令来检查服务器的版本, 在 linux 上该二进制文件位于 /usr/bin 目录，在 Windows 上该二进制文件位于C:\mysql\bin 。

使用 MySQL Client(Mysql客户端) 执行简单的SQL命令：

你可以在 MySQL Client(Mysql客户端) 使用 mysql 命令连接到 MySQL 服务器上，默认情况下 MySQL 服务器的登录密码为空。

Mysql安装后需要做的：

Mysql安装成功后，默认的root用户密码为空，你可以使用以下命令来创建尘数贺root用户的密码。

标签:
作者:8ydz.com | 分类:数据库 | 浏览:128 | 评论:0

Powered By Z-BlogPHP 1.7.2

备案号：蜀ICP备2023005218号