Tag Cloud

Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Tuesday, September 24, 2013

Lowongan Magang Web Developer

Di buka lowongan untuk posisi magang
Web Programmer

- Dibutuhkan 2 orang
- Skill requirement basic: HTML,javascript,jquery,PHP, MySQL
- No Experience needed
- Akan diberikan training tambahan sebelum kerja
- Dikontrak untuk 1 bulan dengan possibility untuk diperpanjang.
- Kantor di Business Park Kebon jeruk A18
- Bila selesai kontrak akan diberikan surat rekomendasi staff magang dengan cap perusahaan.
- Jam kerja 20 atau 40 jam/minggu

Bagi yang berminat silahkan hubungi via email di
ali@evo-training.com 
dengan judul email "Magang Web Programmer"

Saturday, December 15, 2012

Adding user in MySQL and give grant


CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

Tuesday, November 29, 2011

Allowing remote connection in MySQL

When using MySQL, sometime you want to allowing remote connection (from different server)

Run mysql command line console. Usually in /usr/bin/mysql or /usr/local/mysql/bin/mysql

Your shell prompt should be like this

mysql>

Run this command

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

Then

FLUSH PRIVILEGES;

Please change USERNAME, IP, PASSWORD, base on your need.
For example:

GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.20 IDENTIFIED BY "MySecretPassword";