Mysql.tar的安装

mysql的安装

用网络yum源，要可以ping通百度，不可以就配置网卡文件(DNS1=114.114.114.114)

下载源码包：mysql-5.6.43-linux-glibc2.12-x86_64.tar（可以是任意版本，取决于本身的源码包）

[root@localhost ~]# ll
[root@localhost ~]# cd /usr/local/src 软件包都放在这里方便管理

[root@localhost src]# mv /root/mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz .
[root@localhost src]# ll
[root@localhost src]# tar -zxf mysql-5.6.43-linux-glibc2.12-x86_64.tar

安装和配置
[root@localhost src]# [ -d /usr/local/mysql ] && mv /usr/local/mysql /usr/local/mysql_old (-d前面有空格)

[root@localhost src]# mv mysql-5.6.35-linux-glibc2.12-x86_64 /usr/local/mysql 挪动位置
[root@localhost src]# ll !$

[root@localhost src]# useradd -s /sbin/nologin mysql 建立MySQL用户，因为启动MySQL需要该用户

[root@localhost src]# mkdir -p /data/mysql 创建datadir,数据库文件会放到这里面

[root@localhost src]# chown -R mysql:mysql /data/mysql 更改权限，不更改后续操作就会出问题

[root@localhost src]# yum install -y perl-Module-Install    (如果报错，回去配置网卡文件、ping通百度)
[root@localhost src]# cd /usr/local/mysql
[root@localhost src]# ll
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql

[root@localhost mysql]# cp support-files/my-default.cnf /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? y

[root@localhost mysql]# vi  /etc/my.cnf          修改配置文件
[mysqld]
basedir=/usr/local/mysql                                //basedir表示MySQL包所在路径
datadir=/data/mysql             //表示定义存放数据的位置
port=3306                  //port表示定义MySQL服务监听的端口号
server_id=90                  //表示该MySQL服务的ID号
socket = /tmp/mysql.sock           //定义MySQL服务监听的套接字地址

[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysqld 复制启动脚本文件
[root@localhost mysql]# ll -d /etc/init.d/mysqld

[root@localhost mysql]# chmod  755  /etc/init.d/mysqld          修改启动脚本文件的属性
[root@localhost mysql]# chkconfig --add mysqld            把mysql服务加到系统服务列表中
[root@localhost mysql]# chkconfig mysqld on        开机自启动
[root@localhost mysql]# service mysqld start         启动服务(如果报错，先看上面的配置文件是否写错)
[root@localhost mysql]# chkconfig --list

[root@localhost mysql]# ps -aux | grep mysqld
[root@localhost mysql]# yum install -y net-tools
[root@localhost mysql]# netstat -ntpl | grep 3306
或 [root@localhost mysql]# netstat -ntpl

[root@localhost mysql]# yum install -y mariadb
[root@localhost mysql]# mysql -u root -S /tmp/mysql.sock 登录

设置登录时不加-S /tmp/mysql.sock参数
[root@localhost mysql]# vi /etc/my.cnf
socket = /tmp/mysql.sock
修改为
socket = /var/lib/mysql/mysql.sock

[root@localhost mysql]# mkdir /var/lib/mysql
[root@localhost mysql]# chmod 777 /var/lib/mysql

[root@localhost mysql]# service mysqld restart 重启
Shutting down MySQL… SUCCESS!
Starting MySQL. SUCCESS!

[root@localhost mysql]# mysql -u root 修改root密码
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.47 MySQL Community Server (GPL)

Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MySQL [(none)]> set password for root@localhost =password(‘000000’);
Query OK, 0 rows affected (0.00 sec)

MySQL [(none)]> Ctrl-C – exit!
Aborted

[root@localhost mysql]# mysql -uroot -p000000 退出重新登录
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.47 MySQL Community Server (GPL)

Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MySQL [(none)]> Ctrl-C – exit!
Aborted