CentOS7安装配置MySQL

最新推荐文章于 2024-04-17 08:49:52 发布

莫弹弹

最新推荐文章于 2024-04-17 08:49:52 发布

阅读量337

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/qq_40233736/article/details/79259623

版权

跟平常的软件不太一样，不是rpm直接安装，而是先安装rpm得到yum源，然后用yum安装

下载rpm包

[root@VM_149_46_centos ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

安装rpm包

[root@VM_149_46_centos ~]# rpm -ivh mysql57-community-release-el7-11.noarch.rpm

yum 安装MySQL

[root@VM_149_46_centos ~]# yum install mysql-server

测试MySql

[root@VM_149_46_centos ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

这里出错的原因是/var/lib/mysql的访问权限问题

[root@VM_149_46_centos ~]# sudo chown -R root:root /var/lib/mysql
[root@VM_149_46_centos ~]# service mysqld restart
Redirecting to /bin/systemctl restart  mysqld.service

这样就把文件权限改好了，并且重启了mysql服务

配置登录密码和Mysql端口

[root@VM_149_46_centos ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

这个错是密码错误了,查找一下默认生成的随机密码

[root@VM_149_46_centos ~]# grep 'temporary password' /var/log/mysqld.log
2018-02-05T05:50:32.354328Z 1 [Note] A temporary password is generated for root@localhost: :Fda,R:=u0q)

:Fda,R:=u0q)就是默认生成的密码
使用登录命令并输入密码

[root@VM_149_46_centos ~]# mysql -u root -p

修改默认密码：

mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

在 /etc/my.cnf文件里加上 port=6666 把mysql的默认端口号从3306改为6666

[root@VM_149_46_centos ~]# vim /etc/my.cnf

# For advice on how to change settings please see


# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html


[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data


# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.


# innodb_buffer_pool_size = 128M

#

# Remove leading # to turn on a very important data integrity option: logging


# changes to the binary log between backups.


# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.


# The server defaults are faster for transactions and fast SELECTs.


# Adjust sizes as needed, experiment to find the optimal values.


# join_buffer_size = 128M


# sort_buffer_size = 2M


# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock


# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

port=6666