colinmok的专栏

将mysql-5.5.25-winx64.zip 解压缩到F:\mysql-5.5.25-winx64 目录下：1、将my-large.ini改名为my.ini2、在my.ini中添加[client]#字符集设置default-character-set = utf8user=rootpassword=password[mysqld]#系统基本目录b

mysql-5.6.20-winx64免安装版数据库中文乱码，需要修改配置文件my.ini和my-default.ini[client]default-character-set=utf8[mysqld]default-storage-engine=INNODBcharacter-set-server=utf8collation-server=utf8_ge

用UPDATE直接编辑user表　　mysql -u root　　mysql> use mysql;　　mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';　　mysql> FLUSH PRIVILEGES;在丢失root密码的时候，可以这样　　m

centos6.5用yum安装mysql5.6方法第一步：导入mysql版本库 ‘yum install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm第二步：安装mysql相应类库yum install mysql mysql-devel mysql-server mysql-utilitie

一.下载解压包mysql-5.7.10-winx64.zip本文解压到E:\根目录下，完整路径为E:\mysql-5.7.10-winx64二.解压配置mysql-5.7.10-winx64.zip解压，新建一个my.ini文件   配置如下：[mysqld]port = 3310basedir = E:\mysql-5.7.10-winx6