mysql lower case table names

Lho lho kok ada perbedaan saat nguery

select * from barang;


select * from BARANG;

,, query yang satu sukses tapi query yang lain error ??? ooo iya sekarang kan pke linux ,, makanya case sensitive.

q> Edit configurasi mysql pada file my.cnf

sudo nano /etc/mysql/my.cnf

tambahkan lower_case_table_names=1 setelah baris [mysqld]

# * Basic Settings
user        = mysql
pid-file    = /var/run/mysqld/
socket        = /var/run/mysqld/mysqld.sock
port        = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir        = /tmp
lc-messages-dir    = /usr/share/mysql

q> Berhasil. hore hore


Published by


Begin a big Process with a bit trying

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s