linux下的mysql安装手册
1,下载linux版本mysql-5.7.39-linux-glibc2.12-x86_64.tar.gz安装包
2,解压(此次安装以mysql安装在/usr/local/下为例)
tar -xvf mysql-5.7.39-linux-glibc2.12-x86_64.tar.gz
3,移动并重命名
mv mysql-5.7.39-linux-glibc2.12-x86_64 /usr/local/mysql
4,创建mysql用户组和用户并修改权限
groupadd mysql
useradd -r -g mysql mysql
5,创建数据目录并赋予权限
创建数据存储目录
mkdir -p /usr/local/data
赋予权限
chown mysql:mysql -R /usr/local/data
6,配置my.cnf(不存在则创建)
vim /etc/my.cnf
7,内容如下
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/data/mysql.sock
log-error=/usr/local/mysql/data/mysql.err
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/usr/local/mysql/data/mysql.sock
[mysqldump]
socket=/usr/local/mysql/data/mysql.sock
[mysqladmin]
socket=/usr/local/mysql/data/mysql.sock
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
8,进入mysql的bin目录
cd /usr/local/mysql/bin/
9,初始化数据库
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql --initialize
10,查看密码
cat /usr/local/mysql/data/mysql.err
11,将mysql.server放置到/etc/init.d/mysql中,并启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
ps -ef|grep mysql
12,登录mysql,前面的那个是随机生成的
# bin目录下
./mysql -u root -p
13,修改密码(至此mysql安装完成)
修改密码
SET PASSWORD = PASSWORD('新密码');
%表示所有远程终端都可以登录,如果写单一个IP那只有这一个IP能登录
grant all privileges on *.* to 'root'@'%' identified by '密码';
FLUSH PRIVILEGES;
14,设置开机自启动
# 1,添加服务(此处mysql就是上面/etc/init.d/mysql)
chkconfig --add mysql
# 2,显示服务列表
chkconfig --list
# 3,如果看到mysql的服务,并且3,4,5都是on的话则成功,如果是off,则键入
chkconfig --level 345 mysql on
# 4,重启
reboot