CREATE USER 'jirauser' IDENTIFIED BY 'jirauser';CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;grant all on jiradb.* to 'jirauser'@’%' identified by 'jirauser';CREATE USER 'confluence' IDENTIFIED BY 'whsir'; create database confluence character set utf8 collate utf8_bi...【阅读全文】
How To Setup Disk Quotas For MySQL Databaseby Vivek Gite on January 28, 2008 last updated January 28, 2008 in Howto, Linux, MySQL, UNIX This is a user contributed article.MySQL server has no support for preventing disk from getting filled up. You need to depe...【阅读全文】
进入information_schema 数据库(存放了其他的数据库的信息)mysql> use information_schemaReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed 第一种情况:查询所有数据库的总大小,方法如下:mysql> sel...【阅读全文】
一、MySQL安装MySQL可以在redhat环境下进行RPM安装和debian下apt安装,但是最新的包一般都是源码的形式,因此这里选择源码编译安装的方式。首先登陆官方网站http://www.mysql.com,下载最新的released版本。# tar zxf mysql-5.1.22-rc-linux-i686-glibc23.tar.gz为mysql的运行建立mysql用户和mysql用户组#gro...【阅读全文】