mysql8.0二进制安装

mysql8.0二进制安装
1.创建目录授权
groupadd mysql
useradd mysql
mkdir 开发云主机域名-p /usr/local/mysql/
mkdir -p /usr/local/mysql/data
mkdir -p /usr/local/mysql/etc
mkdir -p /usr/local/mysql/log
chown -R mysql:mysql /usr/local/mysql/

2.配置参数文件：
cat > /usr/local/mysql/etc/my.cnf [client]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
[mysqld]
server-id = 1
port = 3306
mysqlx_port = 33060
mysqlx_socket = /usr/local/mysql/data/mysqlx.sock
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/data/mysql.sock
pid-file = /usr/local/mysql/data/mysqld.pid
log-error = error.log
slow-query-log = 1
slow-query-log-file = slow.log
long_query_time = 0.2
log-bin = bin.log
relay-log = relay.log
binlog_format =ROW
relay_log_recovery = 1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect =’SET NAMES utf8mb4′
innodb_buffer_pool_size = 1G
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
log_timestamps = SYSTEM
lower_case_table_names = 1
default-authentication-plugin =mysql_native_password
EOF

注意配置
[client]
socket = /usr/local/mysql/data/mysql.sock

[mysqld]
socket = /usr/local/mysql/data/mysql.sock

3.初始化数据库
/usr/local/mysql/bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/data/mysql
cat /usr/local/mysql/data/error.log | grep -i password

4.设置启动文件和环境变量：
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
systemctl start mysql

5、配置用户和密码
mysql> show variables like ‘%valid%pass%’;
mysql> create user root@’%’ identified by ‘abc123’;
mysql> show variables like ‘%valid%pass%’;
mysql> alter user root@’localhost’ identified by ‘abc123’;
mysql> show variables like ‘%valid%pass%’;

–创建可以远程登录的用户：
mysql> create user root@’%’ identified by ‘abc123’;
mysql> grant all privileges on *.* to root@’%’ with grant option;
mysql> flush privileges;

# 创建账号密码
CREATE USER `root`@`127.0.0.1` IDENTIFIED BY ‘shsnc!@#’;
CREATE USER `root`@`%` IDENTIFIED BY ‘shsnc!@#’;

# 授予权限
GRANT ALL ON *.* TO `root`@`%` WITH GRANT OPTION;

# 删除权限
REVOKE all privileges ON databasename.tablename FROM ‘username’@’host’;

# 修改密码
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’;

mysql8修改密码
清空密码
UPDATE user SET Password = PASSWORD(‘shsnc!@#’) WHERE user = ‘root’;
FLUSH privileges;

修改密码（注意不能直接改表)
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY “shsnc!@#”;
FLUSH privileges;

相关推荐: mysql concat 用法

多个字开发云主机域名段拼接成一个字段进行查询SELECT CONCAT(area.name, house.block, ‘栋’, house.unit, ‘单元’, house.room_number, ‘室’, room.apart_name) AS nam…