CentOS安装运用二进制方式mysql5.6笔记
发布时间：2022-03-31 19:29:17 所属栏目：MySql教程 来源：互联网
导读：CentOS安装使用二进制方式mysql5.6笔记 1、上传安装包--使用root用户 2、解压安装包--使用root用户 cd /usr/local/ tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql 3、创建mysql管理用户组与用户--使用ro
|
CentOS安装使用二进制方式mysql5.6笔记 1、上传安装包--使用root用户 2、解压安装包--使用root用户 cd /usr/local/ tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql 3、创建mysql管理用户组与用户--使用root用户 groupadd -g 101 dba useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin 验证：id mysqladmin 4、修改mysqladmin用户密码--使用root用户 passwd mysqladmin 提示： Changing password for user mysqladmin. New UNIX password: BAD PASSWORD: it is too simplistic/systematic Retype new UNIX password: passwd: all authentication tokens updated successfully. 5、copy 环境变量配置文件至mysqladmin用户的home目录中,为了以下步骤配置个人环境变量--使用root用户 cp /etc/skel/.* /usr/local/mysql 提示： cp: omitting directory `/etc/skel/.' cp: omitting directory `/etc/skel/..' cp: omitting directory `/etc/skel/.mozilla' 6、修改/etc/my.cnf文件，并删除原文件内容，将以下内容填写到my.cnf文件中--使用root用户 vi /etc/my.cnf [client] port = 3306 socket = /usr/local/mysql/data/mysql.sock [mysqld] port = 3306 socket = /usr/local/mysql/data/mysql.sock skip-external-locking key_buffer_size = 256M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M query_cache_size= 32M max_allowed_packet = 16M myisam_sort_buffer_size=128M tmp_table_size=32M table_open_cache = 512 thread_cache_size = 8 wait_timeout = 86400 interactive_timeout = 86400 max_connections = 600 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 32 #isolation level and default engine default-storage-engine = INNODB transaction-isolation = READ-COMMITTED server-id = 1 basedir = /usr/local/mysql datadir = /usr/local/mysql/data pid-file = /usr/local/mysql/data/hostname.pid #open performance schema log-warnings sysdate-is-now binlog_format = MIXED log_bin_trust_function_creators=1 log-error = /usr/local/mysql/data/hostname.err log-bin=/usr/local/mysql/arch/mysql-bin #other logs #general_log =1 #general_log_file = /usr/local/mysql/data/general_log.err #slow_query_log=1 #slow_query_log_file=/usr/local/mysql/data/slow_log.err #for replication slave #log-slave-updates #sync_binlog = 1 #for innodb options innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:500M:autoextend innodb_log_group_home_dir = /usr/local/mysql/arch innodb_log_files_in_group = 2 innodb_log_file_size = 200M innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 50M innodb_log_buffer_size = 16M innodb_lock_wait_timeout = 100 #innodb_thread_concurrency = 0 innodb_flush_log_at_trx_commit = 1 innodb_locks_unsafe_for_binlog=1 #innodb io features: add for mysql5.5.8 performance_schema innodb_read_io_threads=4 innodb-write-io-threads=4 innodb-io-capacity=200 #purge threads change default(0) to 1 for purge innodb_purge_threads=1 innodb_use_native_aio=on #case-sensitive file names and separate tablespace innodb_file_per_table = 1 lower_case_table_names=1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [mysqlhotcopy] interactive-timeout [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M 7、修改/etc/my.cnf文件用户组与用户、权限--使用root用户 cd /usr/local chown mysqladmin:dba /etc/my.cnf chmod 640 /etc/my.cnf 验证： ll my.cnf -rw-r----- 1 mysqladmin dba 2201 Dec 19 11:19:40 my.cnf 8、修改mysql安装文件用户组与用户、权限--使用root用户 chown -R mysqladmin:dba /usr/local/mysql chmod -R 755 /usr/local/mysql su - mysqladmin pwd显示：/usr/local/mysql 9、创建arch目录--使用mysqladmin用户 cd /usr/local/mysql mkdir arch 10、检查gcc、libaio、perl以及perl-devel包是否安装 rpm -qa|grep gcc libaio perl perl-devel 如未安装，则使用yum方式安装：yum -y install libaio、yum -y install gcc、yum -y install perl 11、二进制安装 scripts/mysql_install_db --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 提示： Installing MySQL system tables...2017-12-19 11:39:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). OK Filling help tables...2017-12-19 11:39:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h sht-sgmhadoopnn-01 password 'new-password' Alternatively you can run: ./bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com New default config file was created as ./my.cnf and will be used by default by the server when you start it. You may edit this file to change server settings WARNING: Default config file /etc/my.cnf exists on the system This file will be read by default by the MySQL server If you do not want to use this, either remove it, or use the --defaults-file argument to mysqld_safe when starting the server 12、启动mysql--使用mysqladmin用户 su - mysqladmin cd /usr/local/mysql rm -rf my.cnf bin/mysqld_safe & 验证是否启动：ps -ef|grep mysqld、netstat -tulnp | grep mysql 13、登录mysql，并修改mysql中的root密码内容--使用mysqladmin用户 mysql mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 注：如mysql数据库名称，则退出(exit)使用：mysql -uroot -p，提示输入密码时直接回车 mysql> use mysql mysql> update user set password=password('123456') where user='root'; mysql> select host,user,password from user; mysql> delete from user where user=''; mysql> select host,user,password from user; mysql> flush privileges; 若泽大数据交流群：671914634 （编辑：财气旺网 - 财气网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐