centos下MySQL详细安装

1、检查是否已经安装过mysql，执行命令

[root@localhost /]# rpm -qa | grep mysql

mysql-libs-5.1.73-5.el6_6.x86_64

[root@localhost /]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64

[root@localhost /]# rpm -qa | grep mysql

2、查询所有Mysql对应的文件夹

[root@localhost /]# whereis mysql

mysql: /usr/bin/mysql /usr/include/mysql

[root@localhost lib]# find / -name mysql

/data/mysql

/data/mysql/mysql

删除相关文件

[root@localhost /]# rm -rf /usr/bin/mysql /usr/include/mysql /data/mysql /data/mysql/mysql

验证是否删除完毕

[root@localhost /]# whereis mysql

mysql:

[root@localhost /]# find / -name mysql

[root@localhost /]#

3、检查mysql用户组和用户是否存在，如果没有，则创建

[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

命令下载

[root@localhost /]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

[root@localhost /]# tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

[root@localhost /]# mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql

[root@localhost /]# cp -r mysql /usr/local/

在/usr/local/mysql目录下创建data目录

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

更改mysql目录下所有所属的用户组和用户，以及权限

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

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

编译安装并初始化mysql，初始化输出日志末尾为临时登录密码

[root@localhost /]# cd /usr/local/mysql/bin

[root@localhost bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

2021-01-19T08:36:17.480885Z 1 [Note] A temporary password is generated for root@localhost: rul9KzT7g_kr

6、编辑配置文件my.cnf

[root@localhost /]# vim /etc/my.cnf

[mysqld]

datadir=/usr/local/mysql/data

port = 3306

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

symbolic-links=0

max_connections=400

innodb_file_per_table=1

#表名大小写不明感，敏感为

lower_case_table_names=1

启动服务器,设置软链接

[root@localhost bin]# mysql -u root -p

-bash: mysql: command not found

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

Starting MySQL SUCCESS!

[root@localhost bin]# 2020-06-16T07:21:48.372671Z mysqld_safe A mysqld process already exists

^C

[root@localhost bin]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

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

[root@localhost bin]# service mysql restart

Shutting down MySQL… SUCCESS!

Starting MySQL. SUCCESS!

登录mysql，修改密码(密码为步骤4生成的临时密码)

[root@localhost /]# mysql -u root -p

Enter password:

mysql>set password for root@localhost = password(‘mypass’);

开放远程连接

mysql>use mysql;

msyql>update user set user.Host=’%’ where user.User=‘root’;

mysql>flush privileges;

创建表

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
±-------------------+
4 rows in set (0.00 sec)

设置开机自动启动

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit;

Bye

1、将服务文件拷贝到init.d下，并重命名为mysql

[root@localhost bin]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

2、赋予可执行权限

[root@localhost bin]# chmod +x /etc/init.d/mysqld

3、添加服务

[root@localhost bin]# chkconfig --add mysqld

4、显示服务列表

[root@localhost bin]# chkconfig --list

[root@localhost bin]# mysql -u root -p