MYSQL 简介

免安装版使用

安装服务

mysqld -install
mysqld -install osmysql // 安装MYSQL，服务名称为osmysql

启动服务，以后自动启动

net start mysql

新版本的mysql免安装版，会提示启动失败，此时需要做一个特殊的处理，参考解决Windows安装解压版MySQL出现服务正在启动-服务无法启动的问题 即刻解决问题。

• 我的my.ini内容

  # For advice on how to change settings please see
  # http://dev.mysql.com/doc/refman/5.7/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.
  [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.
  #basedir代表自己MySQL的安装根目录
  basedir = D:\mysql
  #datadir代表自己MySQL的数据库保存的目录，如果没有在MySQL安装的根目录下新建一个data文件夹 
  datadir = D:\mysql\data
  #port代表端口号
  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 
  

• 进入mysql文件夹，执行下面的命令

bin\mysqld --defaults-file=my.ini --initialize-insecure

• 再进入bin文件夹，执行安装服务的命令

停止服务

net stop mysql

移除服务

mysqld -remove

登录本机mysql服务器

mysql -uroot
mysql -hlocalhost-u[用户名] -p[密码]

常用工具

1. phpmyadmin php语言编写的Web管理程序，Linux推荐使用
2. SQLyog 桌面管理软件，Windows推荐使用
3. Navicat For MySQL