生产安装mysql

古城微笑少年丶 2022-07-28 11:40 78阅读 0赞

**1.配置yum源**

*  vim /etc/yum.repos.d/mysql-community.repo

> 输入如下内容：  
> \[mysql-connectors-community\]  
> name=MySQL Connectors Community  
> baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/6/$basearch/  
> enabled=1  
> gpgcheck=1  
> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql  
>

> \[mysql-tools-community\]  
> name=MySQL Tools Community  
> baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/6/$basearch/  
> enabled=1  
> gpgcheck=1  
> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql  
>   
> \# Enable to use MySQL 5.5  
> \[mysql55-community\]  
> name=MySQL 5.5 Community Server  
> baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/  
> enabled=0  
> gpgcheck=1  
> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql  
>   
> \# Enable to use MySQL 5.6  
> \[mysql56-community\]  
> name=MySQL 5.6 Community Server  
> baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/  
> enabled=1  
> gpgcheck=1  
> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql  
>   
> \[mysql57-community\]  
> name=MySQL 5.7 Community Server  
> baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/  
> enabled=0  
> gpgcheck=1  
> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql  
>

**2.yum安装**

> **yum list|grep mysql-community**  
> mysql-community-bench.x86\_64               5.6.30-2.el6                 mysql56-community  
> mysql-community-client.i686                5.6.30-2.el6                 mysql56-community  
> mysql-community-client.x86\_64              5.6.30-2.el6                 mysql56-community  
> mysql-community-common.i686                5.6.30-2.el6                 mysql56-community  
> mysql-community-common.x86\_64              5.6.30-2.el6                 mysql56-community  
> mysql-community-devel.i686                 5.6.30-2.el6                 mysql56-community  
> mysql-community-devel.x86\_64               5.6.30-2.el6                 mysql56-community  
> mysql-community-embedded.i686              5.6.30-2.el6                 mysql56-community  
> mysql-community-embedded.x86\_64            5.6.30-2.el6                 mysql56-community  
> mysql-community-embedded-devel.i686        5.6.30-2.el6                 mysql56-community  
> mysql-community-embedded-devel.x86\_64      5.6.30-2.el6                 mysql56-community  
> mysql-community-libs.i686                  5.6.30-2.el6                 mysql56-community  
> mysql-community-libs.x86\_64                5.6.30-2.el6                 mysql56-community  
> mysql-community-libs-compat.i686           5.6.30-2.el6                 mysql56-community  
> mysql-community-libs-compat.x86\_64         5.6.30-2.el6                 mysql56-community  
> mysql-community-release.noarch             el6-5                        mysql-connectors-community  
> mysql-community-server.x86\_64              5.6.30-2.el6                 mysql56-community  
> mysql-community-test.x86\_64                5.6.30-2.el6                 mysql56-community  
> **yum install mysql-community-libs-compat-5.6.28-2.el6.x86\_64  
> yum install mysql-community-server-5.6.28-2.el6.x86\_64  
> rpm -qa|grep mysql**  
> mysql-community-client-5.6.28-2.el6.x86\_64  
> mysql-community-libs-compat-5.6.28-2.el6.x86\_64  
> mysql-community-libs-5.6.28-2.el6.x86\_64  
> mysql-community-server-5.6.28-2.el6.x86\_64  
> mysql-community-common-5.6.28-2.el6.x86\_64  
>

**3.启动mysql**

> service mysqld start  
>

**4.设置root密码**

> /usr/bin/mysqladmin -u root password '××××××'  
>

**5.更改超级用户，删除敏感root账户，授权一般用户**

*  **查看root权限**

>         mysql> show grants for 'root'@'localhost';  
>         +----------------------------------------------------------------------------------------------------------------------------------------+  
>         | Grants for root@localhost                                                                                                              |  
>         +----------------------------------------------------------------------------------------------------------------------------------------+  
>         | GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '\*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |  
>         | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |  
>         +----------------------------------------------------------------------------------------------------------------------------------------+  
> 
> 
>         2 rows in set (0.00 sec)  
>

*  **授予超级用户和root相同权限**

> grant all privileges on \*.\* to '超级用户'@'127.0.0.1' identified by '超级用户密码' with grant option;  
> grant proxy on ''@'' to '超级用户'@'127.0.0.1' with grant option;  
>

*  **删除其他授权**

> 查看不安全授权：select \* from mysql.user where user='root' or user='';  
> 删除授权：delete from mysql.user where user='root' or user='';flush privileges;  
> 再次检查：select \* from mysql.user;  
>

*  **授予普通用户增删改查**

> GRANT SELECT, INSERT, UPDATE, DELETE ON 数据库名.\* TO '普通用户'@'127.0.0.1'  IDENTIFIED BY '普通用户密码';  
>

**6.上传数据文件，导入数据库**

**7.更改配置文件**

\# For advice on how to change settings please see  
\# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html  
  
\[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  
\#  
\# 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  
\# \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#innodb setting\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
datadir=/var/lib/mysql  
socket=/var/lib/mysql/mysql.sock  
character\_set\_server = utf8  
back\_log=1024  
max\_connections = 3000  
max\_connect\_errors = 6000  
read\_buffer\_size = 4M  
max\_allowed\_packet=128M  
\#0:fastest,but most insecure;1:safest,but slowest;2:between 0 and 1  
innodb\_flush\_log\_at\_trx\_commit=1  
sync\_binlog=1  
innodb\_support\_xa=1  
innodb\_doublewrite=1  
innodb\_log\_file\_size = 200M  
innodb\_log\_files\_in\_group = 3  
\#memory\*(0.5~0.7)  
innodb\_buffer\_pool\_size = 4096M  
innodb\_log\_buffer\_size = 64M  
query\_cache\_size = 0  
skip\_name\_resolve  
\#default timestamp  
explicit\_defaults\_for\_timestamp=true  
\#no lower\_case  
lower\_case\_table\_names = 1  
\#init\_connect='SET autocommit=0'  
innodb\_lock\_wait\_timeout = 50  
\# Disabling symbolic-links is recommended to prevent assorted security risks  
symbolic-links=0  
  
\# Recommended in standard MySQL setup  
\#sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES  
sql\_mode=NO\_ENGINE\_SUBSTITUTION  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#replication setting\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#replication setting  
server-id=1  
log-bin=mysql-bin  
binlog\_format=MIXED  
binlog\_error\_action=ABORT\_SERVER  
expire\_logs\_days=7  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#log setting\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#general log  
\#general\_log=1  
\#general\_log\_file=/var/log/mysql/mysql-row.log  
\#slow log  
slow\_query\_log=1  
slow\_query\_log\_file=/var/log/mysql/mysql-slow.log  
long\_query\_time=2  
\#log-queries-not-using-indexes  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
\[mysqld\_safe\]  
log-error=/var/log/mysql/mysqld.log  
pid-file=/var/run/mysqld/mysqld.pid

**8.重启mysql**

> service mysqld restart  
>

**9.设置开机起动**

> chkconfig mysqld on  
>