首先,今天写了个很简单的j2ee程序,全部的业务逻辑都没问题,我反复检查,出现中文乱码问题,搞得我头大,最后我把mysql卸载安装了下,从新配置了,好了。。。。。这个时候我想愤怒。不过仍是问题解决了,获得了巨人的帮助,实在感谢。明天写个博客,今天先把在这里说下。html
你要是首次安装忽略下面的话mysql
sc delete mysql 删除mysql 这个时候你在打开mysql服务,已经没有了
接着你要web
1,删除mysql文件(直接删除)
2,清理下注册表,path变量sql
关于清理注册表,请百度安全
===========================================
首次安装服务器
将压缩包解压到你要安装的目录下,个人是:编辑器
D:\Program Files (x86)\JavaEE\mysqlsvg
-1 配置
- 打开安装目录下的配置文件
- my-default.ini(复制一份)修改文件名为my.ini
- 打开安装目录下的配置文件my-default.ini(复制一份)修改文件名为my.ini
- 用文本类编辑器打开,找到basedir相应位置,将#去掉
- 添加路径 ui
basedir = D:\Program Files (x86)\JavaEE\mysql\mysql-5.6.28-winx64
datadir=D:\Program Files (x86)\JavaEE\mysql\mysql-5.6.28-winx64\data
port = 3306编码
1. mysqld --console
2. mysqld --initialize
3. mysqld install
3) 安装成功后会提示服务安装成功。
2.配置环境变量path
- 打开控制面板>系统和安全>系统>高级系统设置>path变量(不在多说)
- 以管理员身份运行cmd,进入MySQL的bin目录,输入mysqld -install
- 安装成功后就要启动服务了 net start mysql服务启动成功!
- 服务启动成功以后,就能够登陆了,输入mysql -uroot -p(第一次登陆没有密码,直接按回车过),登陆成功!
3设置密码(无关紧要,有仍是比较好的)
mysql安装以后默认root密码是空
输入mysql -uroot 便可进去mysql
进去以后怎样设置初始密码呢: 输入mysql -uroot 便可进去mysql
进去以后设置初始密码呢:
一、执行(注意分号sql语句)
use mysql ;
update user set password=password(“new_pass”) where user=”root”;
flush privileges;
exit ;
便可。
二、设置新密码跟1中同样
三、忘记密码
在my.ini中加入 [mysqld] 跳过密码验证
skip-name-resolve 而后在cmd中直接输入mysql -uroot
进去,而后执行1中的步骤
参考 http://blog.csdn.net/stypace/article/details/38232393
4 修改默认编码的配置。
参考 http://www.2cto.com/database/201504/394479.html
打开my.ini文件在
在[mysqld]下面添加 character_set_server=utf8,注意是【utf8】不是【utf-8】并且后面没有任何标点符号;
在【sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES】这句话后面再添加三行
[client]
port=3306
default-character-set=utf8
四、通过以上三步就ok了。保存后重启服务器,登录后在命令行输入:
show variables like 'char%';
可查看默认字符集以下图所示:
mysql> show variables like 'char%'; +--------------------------+-------------------------------------------------------------------------+
| Variable_name | Value | +--------------------------+-------------------------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\Program Files (x86)\JavaEE\mysql\mysql-5.6.28-winx64\share\charsets\ | +--------------------------+-------------------------------------------------------------------------+
8 rows in set (0.00 sec)
打开my.ini文件以下:总的作相应的更改
# 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.
[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 = D:\mysql-5.6.24-winx64
datadir = D:\mysql-5.6.24-winx64\data
port = 3306
# server_id = .....
character_set_server=utf8
# 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
[client]
port=3306
default-character-set=utf8
mysql命令行下区分大小写设置
[mysqld]
lower_case_table_names=2
开启MySQL远程链接
use mysql
使用“GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;”命令能够更改远程链接的设置。
flush privileges;
select host,user from user;
就要修改它的host为%,表示任意IP地址均可以登陆.
或者经过
navicat修改
mysql> update user set host = ‘%’ where user = ‘root’;
执行完后可能提示error.再mysql> select host,user from user;查看下吧.
root对应的host成了%,表示能够任意IP地址登陆了.