mysql在linux系统安装

作者:神秘网友 发布时间:2020-09-09 12:16:31

mysql在linux系统安装

mysql在linux系统安装

1.下载:https://dev.mysql.com/downloads/repo/yum

 mysql在linux系统安装

mysql在linux系统安装

2.安装https://jingyan.baidu.com/article/6525d4b1704f52ac7d2e94c1.html 

拖到linux系统:安装顺序 common>libs>client>server>devel

mysql在linux系统安装

按着这个上面步骤走:https://www.cnblogs.com/lemon-feng/p/11233227.html

3.安装时如果没以下的报错可以直接忽略这一步:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

密码设置错误时:https://www.jianshu.com/p/804cd2d2cdbf   用方案二

设置成功:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.02 sec)

use mysql

select *from user;
mysql> update user set
    -> `Select_priv` = 'Y',
    -> `Insert_priv` = 'Y',
    -> `Update_priv` = 'Y',
    -> `Delete_priv` = 'Y',
    -> `Create_priv` = 'Y',
    -> `Drop_priv` = 'Y',
    -> `Reload_priv` = 'Y',
    -> `Shutdown_priv` = 'Y',
    -> `Process_priv` = 'Y',
    -> `File_priv` = 'Y',
    -> `Grant_priv` = 'Y',
    -> `References_priv` = 'Y',
    -> `Index_priv` = 'Y',
    -> `Alter_priv` = 'Y',
    -> `Show_db_priv` = 'Y',
    -> `Super_priv` = 'Y',
    -> `Create_tmp_table_priv` = 'Y',
    -> `Lock_tables_priv` = 'Y',
    -> `Execute_priv` = 'Y',
    -> `Repl_slave_priv` = 'Y',
    -> `Repl_client_priv` = 'Y',
    -> `Create_view_priv` = 'Y',
    -> `Show_view_priv` = 'Y',
    -> `Create_routine_priv` = 'Y',
    -> `Alter_routine_priv` = 'Y',
    -> `Create_user_priv` = 'Y',
    -> `Event_priv` = 'Y',
    -> `Trigger_priv` = 'Y',
    -> `Create_tablespace_priv` = 'Y'
    -> where user='root' and host='%';

 


flush privileges;

Delete FROM user Where User='root' and Host='%';

select user,host from user;

改用户名为root1,密码为123456

create user 'root1'@'%' identified with mysql_native_password by '123456';

 grant all privileges on *.* to 'root1'@'%' with grant option;

flush privileges;

exit;

mysql -uroot -p

123456

show databases;

 

 mysql在linux系统安装

mysql在linux系统安装

 mysql在linux系统安装

 mysql在linux系统安装

 mysql在linux系统安装

 mysql在linux系统安装

4.Navicate:

mysql在linux系统安装

 

mysql在linux系统安装相关教程

  1. 火影推荐程序连载25-高并发系统的分析和设计
  2. Linux升级内核以及删除Linux多余的内核
  3. linux环境下搭建jenkins+sonarqube+sonarscanner,一键完成构建
  4. 儿童体验馆室内人员定位管理系统儿童安全得到保障-新导智能
  5. Android学习--ContentProvider之读取系统联系人
  6. 水利RTU助力生态流量监测系统
  7. linux系统:ptrace系统调用浅析
  8. WIN10安装MYSQL教程