【linux 版本要求】: gcc version 5.4.0 20160609 (Ubuntu 5.4.0-6ubuntu1~16.04.12
查询版本号: cat /proc/version
升级:apt-get update; 和 apt-get upgrade;
【MYSQL部署】:
【步骤一】:
上传安装包 mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz 到 /usr/local/并修改解压出的文件夹名为/usr/local/mysql
tar -xvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
【步骤二】:
创建my.cnf并放入/etc文件夹下,配置如下:
#======================================
[mysqld]
local-infile=0
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/data/mysql.err
pid-file=/usr/local/mysql/data/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
lower_case_table_names=1
#======================================
【步骤三(创建mysql用户组)】:
检查是否已存在mysql用户及用户组
cat /etc/group | grep mysql
cat /etc/passwd |grep mysql
创建组和用户:
groupadd mysql
useradd -r -g mysql mysql
授权目录和用户
cd /usr/local/
chown -R mysql:mysql mysql/
chmod -R 755 mysql/
创建数据目录及授权
mkdir -p /usr/local/mysql/data
chown mysql:mysql -R /usr/local/mysql/data
chown 755 -R /usr/local/mysql/data
【步骤四(初始化数据库,开机启动)】:
初始化数据库(重新初始化时rm -rf 数据库data文件夹 rm -rf /usr/local/mysql/data)
cd /usr/local/mysql/bin/
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --user=mysql --initialize
启动mysql,并更改root 密码
先将mysql.server放置到/etc/init.d/mysql中
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
添加mysql权限
chmod 755 /etc/init.d/mysql
重启mysql(如果失败则执行apt-get upgrade;或者先加入自动启动并重启机器Linux)
systemctl restart mysql
service mysql restart
查看mysql运行状态
service mysql status
ubuntu16.04开机启动mysql:
sysv-rc-conf --list
sysv-rc-conf --level 2345 mysql on
如果命令不存在下载命令:sudo apt-get install sysv-rc-conf
red Hat 开启及启动mysql;
chkconfig --list 查看启动
chkconfig --level 2345 mysql on
【步骤五(登录数据库)】:
查看初始秘密mysql(如root@localhost: 0hhc,rN;wKov)
cat /usr/local/mysql/data/mysql.err
登录mysql(/usr/local/mysql/bin目录下)
cd /usr/local/mysql/bin
./mysql -u root -p 或 ./mysql -h 192.168.1.1 -u root -p
修改登录密码
SET PASSWORD = PASSWORD('123456NK5jNmeXw');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
使root可以在任何ip访问
use mysql;
update user set host = '%' where user = 'root';
grant all privileges on *.* to root@'%' identified by '123456NK5jNmeXw' with grant option;
FLUSH PRIVILEGES;
时区问题设置
show variables like '%time_zone%';
set global time_zone = '+08:00';
set time_zone = '+08:00';