一般下一个绿色版本的mysql，里面就4个文件bin，data，share，mysql.ini。
其他文件都可以暂时不用动，打开mysql.ini改里面的信息就可以了。
简版
#This File was made using the WinMySQLAdmin 1.4 Tool
#2004-09-30 07:57:57
#Uncomment or Add _disibledevent=>mysql
#bind-address=127.0.0.1
datadir=D:/单机版网游/服务端/mysql/data
#language=D:/单机版网游/服务端/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=6060
set-variable = max_connections=1500
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
#set-variable = connect_timeout=5
#set-variable = wait_timeout=5
server-id = 1
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[WinMySQLadmin]
Server=D:/单机版网游/服务端/mysql/bin/mysqld-nt.exe
user=test
password=test
然后就是启动和关闭文件 XXXX.bat XXXX.bat
@ECHO OFF
copy D:\单机版网游\服务端\mysql\my.ini %SystemRoot% /y
D:\单机版网游\服务端\mysql\bin\mysqld-nt.exe -install
net start mysql
@ECHO OFF
net stop mysql
D:\单机版网游\服务端\mysql\bin\mysqld-nt.exe -remove
进入mysql后，在mysql里面的user表里面，找到用户。修改密码
update user set password=password('newpassword') where user='xxxx';
最新评论