MySQL5.7在CentOS7上的安装配置

安装源文件：mysql-5.7.18-linux-glibc2.5-x86_64.tar

创建用户组及用户

groupadd mysql

useradd -r -g mysql -s /bin/false mysql

useradd命令使用- r和s /bin/false选项来创建一个用户没有登录权限的服务器主机

解压

tar -zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

编辑配置文件，配置环境变量

vim /etc/profile

PATH=$PATH:/home/data/mysql/bin
export PATH JAVA_HOME CLASSPATH

执行命令source /etc/profile使配置立即生效.

修改权限

chown -R mysql:mysql mysql

数据库初始化

./mysqld --initialize --user=mysql --basedir=/home/data/mysql --datadir=/home/data/mysql/data

初始化后会生成root用户的临时密码：

修改/etc/my.cnf

与上面的设置一致

设置启动和配置文件

cp support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

设置开机自启

我们在使用mysql数据库时，都得首先启动mysqld服务，我们可以通过 chkconfig list | grep mysqld 命令来查看mysql服务是不是开机自动启动，如果发现mysqld服务并没有开机自动启动，我们当然可以通过 chkconfig mysqld on 命令来将其设置成开机启动，这样就不用每次都去手动启动了

启动数据库

service mysqld start

使用临时密码登录，然后修改密码

[root@ip-172-31-43-136 bin]# mysql -uroot -p
Enter password:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'XXXX';
Query OK, 0 rows affected (0.00 sec)

密码忘记情况下修改密码

service mysqld start --skip-grant-tables --skip-networking

update user set authentication_string = password('Lp860606'), password_expired = 'N', password_last_changed = now() where user = 'root';

问题1

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

建立软连接：ln -s /home/xmdb/mysqldata/mysql.sock /tmp/mysql.sock

问题2

You must reset your password using ALTER USER statement before executing this statement

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Xmdb@123' PASSWORD EXPIRE NEVER;

问题3

[root@ip-172-31-33-90 bin]# ./mysqld --initialize --user=mysql --basedir=/home/centos/mysql --datadir=/home/centos/mysql/data
./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

64位系统安装：

wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm

32位系统现在很少了，yum似乎默认安装32位的：

yum install libaio.so.1

问题4

[root@ip-172-31-33-90 bin]# ./mysqld --initialize --user=mysql --basedir=/home/centos/mysql --datadir=/home/centos/mysql/data
2019-06-10T03:23:15.849817Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-06-10T03:23:16.670139Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-06-10T03:23:16.907547Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-06-10T03:23:16.970684Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 168f06e6-8b2f-11e9-b6b5-0a19dc8a3de8.
2019-06-10T03:23:16.972066Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-06-10T03:23:16.972556Z 1 [Note] A temporary password is generated for root@localhost: a3RmMNnz:FoI
2019-06-10T03:23:16.974809Z 1 [ERROR] 1  Can't create/write to file '/home/centos/mysql/data/mysql/db.MYI' (Errcode: 13 - Permission denied)
2019-06-10T03:23:16.974876Z 0 [ERROR] Aborting

2019-06-10T03:23:17.075454Z 0 [ERROR] InnoDB: Cannot open '/home/centos/mysql/data/ib_buffer_pool.incomplete' for writing: Permission denied

修改mysql解压目录的上级或上上级的权限。

最后编辑于：2020.04.24 14:58:39