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