/
搜索到
6
篇与
的结果
-
MySQL 8.0.35源码编译安装 二、MySQL 8.0.35源码编译安装可用于部署泛微OA Ecology9OS: Rocky Linux 9.1DB: mysql-boost-8.0.35.tar.gz2.0 安装 epel源dnf install epel-release -y2.1 编辑rocky-devel.repo源默认enabled=0 把它改为1 ，否则搜索不到如：libtirpc-devel 软件包# rocky-devel.repo [devel] name=Rocky Linux $releasever - Devel WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/$basearch/os/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9 [devel-source] name=Rocky Linux $releasever - Devel Source WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever-source$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/source/tree/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-92.2安装依赖dnf install ncurses ncurses-devel libtirpc libtirpc-devel rpcgen gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc2.3 编译MySQLcmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DSYSCONFDIR=/usr/local/mysql/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8mb4 \ -DDEFAULT_COLLATION=utf8mb4_general_ci \ -DWITH_EMBEDDED_SERVER=1 \ -DENABLED_LOCAL_INFILE=1 \ -DFORCE_INSOURCE_BUILD=1 \ -DWITH_BOOST=/opt/soft/mysql-8.0.35/boostmake && make install2.4 创建MySQL用户组groupadd mysql useradd -r -g mysql -s /sbin/nologin mysql2.5 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/2.6 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M default_authentication_plugin=mysql_native_password open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid2.7 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-30T10:13:40.227290Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-30T10:13:40.640989Z 1 [Note] A temporary password is generated for root@localhost: FwIai&pq*3v3 #临时密码2.8 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh2.9 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld2.10 登录MySQL 使用临时密码mysql -uroot -pFwIai&pq*3v32.11 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #NAVER永不过期 # 使用WITH mysql_native_password加密 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER; #刷新授权表 flush privileges;2.12 创建ecology数据库CREATE DATABASE ecology; CREATE USER ecology IDENTIFIED WITH mysql_native_password BY 'ecology123'; GRANT ALL PRIVILEGES ON ecology.* to 'ecology'@'%'; FLUSH PRIVILEGES; -
MySQL 8.0.35 二进制包安装 一、MySQL 8.0.35 二进制包安装可用于部署泛微OA Ecology9.0OS: Rocky Linux 9.1Database: mysql-8.0.35-linux-glibc2.28-x86_64.tar.xzQQ: 22193771351.0 解压缩tar xf mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz1.1 创建软链接ln -sf /usr/localmysql-8.0.35-linux-glibc2.28-x86_64/ /usr/localmysql1.2 创建MySQL用户组group add mysql useradd -r -g mysql -s /sbin/nologin mysql1.3 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/1.4 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M default_authentication_plugin=mysql_native_password open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid1.5 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-15T11:16:44.157258Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-01-15T11:16:50.486157Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-01-15T11:16:55.164521Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: :F&gdX?GQ6ip #临时密码1.6 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh1.7 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld1.8 登录MySQL 使用临时密码mysql -uroot -p:F&gdX?GQ6ip1.9 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; # 使用WITH mysql_native_password加密 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER; #刷新授权表 flush privileges;1.10 创建ecology数据库CREATE DATABASE ecology; CREATE USER ecology IDENTIFIED WITH mysql_native_password BY 'ecology123'; GRANT ALL PRIVILEGES ON ecology.* to 'ecology'@'%'; FLUSH PRIVILEGES;
-
MySQL 5.7.44源码编译安装 二、MySQL 5.7.44源码编译安装可用于部署泛微Ecology9.0OS: Rocky Linux 9.1DB: mysql-boost-5.7.44.tar.gz2.0 安装 epel源dnf install epel-release -y2.1 编辑rocky-devel.repo源默认enabled=0 把它改为1 ，否则搜索不到如：libtirpc-devel 软件包# rocky-devel.repo [devel] name=Rocky Linux $releasever - Devel WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/$basearch/os/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9 [devel-source] name=Rocky Linux $releasever - Devel Source WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever-source$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/source/tree/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-92.2安装依赖dnf install ncurses ncurses-devel libtirpc libtirpc-devel rpcgen2.3 编译MySQLcmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DSYSCONFDIR=/usr/local/mysql/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8mb4 \ -DDEFAULT_COLLATION=utf8mb4_general_ci \ -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 \ -DWITH_BOOST=/opt/soft/mysql-5.7.44/boostmake && make install2.4 创建MySQL用户组groupadd mysql useradd -r -g mysql -s /sbin/nologin mysql2.5 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/2.6 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid2.7 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-30T10:13:40.227290Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-30T10:13:40.640989Z 1 [Note] A temporary password is generated for root@localhost: FwIai&pq*3v3 #临时密码2.8 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh2.9 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld2.10 登录MySQL 使用临时密码mysql -uroot -pFwIai&pq*3v32.11 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aa123456' PASSWORD EXPIRE NEVER; #NAVER永不过期 #刷新授权表 flush privileges;2.12 创建ecology数据库CREATE DATABASE ecology; GRANT ALL ON ecology.* to 'ecology'@‘localhost' IDENTIFIED BY 'ecology123'; FLUSH PRIVILEGES;
-
MySQL 5.7.44 二进制包安装 一、MySQL 5.7.44 二进制包安装可用于部署泛微Ecology9.0OS: Rocky Linux 9.1Database: mysql-5.7.44-linux-glibc2.12-x86_64.tar.gzQQ: 22193771351.0 解压缩tar zxf mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz1.1 创建软链接ln -sf /usr/local/mysql-5.7.44-linux-glibc2.12-x86_64/ /usr/localmysql1.2 创建MySQL用户组groupadd mysql useradd -r -g mysql -s /sbin/nologin mysql1.3 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/1.4 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] # The following password will be sent to all standard MySQL clients password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid1.5 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-15T11:16:44.157258Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-01-15T11:16:50.486157Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-01-15T11:16:55.164521Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: qyNLr69t%fo* #临时密码1.6 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh1.7 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld1.8 登录MySQL 使用临时密码mysql -uroot -pqyNLr69t%fo*1.9 登录MySQL报错：mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory # 解决方法： find / -name 'libncurses*' cd /usr/lib64 ln -sf libncurses.so.6.2 libncurses.so.5 ln -sf libtinfo.so.6.2 libtinfo.so.51.10 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #NAVER永不过期 #刷新授权表 flush privileges;1.10 创建ecology数据库CREATE DATABASE ecology; CREATE USER ecology IDENTIFIED WITH mysql_native_password BY 'ecology123'; GRANT ALL PRIVILEGES ON ecology.* to 'ecology'@'%'; FLUSH PRIVILEGES;
-
MySQL - SHOW语句 SHOW 语句MySQL [(none)]> HELP SHOW;一. SHOW {BINARY | MASTER} LOGS 列出二进制列表MySQL [(none)]> SHOW BINARY LOGS\G *************************** 1. row *************************** Log_name: mysql-bin.000015 File_size: 4714627 2 rows in set (0.00 sec) MySQL [(none)]> SHOW MASTER LOGS\G *************************** 1. row *************************** Log_name: mysql-bin.000015 File_size: 4714627 2 rows in set (0.00 sec)二. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] 列出二进制日志事件IN 'log_name' 指定要查询的binlog文件名(不指定就是第一个binlog文件)FROM pos 指定从哪个pos起始点开始查起(不指定就是从整个文件首个pos点开始算)LIMIT [offset,] 偏移量(不指定就是0)row_count 查询总条数(不指定就是所有行)MySQL [(none)]> SHOW BINLOG EVENTS IN 'mysql-bin.000015' LIMIT 3,2\G *************************** 1. row *************************** Log_name: mysql-bin.000015 Pos: 219 Event_type: Query Server_id: 1 End_log_pos: 300 Info: BEGIN *************************** 2. row *************************** Log_name: mysql-bin.000015 Pos: 300 Event_type: Query Server_id: 1 End_log_pos: 526rows in set (0.01 sec) SHOW CHARACTER SET [like_or_where] SHOW COLLATION [like_or_where] SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where] SHOW CREATE DATABASE db_name SHOW CREATE EVENT event_name SHOW CREATE FUNCTION func_name SHOW CREATE PROCEDURE proc_name SHOW CREATE TABLE tbl_name SHOW CREATE TRIGGER trigger_name SHOW CREATE VIEW view_name SHOW DATABASES [like_or_where] SHOW ENGINE engine_name {STATUS | MUTEX} SHOW [STORAGE] ENGINES SHOW ERRORS [LIMIT [offset,] row_count] SHOW EVENTS SHOW FUNCTION CODE func_name SHOW FUNCTION STATUS [like_or_where] SHOW GRANTS FOR user SHOW INDEX FROM tbl_name [FROM db_name] SHOW MASTER STATUS SHOW OPEN TABLES [FROM db_name] [like_or_where] SHOW PLUGINS SHOW PROCEDURE CODE proc_name SHOW PROCEDURE STATUS [like_or_where] SHOW PRIVILEGES SHOW [FULL] PROCESSLIST SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n] SHOW PROFILES SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] SHOW SLAVE HOSTS SHOW SLAVE STATUS [FOR CHANNEL channel] SHOW [GLOBAL | SESSION] STATUS [like_or_where] SHOW TABLE STATUS [FROM db_name] [like_or_where] SHOW [FULL] TABLES [FROM db_name] [like_or_where] SHOW TRIGGERS [FROM db_name] [like_or_where] SHOW [GLOBAL | SESSION] VARIABLES [like_or_where] SHOW WARNINGS [LIMIT [offset,] row_count] like_or_where: { LIKE 'pattern' | WHERE expr } If the syntax for a given SHOW statement includes a LIKE 'pattern' part, 'pattern' is a string that can contain the SQL % and _ wildcard characters. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause that provides more flexibility in specifying which rows to display. See https://dev.mysql.com/doc/refman/5.7/en/extended-show.html. URL: https://dev.mysql.com/doc/refman/5.7/en/show.html
