Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Sample Analysis of MySQL8.0.19 installation

2025-01-22 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "sample analysis of MySQL8.0.19 installation", which is easy to understand and well-organized. I hope it can help you solve your doubts. Let the editor lead you to study and learn the article "sample Analysis of MySQL8.0.19 installation".

Download the installation package on the official website: mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz

Installation environment: CentOS Linux release 7.5.1804 (Core)

Extract the installation package:

Xz-d mysql-8.0.19-linux-glibc2.12-x86_64.tar.xztar-xvf mysql-8.0.19-linux-glibc2.12-x86_64.tar

Environment variables:

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

Create related users and groups:

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

Create related directories:

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

Edit the configuration file:

[root@localhost tmp] # vim / etc/my.cnf [root@localhost mysql] # cat / etc/ my.cnf [client] port= 3306socket = / tmp/mysql.sock## The MySQL server [mysqld] port= 3306socket = / tmp/mysql.sockuser = mysqlskip-external-lockingskip-name-resolve#skip-grant-tables#skip-networking## dirbasedir=/usr/ Local/mysqldatadir=/data/mysqltmpdir=/data/tmpsecure_file_priv=/data/tmp## some applog-error=mysql.errpid-file=/data/mysql/mysql.pidlocal-infile=1event_scheduler=0federateddefault-storage-engine=InnoDB#default-time-zone='+ 8:00'log_timestamps=SYSTEMcharacter-set-client-handshake = FALSEcharacter-set-server = utf8mb4collation-server = utf8mb4_unicode_ciinit_connect=' SET NAMES utf8mb4'#fulltextinnodb_optimize_fulltext_onlyft_min_word_len=1#ft_max_word_leninnodb_ft_min_token_size=1## memory allocate and myisam configuremax_connections=3000max_connect_errors=10000key_buffer_size = 16Mmax_allowed_packet = 16Mtable_open_cache = 10240sort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size = 2Mjoin_buffer_size=2Mmyisam_sort_buffer_size = 4M#net_buffer_length = 2Mthread_cache_size = 24tmp_table_size=1Gmax_heap_table_size=1G#thread_concurrency = 48 years # replicationserver-id = 101096log-bin=mysql-binbinlog_format=mixedmax_binlog_size=1Glog_slave_updates=truelog_bin_trust_function_creators=truebinlog_expire_logs_seconds=259200 # binlog expiration time Unit second replicate-ignore-db=mysqlreplicate-ignore-db=testreplicate-ignore-db=information_schemareplicate-ignore-db=performance_schemareplicate-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=1master_info_repository=TABLErelay_log_info_repository=TABLE## # slow-querylong_query_time=1slow_query_log=1slow_query_log_file=/data/mysql/slow-query.loginteractive_timeout=600wait_timeout=600## innodb configureinnodb_file_per_tableinnodb_data_home_dir = / data/mysqlinnodb_log_group_home_dir = / data/mysqlinnodb_buffer_pool_size = 4Ginnodb_log_file_size = 1Ginnodb _ log_files_in_group = 3innodb_log_buffer_size = 32Minnodb_flush_log_at_trx_commit = 1syncquestions binlogically 0sqlmurmode= "STRICT_TRANS_TABLES" NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO "# # [mysqldump] quickmax_allowed_packet = 16m [MySQL] no-auto-rehashdefault-character-set = utf8mb4prompt=\\ U\\ h\ R:\\ m:\\ s\\ d > [myisamchk] key_buffer_size = 20Msort_buffer_size = 2Mwrite_buffer = 2m [mysqlhotcopy] interactive-timeout

Root directory:

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

Initialize. The default password is empty:

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

Check the log to see if there is any error:

[root@localhost] # cat / data/mysql/mysql.err2020-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 1000 100 200 300 500 600 700 800 1000 100 200 400 500 600 700 900 10002020-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.

Environment variables and self-boot:

[root@localhost mysql] # vim / etc/profile# add export MYSQL_HOME=/usr/local/mysqlPATH=$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

Start the database:

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

Change the password and create a user. 8.0 has revoked the grant permission to automatically create a user. To create a user with create user, use grant to grant permissions:

[root@localhost] # mysql-uroot-pEnter password:Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 8Server version: 8.0.19 MySQL Community Server-GPLCopyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.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 installation pit record

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

The solution is as follows:

Mysql > ALTER USER USER () IDENTIFIED BY 'Xiaoming250'

2. Modify the root password

ALTER user 'root'@'localhost' IDENTIFIED BY' New password; the above is all the content of the article "sample Analysis of MySQL8.0.19 installation". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report