安装
1.下载解压,将bin目录,追加到Path环境变量。
2.修改my-default.ini或者my-small.ini配置文件, 复制成my.ini,主要设置basedir,datadir属性。如下:
1 2 3 4 5 6 |
[mysqld] basedir = D:\DevTools\mysql datadir = D:\DevTools\mysql\data sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES port=3306 skip-grant-tables |
注:mysql 默认配置文件名为:my-default.ini,编码为ascii码。 如果指定log_error = “D:\DevTools\mysql\logs\error.log”;那么必须创建logs文件夹
3.以管理员身份运行
1 2 3 |
mysqld --initialize //最好使用这个命令 //或者 mysqld --initialize-insecure --user=mysql |
进行MYSQL初始化
1.插入MSYQL服务,输入:
1 |
mysqld --install |
如果要移除服务,使用
1 |
mysqld remove |
2.启动服务:
1 |
net start mysql |
修改密码:
1 2 3 4 5 6 7 8 |
mysql -h localhost -uroot mysql>show databases; mysql>use mysql; mysql>UPDATE user SET password=PASSWORD('123456') WHERE user='root'; //旧版本 mysql>update mysql.user set authentication_string=password('123456') where user='root' and Host = 'localhost'; //新版本 mysql>update mysql.user set authentication_string=password('123456') where user='root' and Host = '%'; //新版本 mysql>FLUSH PRIVILEGES; mysql>QUIT |
创建账户:
1 2 3 4 5 |
mysql -h localhost -uroot use mysql; CREATE USER root@'%' IDENTIFIED BY '123456'; GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456'; FLUSH PRIVILEGES; |
其他账户不要访问所有,只访问规定的就好
1 2 3 4 5 6 7 |
mysql -h localhost -uroot use mysql; CREATE USER pandy@'%' IDENTIFIED BY 'pandy'; GRANT ALL PRIVILEGES ON pandy_db1.* TO pandy@'%' IDENTIFIED BY 'pandy'; GRANT ALL PRIVILEGES ON pandy_db2.* TO pandy@'%' IDENTIFIED BY 'pandy'; GRANT ALL PRIVILEGES ON pandy_db3.* TO pandy@'%' IDENTIFIED BY 'pandy'; FLUSH PRIVILEGES; |
mysql 5.7中,自己配置得到的my.ini
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
#注意,低版本中key_buffer_size 可能是key_buffer [client] port = 3306 socket = "D:\DevTools\mysql\mysql.sock" [mysqld] character_set_server=utf8 basedir = D:\DevTools\mysql datadir = D:\DevTools\mysql\data sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES port=3306 #skip-grant-tables pid_file = "mysql.pid" socket = "D:\DevTools\mysql\mysql.sock" key_buffer_size = 16M max_allowed_packet = 100M sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log_error = "D:\DevTools\mysql\logs\error.log" server-id = 1 wait_timeout=2880000 interactive_timeout = 2880000 lower_case_table_names=2 [mysqldump] quick max_allowed_packet = 100M [isamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M |