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...【阅读全文】
查看mysql版本:[root@localhost logs]# mysql -Vmysql Ver 14.14 Distrib 5.6.37, for linux-glibc2.12 (x86_64) using EditLine wrapperlower_case_table_names参数详解:lower_case_table_names=1其中0:区分大小写,1:不区分大小写查询当前设置:mysql> show variables like '%lower%';----...【阅读全文】