linux 安装 mysql rpm 安装
一、rpm 安装包下载
mysql官网下载路径 MySQL :: MySQL Community Downloadshttps://dev.mysql.com/downloads/
二、安装前的工作
rpm -e --nodeps mysql-libs-5.1.73-1.el6.x86_64
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
(4)检查依赖 是否存在 libaio库 和 net-tools库
三、rpm安装mysql
yum install -y net-tools perl libaio openssl gcc pcre-devel zlib-devel openssl vim openssl-devel
cd /usr/local/mysql/
rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
# mysql-community-server强行执行命令
rpm -ivh 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm --force --nodeps
四、初次启动MySQL
#启动mysql
service mysqld start
#查看mysql状态
service mysqld status
#关闭mysql
service mysqld stop
#重启mysql
service mysqld restart
netstat -tunlp | grep mysql 查看mysql的服务信息
(3)首次登陆通过 “mysql -uroot -p”密码是
cat /var/log/mysqld.log | tail -n 10
或者sudo grep 'temporary password' /var/log/mysqld.log
(5)数据库和服务端的默认字符都是latin1,如果不修改容易出现乱码
#进入 my.cnf
vim /etc/my.cnf
#添加 下面的配置
character_set_server=utf8
init_connect=’SET NAMES utf8’
#重启mysql
service mysqld restart
#查看远程访问的状态
select host,user,authentication_string from mysql.user
# host 为 localhost 则该用户 无法进行远程访问
#修改 权限
update mysql.user set host="%" where user="root";
#添加 root 的权限
grant all privileges on *.* to root@'%' identified by 'root'#远程登录密码;
#刷新
flush privileges;