Rabu, 16 Mei 2018

Totally uninstall MySQL Server Ubuntu

When you uninstall MySQL for any purpose and reinstall the MySQL Server, perhaps you want to fresh install for all the configuration, but you found that the configuration still remains.

Try this lists accordingly:

sudo service mysql stop  #or mysqld
sudo killall -9 mysql
sudo killall -9 mysqld
sudo apt-get remove --purge mysql-server mysql-client mysql-common

sudo deluser -f mysql
sudo rm -rf /var/lib/mysql
sudo apt-get purge mysql-server-core-5.7
sudo apt-get purge mysql-client-core-5.7
sudo rm -rf /var/log/mysql
sudo rm -rf /etc/mysql

sudo apt-get autoremove
sudo apt-get autoclean


Install MYSQL Server on Ubuntu 18.04



In case we need to install mysql server on ubuntu (18.04 LTS used as case), follow the instruction
  1. Install MySQL Server
    • sudo apt-get update
    • sudo apt-get install mysql-server

  2. Allow the remote access
    • sudo ufw allow mysql

  3. Start MySQL Server
    • sudo systemctl start mysql

  4. Set MySQL to launch at reboot
    • sudo systemctl enable mysql

  5. Set MySQL password
    • sudo /usr/bin/mysql -u root -p
    • mysql> use mysql;
    • mysql> UPDATE user SET authentication_string=PASSWORD('yourpassword') WHERE User='root';
    • mysql> FLUSH PRIVILEGES;

Kamis, 06 September 2012

SQL: Insert Into Table From Other Table

if you find error when executing:
 "insert into yourtable values(select col1,col2,col3 from yourothertable)"

use this statement instead of this:
 "insert into yourtable select col1,col2,col3 from yourtable"

you don't need to add values on your SQL.

thanks.
-ok-

Senin, 27 Agustus 2012

Manipulating DNS Alias at Local Computer

To change display name at local computer without registering the DNS Server, you can edit the hosts files.

In other words, this will manipulate the domain name of your local PC before the computer requests to DNS Server.

Windows:
  1. goto c:\windows\system32\etc\drivers\
  2. edit a file named "hosts"
  3. add the point to your IP address with your preferred name
Linux:
  1. goto /etc
  2. edit a file named "hosts" (use sudo gedit hosts)
  3. add the point to your IP address with your preferred name
This way is only manipulate the domain name in local computer,
for example if you add 192.168.0.123 with name yourdomain.com, then you open the internet browser and browse to http://yourdomain.com, you'll get the website of 192.168.0.123

-ok-

Selasa, 31 Juli 2012

MS Outlook 2007: Operation failed, object could not be found

When you found this error in MS Outlook 2007:
"Operation failed, object could not be found"
and you've searched the solutions, you may dissapointed because it could not solve your problem.

you can try this steps as alternative:
1. Look for outlook.exe file, usually c:\program files\microsoft\office12\outlook.exe
2. Right click the outlook.exe file, and click properties

3. click the compatibility tab, and uncheck the compatibility mode, so it will not run in compatibility mode

that's all, you can try this one. -ok-

Selasa, 27 Desember 2011

operasi file

operasi file (pada Pascal)

- assign($varfile, 'filename')
menentukan file yang akan disimpan dalam variabel $varfile

- buka file:
a. reset($varfile)
membuka file dalam keadaan utuh, kursor disimpan di awal file
b. rewrite($varfile)
membuka file dalam keadaan kosong, kosongkan jika ada isinya
c. append($varfile)
membuka file dalam keadaan utuh, kursor disimpan di akhir file

- eof
end of file, memeriksa apakah sudah di akhir file
eof($varfile) bernilai boolean

- close($varfile)
menutup file $varfile yang sedang dibuka

Selasa, 29 November 2011

Autologon Windows XP

To turn on autologon in windows XP, you just need to do this steps:

1. Start - Run
2. "control userpasswords2" (without quotes "")
3. uncheck the "users must enter a username......"
4. click OK
5. enter the user and password that will be used as autologon account.
6. restart the computer

don't forget:
before setting the autologon, you have to set password first, to do so:
1. Start - Run
2. "control userpasswords2" (without quotes "")
3. click on second tab (Advanced)
4. click "Advanced" button
5. double click users
6. right click on the user - set password
7. you will get warning, just click the "proceed"
8. input the password and confirm

Sabtu, 09 Juli 2011

Cannot copy Access is Denied

Saat kita bekerja dengan file excel atau yang lainnya, mungkin pernah menghadapi masalah: file yang sudah diolah lama dan memerlukan pemikiran banyak, ternyata setelah dicopy ke folder atau flashdisk malah tidak dapat dibuka sama sekali dengan pesan yang muncul "Cannot copy Access is Denied... you may be denied access to a file if it's in use by another application."

hal ini bisa jadi karena saat dilakukan copy, ternyata hak akses terhadap file tersebut tidak ikut serta dicopy, sehingga file yang bersangkutan tidak memiliki data hak akses...

untuk kasus seperti itu, kita harus menambahkan secara manual hak akses pada file tersebut dengan cara:
1. klik kanan file yang bersangkutan
2. pilih properties
3. pilih tab security, jika tab ini tidak muncul, silakan ikuti panduan di http://omankb.blogspot.com/2011/07/menampilkan-tab-security-dan-sharing.html

4. tambahkan everyone pada security, dan thickmark semua permission allow.

selanjutnya file anda sudah dapat diakses kembali.

semoga bermanfaat
~ok
4.

Menampilkan tab Security dan Sharing

Jika Anda adalah pengguna Windows XP Professional yang terbiasa dengan setting sharing dan security di kantor Anda, namun saat melakukan setting di rumah ternyata tidak menemukan kedua tab Sharing dan Security, berikut adalah cara untuk menampilkannya.
(catatan: setting ini tidak berlaku pada Windows XP Home)



Artikel ini disarikan dari http://support.microsoft.com/kb/307874 tentang "How to disable simple file sharing"
To access the english version of this step-by-step to display the sharing and security tab on windows explorer, just click on this link

1. Buka windows explorer
2. Klik menu Tools - Folder Options
3. Pada Tab View, cari "Use Simple File Sharing (recommended)"
hilangkan thickmarknya.
biasanya setting ini paling bawah pada list view.

Selanjutnya maka akan muncul dua tab baru "Security" dan "Sharing" pada properties setiap folder ataupun file Anda.

semoga bermanfaat
~ok

Sabtu, 02 Juli 2011

MySQL default user and password denied

==to see the solution without reading the story, please goto solution==
==untuk melihat solusi dalam bahasa indonesia tanpa membaca stori,klik solusi==

today when I tried to install XAMPP on my computer to show my students the server-side webprogramming, no errors found and the whole installation successfully until I try to connect to phpMyAdmin.

the default user "root" with no password is rejected, and the user/pwd "root"/"root" also rejected.

the page always resulted:
"Welcome to phpMyAdmin 2.10.2
Wrong username/password. Access denied."

no matter how deep I try, including connection via mySQL command line, the default password is always rejected.

no search result give the good result on solution, and finally I trowed back to "Add and Remove Programs" to uninstall the MySQL service.
then I realize something that, I've already installed Apache and MySQL before last installation of these things.

aha!
the problem I face is not really a problem that described anywhere, perhaps you've meet some problem on your computer, just see whether you already had the MySQL service before, so you can reset the password from correct path.


for your information, when we install a service package of webservice (i.e XAMPP, or others), if you already had it, all the service will connected to last instances (including the web path, mySQL instance), although the service panel is from new installation.

in Indonesia:kalau Anda menemukan masalah setelah menginstall paket webservice (misal XAMPP atau lainnya), jika masalahnya adalah <span style=">default user dan password selalu ditolak saat mengakses MySQL, baik dari phpMyAdmin maupun dari lainnya, kemungkinan karena Anda sudah memiliki MySQL sebelumnya, silakan periksa, lakukan reset pada path sebelumnya.

=semoga bermanfaat=
~ok

Kamis, 03 Maret 2011

Not Enough Server Storage

Hari ini saya merasa bodoh, dikadalin bahasa ukir.... heuheu... (baca: huruf kanji)

Ceritanya begini,
beberapa bulan yang lalu, saya dapat order instalasi jaringan di sebuah kantor cabang. Singkat cerita, instalasi jaringan selesai, network printer sudah terpasang pada tempatnya, semua workstation sudah bisa mencetak.
giliran setting network scan (printer yang dipasang adalah model network printer + scanner), ada satu notebook orang Jepang yang tidak bisa diakses folder share nya dari printer, errornya tidak diketahui karena berupa huruf kanji, tanpa nomor error.

Tidak pernah terpikirkan menuliskannya dan membawanya ke seorang teman yang biasa translate, baru beberapa hari yang lalu, terpikirkan paman saya untuk ditanyain.Pertama yang saya lakukan adalah set Japanese IME keyboard di netbook saya, biar bisa menulis huruf Jepang, then dengan fasilitas writing pad, saya menulis mirip2 dengan error yang bersangkutan, alhasil didapatkan tulisan kanji yang sesuai dengan tampilan error.
udah jadi script Kanji-nya, copy ke http://translate.google.com, dan ternyata yang didapatkan adalah "Not enough server storage is available to process this command."

halah, ini mah banyak atuh di google juga...

dan ini penyelesaiannya.... (maaf, seperti biasa, ini adalah yang saya lakukan, apa yang anda kerjakan di komputer anda, saya tidak menjaminnya, silakan lakukan preventive jika terjadi kesalahan)

penyelesaian:
  1. jalankan regedit
  2. cari alamat berikut: "HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters"
  3. cari variabel IRPStackSize, jika tidak ada, buatlah dengan tipe DWord.
  4. jangan lupa, penulisan harus persis (case sensitive)
  5. nilai default IRPStackSize adalah 15, jika anda menemukan nilai sebelumnya adalah 11, silakan rubah menjadi 14 atau 15.
  6. tutup regedit, restart komputer.
penyebab masalah ini biasanya adalah konflik konfigurasi saat instalasi antivirus tertentu.

semoga bermanfaat....
~ok

Selasa, 29 Juni 2010

Netbios Over TCP IP always disabled

I've found something useful in order to troubleshoot XP2.

If we can not connect and resolve local network hosts, then you perhaps check it from command prompt (start-run-cmd), type: ipconfig /all

then if you found: Netbios over TCP IP --> disabled

perhaps you need this advice:

still in command prompt:
1. type: netsh int ip reset resetlog.txt
2. netsh winsock reset
afterthat, you need to restart your computer.

that's all, hope you can resolve the problem.

Selasa, 04 Mei 2010

ERROR 17 GRUB solved

If we have installed dual boot (Windows and Linux OS), then we remove Linux partition from Windows system, then we'll meet this error:

"GRUB LOADING.... ERROR 17...."

we can use Hiren's Boot CD (www.hiren.info), then we choose DOS utility (choose next if you can't find it), from Dos, just type "fdisk /mbr" (without quotes), then reboot....

that's all, I can't find this way simply at search engine. but now it's solved.

Selasa, 23 Maret 2010

Excel file can not be accessed

when you're open an excel file or word file, perhaps you found this problem:

'????.xls/????.doc' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding

I have searching this problem to fix my files, but microsoft themselves just said that it was an error because blah blah blah... no solution to open my important files...

fortunately, I have an open office installation on server (the server is Win 2003 server, but no office license, so I installed open office there)...
I tried to open the file using openoffice calc, and it works! (looks like MS advertising slogan)...
The corrupt excel file can be opened by openoffice calc and I can save the file into a new excel name . and this new file is okay to be opened by MS Excel.

so, if you found this problem just try this one:
- open the file using another application (non MS)
- save to another new MS common name.

FYI, my open office is 2.1 version...

shall we install open office in all our computers now?

Minggu, 06 Desember 2009

Generic Host Process Win32 error

satu hal setelah mencoba banyak yang ditawarkan, akhirnya "generic host process for win32 services has encountered a problem and needed to close" bisa diatasi...

mungkin karena sudah menambahkan yang lain2nya, atau memang langkah ini ampuh.
tapi nyata, setelah menjalankan dua langkah ini, tidak muncul lagi si generic.

buka notepad, save sebagai batchfile (misal fixgeneric.bat)
isi dengan dua baris berikut (ketik hanya yang diantara garis "===="

untuk yang nggak suka copy paste, boleh lewat commandprompt, ketik langsung di commandnya.

baris satu:
====
reg add HKLM\SYSTEM\CurrentControlSet\Services\netbt\parameters /v TransportBindName /t REG_SZ /d "" /f
====
baris dua:
====
reg add HKLM\Software\Microsoft\OLE /v EnableDCOM /t REG_SZ /d "N" /f
====

restart komputernya....
let me know the results...

Jumat, 22 Mei 2009

locating the outlook express files

to locate the outlook express files on our computer:
1. from outlook express click: Tools - Options - Maintenance - Store Folder
2. copy the location.
3. go to windows explorer and paste the copied address in address bar, or
- click Start
- click Run
- paste the copied address and press ENTER.

there you'll find some files with extension .dbx, they are the store files of outlook express.

Outlook Express: outbox error


This explanation describe the possible caue when you got Outlook express error message but no error details shown.

"Some errors occured while procesing the requested task. Please review the lit of errors below for more details."

before we go to the solution, you need to know that maximum single file size of WindowsXP is limited, 2GB for FAT and 4GB for FAT32, 16TB-4KB for NTFS.

I have experienced this error and it's because the file on my computer (sentitems.dbx) was reached 2GB.... so I need to delete the emails on sent items then compact the folders.

  1. check the file size of your outlook express files: to do this, you need to know where the file stored, click this link.
  2. if you found there is/are file(s) with size larger than 1,9GB that indicate you will find problem on your outlook express.

solution 1:
  1. make sure your outlook express closed.
  2. rename the large file by adding _x to your file name (sentitems.dbx -> sentitems_x.dbx)
  3. open outlook express, and it will create new sentitems.dbx, means your sent items will be blank.
solution 2:
  1. delete the emails manually on sent items folders (this will took longer time).
  2. after succeed deleting the emails:
  3. click File - folder - compact all folders
  4. this will took some minutes even hours, you recommended to let the process until all the folders compacted or your outlook express folders damaged.
solution 3:
create new identity and let the old identity as your arcihieve identity

Kamis, 23 April 2009

Install Windows XP pada CQ40

untuk install windows XP pada CQ40-337TU, anda bisa cari menggunakan google, ada banyak bantuan dan forum yang memang mencari solusi ini, saya juga download lewat google.

kalo malas googling, berikut yang saya lakukan:
- siapkan OS installer (Windows XP Professional + serial)
- copy seluruh isi CD Windows XP Installer ke dalam satu folder
- jalankan nlite (download dari www.nliteos.com),
- pilih folder yang akan diburn
- tambahkan driver SATA-AHCI
- create ISO atau langsung burn to disk
- CD yang sudah dibuat bisa langsung dipakai untuk install WIndows XP
step by step create nlite CD dalam bentuk panduan lebih jelas, silakan lihat di http://www.justyushi.web.id/2009/03/24/install-windows-xp-di-compaq-cq40-series/

nah, tapi itu belum selesai, untuk instalasi driver, kita akan mengalami beberapa kesulitan.
silakan cari dan download driver yang sesuai. namun untuk instalasi driver tersebut kita diharuskan downgrade BIOS kita ke versi F11E, silakan download dan jalankan BIOS Flash dari http://www.hw4computers.com/images/drivers/30F7F11E.zip

selanjutnya driver yang sudah ada bisa langsung diinstall.

Selasa, 24 Februari 2009

Broadcom 802.11g Wireless Network problem?

Lenovo G430 Broadcom 802.11g Network Adapter problem? (written by oman) if you have already search and try all the blogs and forums found by google, try this one, coz this already happened to me and I found it by myself... when I found it I felt so stupid fooled by the system. Here is the clue: (written by oman) remember that there are some switches for notebook wireless before you can use it:
power switch, you need to switch this power on, located under your left-hand position.
hotkey switch, press fn-F5 for lenovo G430 or another key for other notebook.
make sure that you switch it on when hotkey displayed
that's all! have a nice weekday!
your comments are welcomed.

Rabu, 30 April 2008

Current User = admin sementara

jika kita kesulitan untuk melakukan aktivitas administrator pada saat bersamaan yang login adalah user biasa, maka kita bisa melakukannya dengan mengaktifkan run as... pada program bersangkutan.
caranya:
  • klik kanan pada executable program yang akan di-execute dg administrator-prefilige
  • pilih the following user, isi user dan password dengan user setingkat administrator.

tips tambahan:

untuk control panel management, hal ini juga berlaku. dan ini bisa kita gunakan untuk memberikan hak setingkat administrator secara temporer kepada current user:

  • masuk control panel - administrative tools
  • klik kanan computer management, pilih run as... gunakan login administrator
  • masukkan current user sebagai bagian dari administrator group.

masih banyak hal lainnya yang bisa kita lakukan dengan cara ini (misal: membuat folder sharing, dll)