Linux系统中mysql安装

       1）.将mysql压缩包通过xftp移动至/root/temp下：    

       2）.在temp路径下解压mysql压缩包，命令为：cd /root/temp    和   tar zxvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz

[sunbing@localhost ~]$ su root
密码：
[root@localhost sunbing]# cd /root/temp
[root@localhost temp]# tar zxvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz 
mysql-5.7.27-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-5.7.27-linux-glibc2.12-x86_64/bin/myisamchk

       3）.将解压后的mysql文件夹复制到local的mysql文件下，命令为：mv mysql-5.7.27-linux-glibc2.12-x86_64 /usr/local/mysql

[root@localhost temp]# mv mysql-5.7.27-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost temp]# cd /usr/local
[root@localhost local]# ls
bin  games    jdk  lib64    mysql  sbin   src
etc  include  lib  libexec  redis  share  tomcat

       4）.创建用户组mysql和用户组的用户mysql,命令为：
               创建用户组mysql：groupadd mysql
               创建用户mysql：useradd -r -g mysql mysql
               useradd -r 创建用户，-g 将用户添加至用户组中

[root@localhost temp]# groupadd mysql
[root@localhost temp]# useradd -r -g mysql mysql

       5）.在mysql目录下进行当前目录和用户授权
               路径命令为：cd /usr/local/mysql
               当前目录授权命令为：chgrp -R mysql .   （注意最后的点前有空格）
               给用户授权命令为：chown -R mysql .   （注意最后的点前有空格）
               可通过ll命令进行查询授权结果

[root@localhost mysql]# cd /usr/local/mysql
[root@localhost mysql]# chgrp -R mysql .
[root@localhost mysql]# chown -R mysql .
[root@localhost mysql]# ll
总用量 36
drwxr-xr-x.  2 mysql mysql  4096 5月  21 21:11 bin
-rw-r--r--.  1 mysql mysql 17987 6月  10 2019 COPYING
drwxr-xr-x.  2 mysql mysql    55 5月  21 21:11 docs
drwxr-xr-x.  3 mysql mysql  4096 5月  21 21:10 include
drwxr-xr-x.  5 mysql mysql   230 5月  21 21:11 lib
drwxr-xr-x.  4 mysql mysql    30 5月  21 21:10 man
-rw-r--r--.  1 mysql mysql  2478 6月  10 2019 README
drwxr-xr-x. 28 mysql mysql  4096 5月  21 21:11 share
drwxr-xr-x.  2 mysql mysql    90 5月  21 21:11 support-files

       6）.进到bin目录下，进行初始化，并将最后一行的初始化密码复制并记录下来，用于密码的修改
               路径命令为：cd /usr/local/mysql/bin
               初始化命令为：./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US

       7）.添加软连接（即快捷方式）
               ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5
               ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5

[root@localhost bin]#  ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5
[root@localhost bin]# ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5
[root@localhost bin]# 

       8）.将启动文件复制到服务文件夹，启动mysql或设置开机自启动
               进到support-files文件中，路径命令为：cd /usr/local/mysql/support-files
               复制启动文件到服务文件夹，命令为：cp mysql.server /etc/init.d/mysql
               启动mysql，命令为：service mysql start

[root@localhost bin]# cd /usr/local/mysql/support-files
[root@localhost support-files]# cp mysql.server /etc/init.d/mysql
[root@localhost support-files]# service mysql start
Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'.
 SUCCESS! 
[root@localhost support-files]# 

               开机自启动，命令为：systemctl enable mysql

       9）.添加mysql软连接，添加环境变量，让环境变量生效：
               添加mysql软连接，命令为：ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
               添加环境变量，命令为：vim /etc/profile 加以下内容
export PATH=/usr/local/mysql/bin:$PATH
               让环境变量生效：source /etc/profile

[root@localhost support-files]# source /etc/profile
[root@localhost support-files]# 

       10）.登录mysql,修该密码为root,并进行授权，授权后刷新权限：
               登录mysql，命令为：mysql -u root -p 密码为之前记录的密码
               登陆后修改密码为root，命令为：set password=password(“root”);
               授权，命令为：GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;
               授权后权限刷新，命令为：flush privileges;

退出mysql：方法一：\q 回车
                    方法二：输入exit

mysql> exit
Bye
[root@localhost support-files]#