mysql布署时,因为my.ini需要设置mysql路径为当前路径。只需要执行下本批处理路径,自动生成my.ini,并且自动安装mysql服务开机自启动。
个性化参数自己改,如端口号,服务名等。
my.bat文件如下,建个bat拷进去。
set cpath=%~dp0
del %cpath%\my.ini
echo [mysqld] >> %cpath%\my.ini
echo innodb_buffer_pool_size = 128M >> %cpath%\my.ini
set mypath=%cpath%
echo basedir =%mypath:\=/% >> %cpath%\my.ini
echo datadir = %mypath:\=/%Data >> %cpath%\my.ini
echo port = 3306 >> %cpath%\my.ini
echo max_connections=200 >> %cpath%\my.ini
echo max_connect_errors=10 >> %cpath%\my.ini
echo character_set_server=utf8mb4 >> %cpath%\my.ini
echo default-storage-engine=INNODB >> %cpath%\my.ini
echo default_authentication_plugin=mysql_native_password >> %cpath%\my.ini
echo join_buffer_size = 128M >> %cpath%\my.ini
echo sort_buffer_size = 2M >> %cpath%\my.ini
echo read_rnd_buffer_size = 2M >> %cpath%\my.ini
echo sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES >> %cpath%\my.ini
echo [mysql] >> %cpath%\my.ini
echo default-character-set=utf8mb4 >> %cpath%\my.ini
echo [client] >> %cpath%\my.ini
echo port=3306 >> %cpath%\my.ini
echo default-character-set=utf8mb4 >> %cpath%\my.ini
cd bin
mysqld --install MySQL
pause