欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

MySQL8.0.19安裝教程

 更新時(shí)間:2020年01月21日 09:50:31   作者:王2  
這篇文章主要介紹了MySQL8.0.19安裝教程,本文給大家介紹的非常詳細(xì),具有一定的參考借鑒價(jià)值,需要的朋友可以參考下

官網(wǎng)下載安裝包:mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz

安裝環(huán)境:CentOS Linux release 7.5.1804 (Core)

解壓安裝包:

xz -d mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz
tar -xvf mysql-8.0.19-linux-glibc2.12-x86_64.tar

環(huán)境變量:

yum install -y gcc gcc-c++ make cmake automake ncurses-devel bison bison-devel tcp_wrappers-devel libaio libaio-devel perl-Data-Dumper net-tools

創(chuàng)建相關(guān)用戶(hù)和組:

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -g mysql -d /home/mysql -m -p mysql mysql

創(chuàng)建相關(guān)目錄:

[root@localhost ~]# mkdir -p /data/mysql/;chown -R mysql.mysql /data/mysql/
[root@localhost ~]# mkdir -p /data/tmp/;chown -R mysql.mysql /data/tmp/

編輯配置文件:

[root@localhost tmp]# vim /etc/my.cnf
[root@localhost mysql]# cat /etc/my.cnf
[client]
port= 3306
socket = /tmp/mysql.sock
## The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
user = mysql
skip-external-locking
skip-name-resolve
#skip-grant-tables
#skip-networking
###################################### dir
basedir=/usr/local/mysql
datadir=/data/mysql
tmpdir=/data/tmp
secure_file_priv=/data/tmp
###################################### some app
log-error=mysql.err
pid-file=/data/mysql/mysql.pid
local-infile=1
event_scheduler=0
federated
default-storage-engine=InnoDB
#default-time-zone= '+8:00'
log_timestamps=SYSTEM
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
#fulltext
innodb_optimize_fulltext_only
ft_min_word_len=1
#ft_max_word_len
innodb_ft_min_token_size=1
###################################### memory allocate and myisam configure
max_connections=3000
max_connect_errors=10000
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 10240
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
join_buffer_size=2M
myisam_sort_buffer_size = 4M
#net_buffer_length = 2M
thread_cache_size = 24
tmp_table_size=1G
max_heap_table_size=1G
#thread_concurrency =48
###################################### replication
server-id = 101096
log-bin=mysql-bin
binlog_format=mixed
max_binlog_size=1G
log_slave_updates=true
log_bin_trust_function_creators=true
binlog_expire_logs_seconds=259200 #binlog過(guò)期時(shí)間,單位秒
replicate-ignore-db=mysql
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=test.%
replicate-wild-ignore-table=information_schema.%
replicate-wild-ignore-table=performance_schema.%
lower_case_table_names = 1
#read_only=1
master_info_repository=TABLE
relay_log_info_repository=TABLE
###################################### slow-query
long_query_time=1
slow_query_log=1
slow_query_log_file=/data/mysql/slow-query.log
interactive_timeout=600
wait_timeout=600
###################################### innodb configure
innodb_file_per_table
innodb_data_home_dir = /data/mysql
innodb_log_group_home_dir = /data/mysql
innodb_buffer_pool_size =4G
innodb_log_file_size = 1G
innodb_log_files_in_group = 3
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1
sync_binlog=0
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"
##########################################
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
default-character-set = utf8mb4
prompt=\\U \\h \\R:\\m:\\s \\d>
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

根目錄:

[root@localhost ~]# mv mysql-8.0.19-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost ~]# chown -R mysql.mysql /usr/local/mysql

進(jìn)行初始化,默認(rèn)密碼為空:

[root@localhost ~]# /usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/data/mysql/ --user=mysql

查看日志有沒(méi)有報(bào)錯(cuò):

[root@localhost ~]# cat /data/mysql/mysql.err
2020-01-20T15:11:46.156633+08:00 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.19) initializing of server in progress as process 14822
 100 200 300 400 500 600 700 800 900 1000
 100 200 300 400 500 600 700 800 900 1000
 100 200 300 400 500 600 700 800 900 1000
2020-01-20T15:12:31.118120+08:00 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

環(huán)境變量與開(kāi)機(jī)自啟:

[root@localhost mysql]# vim /etc/profile
#在最后添加
export MYSQL_HOME=/usr/local/mysql
PATH=$PATH:$MYSQL_HOME/bin/
[root@localhost mysql]# source /etc/profile
 [root@localhost mysql]# cd /usr/local/mysql
 [root@localhost mysql]# cp -f support-files/mysql.server /etc/init.d/mysqld

 [root@localhost mysql]# chmod 755 /etc/init.d/mysqld

 [root@localhost mysql]# chkconfig --add mysqld

 [root@localhost mysql]# chkconfig mysqld on

啟動(dòng)數(shù)據(jù)庫(kù):

[root@localhost mysql]# /etc/init.d/mysqld start

修改密碼與創(chuàng)建用戶(hù),8.0已取消grant權(quán)限自動(dòng)創(chuàng)建用戶(hù),要用create user創(chuàng)建用戶(hù)再用grant賦予權(quán)限:

[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
root@localhost localhost 15:43:29 (none)>ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)
root@localhost localhost 15:49:30 (none)>CREATE USER ceshi@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)

root@localhost localhost 15:50:07 (none)>grant SELECT on *.* to 'ceshi'@'localhost';
Query OK, 0 rows affected, 1 warning (0.00 sec)

root@localhost localhost 15:51:10 (none)>show grants for ceshi@localhost;
+--------------------------------------------+
| Grants for ceshi@localhost     |
+--------------------------------------------+
| GRANT SELECT ON *.* TO `ceshi`@`localhost` |
+--------------------------------------------+
1 row in set (0.00 sec)

ps:MySql8.0.19 安裝采坑記錄

1、ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解決方式如下:

mysql> ALTER USER USER() IDENTIFIED BY 'Xiaoming250';

2、修改root密碼

ALTER user 'root'@'localhost' IDENTIFIED BY '新密碼';

總結(jié)

以上所述是小編給大家介紹的MySQL8.0.19安裝教程,希望對(duì)大家有所幫助,如果大家有任何疑問(wèn)請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持!
如果你覺(jué)得本文對(duì)你有幫助,歡迎轉(zhuǎn)載,煩請(qǐng)注明出處,謝謝!

相關(guān)文章

  • 深入理解?MySQL?索引底層原理

    深入理解?MySQL?索引底層原理

    這篇文章主要介紹了深入理解?MySQL?索引底層原理的相關(guān)資料,需要的朋友可以參考下
    2022-12-12
  • MySql COALESCE函數(shù)使用方法代碼案例

    MySql COALESCE函數(shù)使用方法代碼案例

    這篇文章主要介紹了MySql COALESCE函數(shù)使用方法代碼案例,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下
    2020-08-08
  • SQL中distinct去重關(guān)鍵字使用和count統(tǒng)計(jì)組合使用方法

    SQL中distinct去重關(guān)鍵字使用和count統(tǒng)計(jì)組合使用方法

    這篇文章主要給大家介紹了關(guān)于SQL中distinct去重關(guān)鍵字使用和count統(tǒng)計(jì)組合使用的相關(guān)資料,count()是SQL中提供的用于統(tǒng)計(jì)記錄數(shù)量的函數(shù),需要的朋友可以參考下
    2024-08-08
  • processlist命令 查看mysql 線(xiàn)程

    processlist命令 查看mysql 線(xiàn)程

    processlist命令的輸出結(jié)果顯示了有哪些線(xiàn)程在運(yùn)行,可以幫助識(shí)別出有問(wèn)題的查詢(xún)語(yǔ)句,兩種方式使用這個(gè)命令。
    2009-04-04
  • mysql利用mysqlbinlog命令恢復(fù)誤刪除數(shù)據(jù)的實(shí)現(xiàn)

    mysql利用mysqlbinlog命令恢復(fù)誤刪除數(shù)據(jù)的實(shí)現(xiàn)

    這篇文章主要介紹了mysql利用mysqlbinlog命令恢復(fù)誤刪除數(shù)據(jù)的實(shí)現(xiàn),文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧
    2021-03-03
  • Mysql使用簡(jiǎn)單教程(三)

    Mysql使用簡(jiǎn)單教程(三)

    這篇文章主要介紹了Mysql使用簡(jiǎn)單教程(三) 的相關(guān)資料,需要的朋友可以參考下
    2016-05-05
  • mysql設(shè)置某字段不能重復(fù)問(wèn)題

    mysql設(shè)置某字段不能重復(fù)問(wèn)題

    這篇文章主要介紹了mysql設(shè)置某字段不能重復(fù)問(wèn)題,具有很好的參考價(jià)值,希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方,望不吝賜教
    2022-08-08
  • 詳解一條update語(yǔ)句是怎樣執(zhí)行原理解析

    詳解一條update語(yǔ)句是怎樣執(zhí)行原理解析

    這篇文章主要為大家介紹了詳解一條update語(yǔ)句是怎樣執(zhí)行原理解析,有需要的朋友可以借鑒參考下,希望能夠有所幫助,祝大家多多進(jìn)步,早日升職加薪
    2022-12-12
  • Mysql 數(shù)據(jù)庫(kù)雙機(jī)熱備的配置方法

    Mysql 數(shù)據(jù)庫(kù)雙機(jī)熱備的配置方法

    mysql數(shù)據(jù)庫(kù)沒(méi)有增量備份的機(jī)制,當(dāng)數(shù)據(jù)量太大的時(shí)候備份是一個(gè)很大的問(wèn)題。還好mysql數(shù)據(jù)庫(kù)提供了一種主從備份的機(jī)制,其實(shí)就是把主數(shù)據(jù)庫(kù)的所有的數(shù)據(jù)同時(shí)寫(xiě)到備份數(shù)據(jù)庫(kù)中。
    2010-06-06
  • mysql8.4版本mysql_native_password無(wú)法連接問(wèn)題解決

    mysql8.4版本mysql_native_password無(wú)法連接問(wèn)題解決

    用dbeaver可以直接連接,但是用NAVICAT連接后報(bào)錯(cuò),本文主要介紹了mysql8.4版本mysql_native_password無(wú)法連接問(wèn)題解決,具有一定的參考價(jià)值,感興趣的可以了解一下
    2024-07-07

最新評(píng)論