Linux下Mysql的安装

mysql基本操作

安装服务端

yum install mysql-conmmunity-server

启动mysql

service mysqld start  /   restart

停止mysql

service mysqld stop

 

mysql安装

CentOS7默认安装的mariadb数据库

1.卸载mariadb数据库

yum remove mariadb-lib.x86_64

执行命令后仍无法卸载时，先重新连接LINUX再查是否启动看ps -aux|grep mariadb

如果还再 强制卸载

rpm -e –nodeps mariadb-libs-5.5.37-1.el7_0.x86_64

2. 下载mysql源

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

3.安装源

yum localinstall mysql57-community-release-el7-11.noarch.rpm

4.安装mysql

yum install mysql-community-server

5.查看默认密码

cat /var/log/mysqld.log | grep "password"

6.查看mysql进程，确认mysql开启运行

ps -ef | grep mysql

注意

由于初次安装mysql数据库会出现错误提示ERROR 1820 (HY000):

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

输入以下命令，改变密码设置的参数

set global validate_password_policy=0;

set global validate_password_length=1;

//123456 是重置的新密码

 

/var/log/mysqld.log 中找不到临时密码

https://blog.csdn.net/pao___pao/article/details/80118904

 

报错：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement

alter user user() identified by "123456";

 

创建mysql用户

1.改变密码设置的参数

set global validate_password_policy=0;

set global validate_password_length=1;

2.创建mysql用户

create user 'imooc'@'%'  identified by '123456';

3.赋予所有权限  (注意mysql用户名和密码可更换)

grant all privileges on *.* to 'imooc'@'%' identified by '123456' with grant option;

赋予增删改查权限

grant select,insert,update,delete on *.* to 'imooc'@'%' identified by '123456' with grant option;

4.刷新权限

flush privileges;