CentOS 7装mysql

安装mysql

CentOS 7的yum源中貌似没有正常安装mysql时的mysql-sever文件，需要去官网上下载

echo "下载mysql的repo源"
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

echo "安装rpm包"
rpm -ivh mysql-community-release-el7-5.noarch.rpm

echo "安装mysql"
yum install mysql-community-server

成功安装之后重启mysql服务

# systemctl restart  mysqld.service

初次安装mysql是root账户是没有密码的.

---

设置密码与远程登录

1.设置root的密码为mypassword,
2.将所有操作权限授予用户 ( 用户名为power && 密码为password && 来自任何IP )

# mysql -uroot

mysql> use mysql;
mysql> update user set password=password('mypassword') where user='root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'power'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 
mysql> flush privileges;
mysql> exit;

---

修改MySQL字符集编码

vim /etc/my.cnf

[mysqld]
init_connect=’SET collation_connection = utf8_unicode_ci’
init_connect=’SET NAMES utf8’
character-set-server=utf8
collation-server=utf8_unicode_ci

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

---

防火墙规则修改

firewall-cmd --permanent --add-port=3306/tcp 
firewall-cmd --reload

---

重启mysql重载生效配置

# systemctl restart  mysqld.service

---

登录报错：

ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket‘/var/lib/mysql/mysql.sock‘ (2)

原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysql的拥有者改为当前用户：

$ sudo chown -R mysql:mysql /var/lib/mysql

---