Cara membolehkan Firewall apche dan mysqld pada xampp

 1.allow pada apache di folder apce bin
2. allow apada folder mysql bin mysqld

Access denied; you need the SHOW DATABASES privilege for this operation

Please follow the steps below -
1. Close your connection. Then, right-click it and choose Connection Properties.
2. Click to Advanced tab.
3. Check "Use advanced connections".
4. Click "Add DB to List" button.
5. Enter your database name in the pop up.
6. You can see the database is added into the list.
7. Repeat steps 4 and 5 again to add another database if necessary.
Click OK to close the connection properties settings. Double-click your connection to see if you can access your database.

Mysql Administrator to Backup Mysql Otomatis

https://drive.google.com/open?id=0B01lHm9t7ukAa0F0azk5X091NXM




ada baru

http://coding4ever.net/blog/2015/04/30/membuat-jadwal-backup-database-otomatis/

Menangani data table Banyak

https://www.onphpid.com/menangani-jumlah-data-yang-besar-pada-datatables.html

Merubah format tanggal pada Excell untuk update kedalam sql

update mahasiswa set tanggal_lahir='1965-09-06' where nim='PDIH03IV140102'; ="update mahasiswa set tanggal_lahir='"&TEXT(E2;"YYYY-MM-DD")&"' where nim='"&A2&"';"

simple kan?

Cara Menchache Mysql

buka mysql cari my.ini di folder bin
set-variable=query_cache_size=64M

kemudian untuk cek apakah sudah berhasil query
ini
SHOW VARIABLES LIKE  '%query_cache%'

create table di Mysql dengan query

CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);

membuat if else di mysql

cara membuat if else di mysql

if(agama='islam',1,if(agama='Kristen',2,3)) as ID_AGAMA,

if(detail_penjualans.disc is null,0,detail_penjualans.disc) AS subtotal

Comand Promt Mysql

change direktori dulu

cd ../..

cd xampp/bin

masuk mysql

mysql -u root

create data base

CREATE DATABASE PRAKTIK;

SHOW DATABASES;

USE PRAKTIK;

SHOW TABLES;

perintah insert
insert into post(id,nama,body) values('1','h','juga');

perintah select

select * from post;

perintah update

update post set nama='halo' where id=1;

perintah delete

delete from post where id=1;

Cara Memperbesar limit execution query Mysql

mengganti nilai-nilai dari beberapa variable yang ada di php/php.ini di bawah ini :
sebelum di ubah :
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

setelah diubah :
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Melihat Versi Microsoft SQL Server

SELECT @@version as produk

SELECT @@version as produk