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;