mysql8026myini

迷南。 2023-09-25 10:32 65阅读 0赞

## 如何开单机征途 ##

安装MYSQL4.1数据库

1.安装向导欢迎界面

2、选择安装类型

Typical(典型)、Complete(完全)、Custom(自定义),选择“Custom”安装

3.自定义安装

默认情况下MySQL将会被安装到C:\\ProgramFiles\\MySQL\\MySQLServer4.1\\文件夹里面。

可以点“Change”更改路径。(建议装在非系统盘,比如d:\\MySQLServer4.1\\)

4、准备开始安装

Install——开始安装

5、创建MySQL.com帐号的界面，如果是首次使用MySQL，可以选“CreateanewfreeMySQL.comaccout”来创建一个MYSQL的账号。(菜鸟建议选skipsign-up跳过)

6、文件复制完成后，这里有个配置向导的选项(ConfiguretheMySQLServernow)，建议勾选立即配置你的MySQL。

7、安装完成界面

8、配置类型选择页面。选“Detailedconfiguration”(详细配置)。

9、进入服务类型选择页面。选“DeveloperMachine”(开发者机器)，这样占用系统的资源不会很多。

10、数据库用法选择页面。选择“MultifunctionalDatabase”。

11、选择InnoDB数据存放位置页面。

不用更改设置，直接放在InstallationPath安装目录里即可

12、选择MySQL的同时联接数。

选择“ManualSetting”，设置根据自己需要，酌情设置。我设个100

13、配置MySQL在TCP/IP通讯环境中的端口。

选择默认的3306端口即可,有开防火墙和IP刷选记的加上端口。

14、选择MySQL中的字符设置。

注意，这里的选择将会影响你是否能在MySQL中使用中文。选择gb2312字符集以便支持简体中文，繁体中文选big5。这里我们要安装的是征途，因为征途服务端本身的特性，经个人测试选择第一项即可，如果选择下面中文模式反倒造成在后台查看人物名显示错误。

15、设置Windows服务选项。

注意，“InstallAsWindowsService”一定要勾选，这是将MySQL作为Windows的服务运行。“ServiceName”就用默认的“MySQL”或者你喜欢的服务名(推荐用默认的“MySQL”)。中间的“LaunchtheMySQLServerautomatically”一定要勾选，这样Windows启动时，MySQL就会自动启动服务，要不然就要手工启动MySQL。出现10061错误，原因在这里。下面那个勾主要是检查和手工调整，菜鸟不需要设置。

16、设置根帐号root的登录密码。

“ModifySecuritySettings”是设置根帐号的密码，把勾打上输入你的密码，mysql的用户默认为root。中间的勾是允许远程访问，如果你想远程修改数据库则勾选，这里默认为非勾选状态。下面的CreateAnAnonymousAccount”是创建一个匿名帐号，这样会导致未经授权的用户非法访问你的数据库，有安全隐患，建议不要勾选。

17、MySQL配置向导将依据你上面的所有设定配置MySQL，以便MySQL的运行符合你的需要。

点“Execute”开始配置，当出现“Servicestartedsuccessfully”时，说明你的配置完成，MySQL服务启动成功。

点“Finish”完成，整个MySQL的配置完成，剩下的就是用MySQL客户端连接MySQL服务器，然后使用了。

19、通过Windows的服务管理器查看。

“开始”－“运行”，输入“services.msc”，回车。弹出Windows的服务管理器，然后就可以看见服务名为“mysql”的服务项了，其右边标明“已启动”。

注意：装好MYSQL后最好重新启动系统作者:shalyun时间:2008-6-2609:48标题:安装Maki5服务端

1.将服务端Zebra目录复制到MYSQL的DATA目录下

2.找到MYSQL目录里的MY.INI文件，修改my.ini配置文件的\[mysqld\]下增加lower\_case\_table\_names=2，确定表名和库名是大小写敏感的，改完后重新启动mysql。这段添加完成后，需要将MYSQL服务关闭重启方可生效(不要在任务管理器里关闭程序)，大家可以重起一下机器。

3.将“Maki5”这个目录复制到C盘以外的盘，最好不要用中文名，比如我就放在E盘的Maki5目录下

4.打开ConfigTool.exe这个程序就是服务器启动的主程序，

5.设置这里读取MYSQL数据库的ROOT名和密码，这里的用户名一般就是ROOT，密码改成你刚才安装MYSQL时所输入的密码，注意，这里有好几处需要改的，图的上面所画圈的项目里的密码都要改成你自己的，否则连接不上，全部修改完后别忘了保存。

6.看一下启动设置里的程序目录是否正确，所有运行的程序都要指定在你所在的目录，比如我的E:\\Maki5\\目录

7.现在点击启动运行看看效果吧,好卡机啊

8.全部开启完毕了,如果出现错误,请查看一下服务器管理里面是否有服务没开启,然后关闭所有软件比如迅雷等再试试.作者:shalyun时间:2008-6-2609:49标题:安装客户端来做GM

前面服务端已经全部开启完毕了，让大家等急了吧，终于可以亲自体验一下自己的SF了。

1.将客户端里的所有文件复制到原征途游戏里，有提示就覆盖。

2.zt.exe这个文件是游戏主文件，而“我的征途.exe”这个文件是用来注册号用的，所以我们来运行ZT.exe这个文件，我这里有个默认的用户名1密码1

本回答由网友推荐

![mysql8026myini\_mysql8026myini][mysql8026myini_mysql8026myini]

## 请教MYSQL insert语句的长度限制 MYSQL语句最长可以多长 ##

只要插入值长度不超过字段限制，你的insert语句想写多长就写多长。

只是一次插入很多效率很低，如果是正常业务，这个表加了锁，其他与这个表的操作就会一直等待，影响业务正常运行，所以通常多了会分成多次插入。

## 如何在mysql创建my.ini 文件和data目录 ##

1、连接到mysql数据库服务器，查看默认存储目录位置。

2、关闭mysql服务进程，并创建新的存储位置。

3、在mysql数据文件复制或者移动到新的存储目录，并修改存储目录的目录权限。

4、修改mysql数据库配置文件，修改默认存储目录位置为新的目录位置，修改之前建议先备份配置文件。

5、修改完成后启动mysql服务，并连接数据库查看默认存储目录配置信息，可以看到已经修改为新的存储目录。

我不会~~~但还是要微笑~~~：)1、首先在我们的电脑上面找到mysql的安装路径，点击进去。

2、进去之后可以看到my.ini在mysql安装路径的根目录，这是其中一种情况。

3、另外一种情况是我们在mysql安装目录找不到，看到了my-default.ini文件，这时my.ini在“C:\\ProgramData\\MySQL\\MySQL Server 5.6”目录下面，我们首先需要找到ProgramData文件夹，这是一个隐藏文件，需要隐藏文件可见才行，或者可以直接检索。

4、我们可以看到在“C:\\ProgramData\\MySQL\\MySQL Server 5.6”目录下面找到了my.ini文件。

5、我们右键my.ini文件，选择打开方式，可以通过记事本和其他文本编辑器打开。

6、我们可以看到my.ini的文件打开了。

在安装的mysql文件夹MySQL\\MySQL Server 5.0下.会有

my-small.ini,my-large.ini,my-huge.ini等,根据自己数据库的繁忙程序,选择一个复制成my.ini,你要不知道该用哪一个的话,

就用my-medium.ini,复制一份,然后改名为my.ini即可

![mysql8026myini\_mysql8026myini][mysql8026myini_mysql8026myini]

## mysql的my.ini问题。请教高手 ##

datadir="F:/Program Files/MySQL/MySQL Server 4.1/Data/"

basedir="F:/Program Files/MySQL/MySQL Server 4.1/"

这两个路径 搞正确 就差不多了

可以看看下这个资料

实在不行给我留言

在本地计算机无法启动MYSQL服务错误1067进程意外终止 这种情况一般是my.ini文件配置出错了，

你可以删除系统目录下的my.ini文件，

把下面的内容重新写入my.ini文件试试，

要适当地改写一下文件路径

我的my.ini 2007年12月31日

\[WinMySQLAdmin\]

Server=C:/MYSQL/mysql/bin/mysqld-opt.exe

user=root

\[mysqld\]

basedir=C:/MYSQL/mysql

datadir=C:/MYSQL/mysql/data

\#bind-address=192.168.0.2

\#language=D:/MYSQL/share/chinese

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

\[WinMySQLAdmin\]

Server=D:/MYSQL/bin/mysqld-opt.exe

user=root

\[mysqld\]

basedir=D:/MYSQL

datadir=D:/MYSQL/data

\#bind-address=192.168.0.2

\#language=D:/MYSQL/share/chinese

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

查找Windows目录下的my.ini文件，编辑内容(如果没有该文件，则新建一个)，至少包含basedir，datadir这两个基本的配置。

\[mysqld\]

\# set basedir to installation path, e.g., c:/mysql

\# 设置为MYSQL的安装目录

basedir=D:/www/WebServer/MySQL

\# set datadir to location of data directory,

\# e.g., c:/mysql/data

\# 设置为MYSQL的数据目录

datadir=D:/www/WebServer/MySQL/data

另外，要注意：

\[WinMySQLadmin\]

Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe

user=root

password=xxxxxxxx

\#以上是设置WinMySQLadmin的配置

\[Client\]

user=root

password=xxxxxxxx

将Mysql添加到Windows系统服务中：

1.、 安装服务。

在Windows2000下，安装完成后，并没有把MySQL安装成服务，我们必须执行下面的语句把MySQL注册为服务：installdir\\mysql\\bin\\mysqld-nt –-install。

Windows98下没有服务的概念，所以不用安装服务。

2.、 启动服务

在Windows2000下，安装服务后可以启动MySQL服务：net start mysql。

在Windows98下，可以用下面的命令启动服务：c:\\mysql\\bin\\mysqld，服务启动后在后台运行，并没有界面。

3.、 停止服务

在Windows2000下，可以通过下面的命令停止MySQL服务：net stop mysql。

在Windows98下，可以通过下面命令停止服务：C:\\> C:\\mysql\\bin\\mysqladmin -u root shutdown这个没有办法的，默认是放在c:/mysql/mysql/data下面，如果你拷贝到d盘，你访问数据库看到的还是c:/mysql/mysql/data下面的数据，要想修改data的存储路径，必须只能修改php.ini，这是一个配置文件。\# The maximum amount of concurrent sessions the MySQL server will

\# allow. One of these connections will be reserved for a user with

\# SUPER privileges to allow the administrator to login even if the

\# connection limit has been reached.

max\_connections=800

\# Query cache is used to cache SELECT results and later return them

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

\# cache enabled may result in significant speed improvements, if your

\# have a lot of identical queries and rarely changing tables. See the

\# "Qcache\_lowmem\_prunes" status variable to check if the current value

\# is high enough for your load.

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

\# textually different every time, the query cache may result in a

\# slowdown instead of a performance improvement.

query\_cache\_size=71M

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

\# increases the number of file descriptors that mysqld requires.

\# Therefore you have to make sure to set the amount of open files

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

\# section \[mysqld\_safe\]

table\_cache=1520

\# Maximum size for internal (in-memory) temporary tables. If a table

\# grows larger than this value, it is automatically converted 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 for reuse. When a client

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

\# more than thread\_cache\_size threads from before. This greatly reduces

\# the amount of thread creations needed if you have a lot of new

\# connections. (Normally this doesn't give a notable performance

\# improvement if you have a good thread implementation.)

thread\_cache\_size=38

\#\*\*\* MyISAM Specific options

\# The maximum size of the temporary file MySQL is allowed to use while

\# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.

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

\# through the key cache (which is slower).

myisam\_max\_sort\_file\_size=100G

\# If the temporary file used for fast index creation would be bigger

\# than using the key cache by the amount specified here, 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 to create the index.

myisam\_max\_extra\_sort\_file\_size=100G

\# If the temporary file used for fast index creation would be bigger

\# than using the key cache by the amount specified here, 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 to create the index.

myisam\_sort\_buffer\_size=26M

\# Size of the Key Buffer, used to cache index blocks for 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 if you're not using

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

\# used for internal temporary disk tables.

key\_buffer\_size=109M

\# Size of the buffer used for doing full table scans of 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 rebuild the index in

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

\# into an empty table. It is allocated per thread so be careful with

\# large settings.

sort\_buffer\_size=256K

\#\*\*\* INNODB Specific options \*\*\*

\# Use this option if you have a MySQL server with InnoDB support enabled

\# but you do not plan to use it. This will save memory and disk space

\# and speed up some things.

\#skip-innodb

\# Additional memory pool that is used by InnoDB to store 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 need to change this

\# value. SHOW INNODB STATUS will display the current amount used.

innodb\_additional\_mem\_pool\_size=5M

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

\# disk at each commit, which offers full ACID behavior. If you are

\# willing to compromise this safety, and you are running small

\# transactions, you may set this to 0 or 2 to reduce disk I/O to the

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

\# the log file flushed to disk approximately once per second. Value 2

\# means the log is written to the log file at each commit, but the log

\# file is only flushed to disk approximately once per second.

innodb\_flush\_log\_at\_trx\_commit=1

\# The size of the buffer InnoDB uses for buffering log data. As soon as

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

\# once per second anyway, it does not make sense to have it very large

\# (even with long transactions).

innodb\_log\_buffer\_size=3M

\# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and

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

\# access data in tables. On a dedicated database server you may set this

\# parameter up to 80% of the machine physical memory size. Do not set it

\# too large, though, because competition of the physical 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 per process, so do not

\# set it too high.

innodb\_buffer\_pool\_size=210M

\# Size of each log file in a log group. You should set the combined size

\# of log files to about 25%-100% of your buffer pool size to avoid

\# unneeded buffer pool flush activity on log file overwrite. However,

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

\# recovery process.

innodb\_log\_file\_size=42M

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

\# depends highly on the application, hardware as well as the OS

\# scheduler properties. A too high value may lead to thread thrashing.

innodb\_thread\_concurrency=8

但是别人配置的MYSQL里的my.ini的内容就很少，，如下

port=3306

default-character-set=latin1

port=3306

default-character-set=latin1

default-storage-engine=INNODB

sql-mode="STRICT\_TRANS\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION"

max\_connections=120

query\_cache\_size=32M

table\_cache=256

tmp\_table\_size=9M

thread\_cache\_size=32

myisam\_max\_sort\_file\_size=100G

myisam\_max\_extra\_sort\_file\_size=100G

myisam\_sort\_buffer\_size=64M

key\_buffer\_size=128M

read\_buffer\_size=1M

read\_rnd\_buffer\_size=512K

sort\_buffer\_size=1M

innodb\_additional\_mem\_pool\_size=2M

innodb\_flush\_log\_at\_trx\_commit=1

innodb\_log\_buffer\_size=1M

innodb\_buffer\_pool\_size=18M

innodb\_log\_file\_size=10M

innodb\_thread\_concurrency=8

。。。请问是我配置错了还是什么原因，望高手指教！！！！

[mysql8026myini_mysql8026myini]: https://img0.baidu.com/it/u=1477382924,1990142993&fm=26&fmt=auto

mysql8026myini

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【MySQL 】MySQL 创建数据库， MySQL 删除数据库，MySQL 选择数据库

相关【MySQL】MySQL里程碑

相关【MySQL】----初始MySQL

相关 MYSQL、MySQL、MySql、mysql 批量更新SQL写法实践

相关 mysql8026myini

相关【MySQL】MySQL 学习

相关 mysql 游標,MySQL - Cursors | mysql Tutorial

相关【MySQL】使用MySQL

相关【MySQL】MySQL简介

相关 mysql pmadb_MYSQL