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
Oman Komarudin Win
curhat, umpatan, makian, kritik sosial, atau hanya tulisan biasa saja. dari seorang yang "luar-biasa biasa" (alias sangat biasa, alias biasa-biasa saja)
-
| Artikel Personal |
| Windows |
| Berbagi Catatan |
| Artikel Umum |
| Album Pribadi |
| Script Collection |
Rabu, 16 Mei 2018
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
- Install MySQL Server
- sudo apt-get update
- sudo apt-get install mysql-server
- Allow the remote access
- sudo ufw allow mysql
- Start MySQL Server
- sudo systemctl start mysql
- Set MySQL to launch at reboot
- sudo systemctl enable mysql
- 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-
"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:
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-
In other words, this will manipulate the domain name of your local PC before the computer requests to DNS Server.
Windows:
- goto c:\windows\system32\etc\drivers\
- edit a file named "hosts"
- add the point to your IP address with your preferred name
- goto /etc
- edit a file named "hosts" (use sudo gedit hosts)
- add the point to your IP address with your preferred name
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-
"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
- 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
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
Label:
autologon,
automatic logon,
logon,
user password
Langganan:
Postingan (Atom)