centos 7 安装mysql
来源:互联网 发布:sql server 2017 64位 编辑:程序博客网 时间:2024/06/04 21:07
//安装mysql5姿势是要先安装带有可用的mysql5系列社区版资源的rpm包
rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
//mysql安装资源:
yum repolist enabled | grep “mysql.-community.”
//yum 安装
yum -y install mysql-community-server
//加入开机启动
systemctl enable mysqld
//启动mysql服务进程
systemctl start mysqld
//重置密码
mysql_secure_installation
//登录MYSQL(有ROOT权限)。这里我以ROOT身份登录
[root@iZ28gvqe4biZ ~]# mysql -u root -p
//修改访问权限,让其他计算机也能访问
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
usr mysql;
UPDATE user SET Password = password ( ‘123456’ ) WHERE User = ‘root’ ;
flush privileges ;
SHOW VARIABLES LIKE ‘character%’;
SET character_set_client = utf8 ;
SET character_set_connection = utf8 ;
SET character_set_database = utf8 ;
SET character_set_results = utf8 ;
SET character_set_server = utf8 ;
SET collation_connection = utf8 ;
SET collation_database = utf8 ;
SET collation_server = utf8 ;
SET NAMES ‘utf8’;
- centos 7安装mysql
- CentOS 7 安装MySQL
- centos 7安装mysql
- CentOS 7 安装mysql
- CentOS 7安装mysql
- CentOS 7安装MySQL
- CentOS 7 安装 MySQL
- CentOS 7安装MySQL
- CentOS 7 安装 MySQL
- centos 7 安装mySql
- CentOS 7安装Mysql
- centos 7安装mysql
- CentOS 7 安装 MySQL
- CentOS 7 安装Mysql
- CentOS 7 安装 MySQL
- CentOS 7 安装 MySQL
- centos 7 安装mysql
- CentOS 7安装mysql
- 安装树莓派系统
- 软件测试--报告软件缺陷的基本原则
- 求先序遍历中第k个结点的值
- centos 7 编译安装mysql5.7.20支持systemd及报错事项
- C++——构造函数
- centos 7 安装mysql
- HDU
- 欢迎使用CSDN-markdown编辑器
- 改变计算技术的9个伟大算法
- 乱码
- Log4j
- 06 C++中类、函数、成员模板基本用法(学自Boolean)
- 17.11.11-单例模式学习笔记
- C++内存分配20171111