In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.