linux下安装mysql5.7
来源:互联网 发布:照片马赛克软件 编辑:程序博客网 时间:2024/06/05 15:12
1.连接外网动态ip使用命令 yum install -y mysql-server mysql mysql-deve
2.二进制文件安装
2.1 groupadd mysql 添加一个mysql组
2.2 useradd -r -g mysql mysql 添加一个用户
2.3 tar解压后再其目录下 mkdir data
2.4 mysql目录下 chown -R mysql:mysql .
2.5 bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
2.6 cp support-files/my-default.cnf /etc/my.cnf
2.7 vi /etc/my.cnf
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
2.8 service mysqld start 启动mysql
2.9 mysql -u root -p 输入给的随机码(若找不到,vi /etc/my.cnf 在mysqld下添加 skip-grant-tables)
2.10 修改密码 mysql5.7的密码字段为authentication_string update mysql.user set authentication_string=password('123456') where user='root' ;
2.11 flush privileges; 刷新权限 去掉 my.cnf下的skip-grant-tables 重启mysql
若当你登陆mysql之后你会发现,当你执行命令时会出现 ERROR1820 (HY000): You must reset your password using ALTER USER statement;
step 1: SET PASSWORD = PASSWORD('123456');
step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
step 3: flush privileges;
2.12 grant all privileges on *.* to root@'%' identified by '123456'; 默认不能远程登录
2.13 flush privileges;
- Linux下安装MySQL5.7
- Linux 下安装Mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装mysql5.7
- linux下安装MySQL5
- linux 下安装 Mysql5.7版本
- linux下安装php7+mysql5.7+nginx
- linux下安装php7+mysql5.7+nginx
- 【Mysql】Linux(Ubuntu)下安装Mysql5.7
- linux系统下Mysql5.7安装教程
- mysql5.7 linux下64位安装
- linux下安装MYSQL5.7一步完成
- PC-lint使用说明
- 【计算机网络】传输层协议TCP&TCP的3次握手4次挥手问题
- 汉诺塔问题
- hdu2112-HDU Today
- 关于某些数学相关结论
- linux下安装mysql5.7
- imageloader缓存机制
- mongo报错:Timed Out While Waiting For A Server That Matches AnyServerSelector{} After 10000 Ms解决
- POJ-2241 uva 437 The Tower of Babylon 记忆化搜索 DAG最长路
- LTE网元功能
- python unittest
- [Linux基础] 02、Linux的安装
- HDU 3949 XOR 线形基,异或消元,求一个数组的第k小异或和
- HDU 6011