首页

欢迎访问

centos7安装mysql

发布时间:2016-06-14 00:01:21

centos7安装mysql

1,mysql安装
yum install mysql
yum install mysql-server
yum install mysql-devel

安装mysql和mysql-devel都成功,但是安装mysql-server可能失败,如下:

2,官网下载安装mysql-server
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server

3,安装成功后重启mysql服务
service mysqld restart

4,设置密码
set password for 'root'@'localhost'=password('123456');

5,进入mysql数据库
mysql -hlocalhost -uroot -p   ///   mysql -u root -p      /////mysql -u root


6,mysql配置文件为/etc/my.cnf最后加上编码配置

[mysql]
default-character-set =utf8

这里的字符编码必须和/usr/share/mysql/charsets/Index.xml中一致。

<charset name="utf8">
  <family>Unicode</family>
  <description>UTF-8 Unicode</description>
  <alias>utf-8</alias>
  <collation name="utf8_general_ci"    id="33">
   <flag>primary</flag>
   <flag>compiled</flag>
  </collation>
  <collation name="utf8_bin"        id="83">
    <flag>binary</flag>
    <flag>compiled</flag>
  </collation>
</charset>

我要评论+
评论列表