系统 centOS6.5
一、安装步骤:
1、查看rpm方式安装的mysql -i 表示忽略大小写
rpm -qa|grep -i mysql
2、卸载 忽略依赖
rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps
yum方式安装的mysql
yum list mysql
卸载
yum remove mysql
3、下载tar包 mysql-5.7.22-1.el6.x86_64.rpm-bundle
解压 tar -xvf mysql-5.7.22-1.el6.x86_64.rpm-bundle -C 路径
安装顺序为
common libs client server
4、初始化
mysqld --initialize --user=mysql
完成后日志文件中会有初始密码vim /var/log/mysqld.log/
5、启动、登录 、修改密码 授权远程 开启端口
service mysqld start
mysql -u root -p
输入日志文件中的初始密码
SET PASSWORD FOR 'root'@'localhost'=PASSWORD('123123');
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "123123";
select host,user from user;
quit
1. 开放端口: /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
2.保存:/etc/rc.d/init.d/iptables save
3.重启:/etc/init.d/iptables restart
4.查看端口是否开放:/sbin/iptables -L -n
测试远程登录即可
后补:
二、编码问题
1、 vim /etc/my.cnf 添加以下内容,保存退出
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
service mysqld restart 重启
2、 检查编码方式:
mysql> show variables like 'char%'; 标黄为重点查看
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
3、修改库编码alter database 数据库名 character set utf8;
use 数据库名
4、status 查看数据库编码 如下
Connection id: 41
Current database: XX
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 53 min 14 sec
三、关于mysql远程连接慢的问题
解决方案:禁止域名解析(此操作后只能通过ip访问)
[mysqld]
skip-name-resolve
重启服务
测试连接即可