# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
# MySQL官方文档里面好像没有提及这东西,但是Google告诉我最好还是添加一下又不会死~=。=
[ WinMySQLAdmin ]
Server = "C:/Aroma/mysql-5.6.10/bin/mysqld.exe"
[ mysqld ]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# "base"="基本","dir"="目录",意思就是MySQL的安装目录
basedir = "C:/Aroma/mysql-5.6.10"
# "data"="数据","dir"="2B么~看上面",意思就是网站的MySQL数据目录
datadir = "C:/Aroma/mysql-5.6.10/data"
# 端口...
port = 3306
# server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
# 默认配置,理得它是啥干嘛,保留之~
sql_mode = NO_ENGINE_SUBSTITUTION , STRICT_TRANS_TABLES
进入CMD命令行环境,安装MySQL服务:
C : \ Documents and Settings \ Administrator > cd C : \ Aroma \ mysql - 5.6.10 \ bin
C : \ Aroma \ mysql - 5.6.10 \ bin > mysqld -- install mysql5 -- defaults - file = C : \ Aroma \ mysql - 5.6.10 \ my . ini
Service successfully installed .
这样,MySQL基本上配置完毕了,现在只要启动MySQL并且修改一下root密码增加安全性即可:
1、mysql -u root -p执行后由于默认没有密码,所以直接回车OK!
2、这里语句的默认密码是password,您就可以发挥您的聪明才智=。=~
3、语句记得带;哦~表示语句结束~
C : \ Documents and Settings \ Administrator > cd C : \ Aroma \ mysql - 5.6.10 \ bin
C : \ Aroma \ mysql - 5.6.10 \ bin > net start mysql5
C : \ Aroma \ mysql - 5.6.10 \ bin > mysql - u root - p
MySQL > use MySQL ;
MySQL > SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ( 'password' ) ;
MySQL > flush privileges ;
MySQL > exit ;
Einführung zu VPS und dessen Bedeutung 在这个数字时代,越来越多的人寻求建立一个稳固的网络环境,特别是在搭建梯子方面。VPS,即虚拟专用服务器,成为了许多用户的优先选择。我第一次接触VPS是在寻找一个能稳定访问不同网站的解决方案时。简单来说,VPS允许用户在共享...