linux查看是否安装mysql_Linux下mysql的安装

1.查看Linux版本。

cat /etc/redhat-release

2.卸载系统原有的mariadb和MySQL。

yum检查否安装了mariadb和mysql

yum repolist enabled | grep “mysql.-community.“

yum repolist all | grep mysql

yum list installed | grep mariadb

删除

yum remove mysql mysql-server mysql-libs compat-mysqlxx(xx是版本号，例如：5.7就是57，8.0就是80)

rpm检查否安装了mariadb和mysql

rpm -qa | grep -i mariadb

rpm -qa|grep mysql

卸载

rpm -e MySQL-server-5.6.17-1.el6.i686

查询已安装的mysql相关软件包

rpm -qa | grep -i mysql

用rpm -e –nodeps 软件包名卸载上面列出的软件包

rpm -e –nodeps mysql-libs-version.x86_64

Red hat 7，Centos7

查询已安装的mariadb相关软件包

rpm -qa | grep -i mariadb

用rpm -e –nodeps 软件包名卸载上面列出的软件包

rpm -e –nodeps mariadb-libs-version.x86_64

检查文件，从根目录开始查找

find / -name mysql

删除查找出来的所有MySQL相关目录或者文件

3.下载rpm包

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.23-1.el7.x86_64.rpm

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.23-1.el7.x86_64.rpm

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.23-1.el7.x86_64.rpm

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.23-1.el7.x86_64.rpm

4.安装。

先安装common包，然后libs包，client，server。

rpm -ivh mysql-community-client-5.7.23-1.el7.x86_64.rpm

5.vim /etc/my.cnf 添加字符集支持中文

按i键使vim进入insert模式

[client]

default-character-set=utf8mb4

[mysqld]

character_set_server=utf8mb4

按esc使vim退出insert模式直接输入:wq保存并退出

6.初始化

mysqld –initialize

7.启动

systemctl start mysqld

查看运行状态

systemctl status mysqld.service

设置开机自动启动并查看是否设置成功：

[root@cs mysql]# systemctl enable mysqld

[root@cs mysql]# systemctl is-enabled mysqld

8.查看初始密码

为了加强安全性，MySQL5.7为root用户随机生成了一个密码

grep ‘temporary password’ /var/log/mysqld.log

9.登陆

mysql -uroot -p’<8o(1&qop:sM’

修改初始密码

ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘新密码’;

如果只是修改为一个简单的密码，你可能遇到ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

你需要：

set global validate_password_policy=0;

set global validate_password_length=4;

set PASSWORD = PASSWORD(‘123456’);

set global validate_password.policy=0;

set global validate_password.length=4;

ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘123456’;

mysql8.0修改了变量名称。

10.创建新用户

1.使用create user语句

CREATE USER ‘username‘@’host’ IDENTIFIED BY ‘password’;

● username：你将创建的用户名

● host：指定该用户在哪个主机上可以登陆，如果是本地用户可用localhost，如果想让该用户可以从任意远程主机登陆，可以使用通配符%

● password：该用户的登陆密码，密码可以为空，如果为空则该用户可以不需要密码登陆服务器

user表

INSERT INTO user

(host, user, password,

select_priv, insert_priv, update_priv)

VALUES (‘localhost’, ‘guest’,

PASSWORD(‘guest123’), ‘Y’, ‘Y’, ‘Y’);

11.创建新库

CREATE DATABASE 数据库名;

12.授权

grant 权限 on 数据库. to 用户名@登录主机 identified by “密码”;　

GRANT ALL PRIVILEGES ON .* TO ‘name‘@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;

FLUSH PRIVILEGES;

13.取消授权

REVOKE privilege ON databasename.tablename FROM ‘username‘@’host’;