随笔分类 -  mysql

mysql备份与还原
摘要：#!/bin/bash # databases=( '__DATABASE_1__' '__DATABASE_2__' )databases=('otrs' 'wxi') # The host name of the MySQL database server; usually 'localhost 阅读全文

posted @ 2018-04-24 11:39 xianguang 阅读(110) 评论(0) 推荐(0)

mysql笔记
摘要：show global variables like '%slow%' show character set; 字符集 show collation 排序规则 show global variables like '%data%' [root@gz-zabbixproxy-n02 confluenc 阅读全文

posted @ 2017-09-15 19:48 xianguang 阅读(81) 评论(0) 推荐(0)

mysql数据库参数innodb_buffer_pool_size和max_connections
摘要：接到报故，查看mysql数据库以下参数 1、innodb_buffer_pool_size 2、max_connections 该参数定义了数据缓冲区buffer pool大小，类似于oracle的db_cache_sizemysql> show global variables like 'inn 阅读全文

posted @ 2017-06-19 14:05 xianguang 阅读(580) 评论(0) 推荐(0)

登录
摘要：select user,password,host from mysql.user; 权限 grant all privileges on *.* to root@'%' identified by 'pwd'; flush privileges; 备份： mysqldump -uroot -p o 阅读全文

posted @ 2017-05-25 12:52 xianguang 阅读(202) 评论(0) 推荐(0)

导航