総計:502 今日:1 昨日:1
[mysqld] transaction-isolation=READ-COMMITTED
grant all privileges on *.* to root@'%' identified by 'XXXX' with grant option;
mysql> show variables where variable_name='lower_case_table_names'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | lower_case_table_names | 0 | +------------------------+-------+
[mysqld] lower_case_table_names = 0
mysql> show create table TEST_TABLE; ~
mysql> alter table TEST_TABLE drop foreign key TEST_TABLE_ibfk_2;
mysql> alter table TEST_TABLE add foreign key (MY_ID) references REF_TAB(MY_ID);
mysql> use information_schema; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select table_name, engine from tables where table_name = 'TEST_TABLE'; +---------------------------+--------+ | table_name | engine | +---------------------------+--------+ | TEST_TABLE | InnoDB | +---------------------------+--------+ 1 row in set (0.00 sec)
[testuser@sv18]$ mysql -t -h dbserver -u testapp -ptestapp testapp << EOF select * from MY_TAB limit 1; EOF +------------+--------------+ | MY_ID | RECORD_COUNT | +------------+--------------+ | 1 | 1 | +------------+--------------+
[root@sv07 mysql]# mysqld --help --verbose | head -20 ~ Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
mysqld_safe --port=3306
[root@sv07 testapp]# pwd /var/lib/mysql/testapp
[mysqld] datadir=/mnt innodb_data_home_dir=innodb_dir innodb_data_file_path=LUN1/ibdata1:100M;LUN2/ibdata2:100M:autoextend