# database

**Repository Path**: office_kenn/database

## Basic Information

- **Project Name**: database
- **Description**: mysql5.7,redis
- **Primary Language**: Unknown
- **License**: 0BSD
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-07-28
- **Last Updated**: 2024-01-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# mysql-boost-5.7.20


### 查看初始密码登陆mysql(这个日志中记录了初始密码)	
	cat /usr/local/mysql/log/error.log

        grant all privileges on *.* to proxy_driving@'%' identified by 'WrmS3KiGBnC3ptCw' with grant option;
        set global validate_password_policy=0;
        SHOW VARIABLES LIKE 'validate_password%';
        
### 设置密码
	mysql -uroot -p
	password：
	mysql> set password for root@localhost = PASSWORD('root');
	mysql> flush privileges;
### 添加权限
        mysql->grant all privileges on *.* to system@'%' identified by '2jd%73j1djDeK@j34' with grant option;
	mysql> flush privileges;

### 服务操作

	开机启动
	systemctl enable mysqld.service 

	systemctl start mysqld.service
	systemctl stop mysqld.service
	systemctl restart mysqld.service