跟平常的软件不太一样,不是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
登录测试
[root@VM_149_46_centos ~]# mysql -u root -p
使用新密码登录,没有问题
- 完成
参考链接
http://blog.csdn.net/holmofy/article/details/69364800
http://www.linuxidc.com/Linux/2016-09/134940.htm
https://dev.mysql.com/doc/refman/5.6/en/alter-user.html
https://zhidao.baidu.com/question/1704383715138160380.html