#默认root密码为空 mysqld --initialize-insecure #或者默认root密码随机 mysqld --initialize
[client] loose-default-character-set = utf8 [mysqld] innodb_buffer_pool_size = 128M port = 3306 join_buffer_size = 128M sort_buffer_size = 2M read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES Character-set-server = utf8 # basedir = .... # datadir = ....
# 设置相对目录 echo basedir="%cd%\mysql">>mysql\my.ini echo datadir="%cd%\mysql\data">>mysql\my.ini mysqld\bin\mysqld --install
启动服务
net start mysql
mysql
#方法1 mysqladmin -u root -p password [新密码] #方法2,利用管道静默设置root密码 echo set password for root@localhost = password('123456'); | mysql -uroot [-p老密码]
拷贝mysql目录,而后从第一次安装的第4步骤操做便可。sql