Linux下mysql的搭建

[root@localhost /]# rpm -qa | grep mariadb
[root@localhost /]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
[root@localhost /]# rpm -qa | grep mariadb

[root@localhost /]# rpm -qa | grep mysql
[root@localhost /]# rpm -e –-nodeps mysql-libs-5.1.52.x86_64

[root@localhost ~]# cat /etc/group | grep mysql
[root@localhost ~]# cat /etc/passwd |grep mysql
[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -r -g mysql mysql

tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

mv /home/mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql

[root@localhost ~]# mkdir /usr/local/mysql/data

[root@localhost /]# cd /usr/local/
[root@localhost local]# chown -R mysql:mysql mysql/
[root@localhost local]# chmod -R 755 mysql/

[root@localhost local]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
2017-08-31T08:50:23.910440Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-08-31T08:50:23.910635Z 0 [ERROR] Can‘t find error-message file ‘/usr/local/mysql/--datadir=/usr/local/mysql/data/share/errmsg.sys‘. Check error-message file location and ‘lc-messages-dir‘ con
figuration directive.2017-08-31T08:50:24.709286Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-08-31T08:50:24.767540Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-08-31T08:50:24.892629Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 6e083b8f-8e29-11e7-88b1-
005056b427be.2017-08-31T08:50:24.895674Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed‘ cannot be opened.
2017-08-31T08:50:24.896645Z 1 [Note] A temporary password is generated for root@localhost: I-ob%8TmpF,0  

[root@localhost local]# /usr/local/mysql/support-files/mysql.server start

[root@localhost local]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
[root@localhost local]# service mysql restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS!

[root@localhost local]# ln -s /usr/local/mysql/bin/mysql /usr/bin

[root@localhost local]# mysql -u root -p
Enter password:

msql>alter user ‘root‘@‘localhost‘ identified by ‘123456‘;
mysql>use mysql;
msyql>update user set user.Host=‘%‘ where user.User=‘root‘;
mysql>flush privileges;
mysql>quit

[root@localhost local]# vi /usr/local/mysql/my.cnf

[mysqld]
port = 3306
sql_mode=
transaction_isolation=READ-COMMITTED

log_bin_trust_function_creators=1
lower_case_table_names=1
binlog_format=mixed

service mysqld restart

/usr/local/mysql/support-files/mysql.server start

复制代码
1、开启防火墙 
    systemctl start firewalld

2、开放指定端口
      firewall-cmd --zone=public --add-port=3306/tcp --permanent
 命令含义：
--zone #作用域
--add-port=1935/tcp  #添加端口，格式为：端口/通讯协议
--permanent  #永久生效，没有此参数重启后失效

3、重启防火墙
      firewall-cmd --reload

4、查看端口号
netstat -ntlp   //查看当前所有tcp端口·

netstat -ntulp |grep 1935   //查看所有1935端口使用情况