Skip to main content

Tips Recover MySQL root Password

By depratama
One day i forgot myql root user password. Then i found simple steps to change it without reinstall mysql server.

1. Open console and stop mysql service
#/etc/init.d/mysqld stop


2. Then i run this service without password
#mysqld_safe --skip-grant-tables

you can run it as a background if you would not use another console (shell)
#mysqld_safe --skip-grant-tables &


3. Then i open another console and connect to mysql
#mysql -u root

output
mysql>


4. Next, i setup new password for root user
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit


5. Last step is stop mysql service
#/etc/init.d/mysqld stop


6. Finish, and start mysqld and test new password
#/etc/init.d/mysqld start
#mysql -u root -p
Labels:

Popular posts from this blog

Extend a LVM partition after increasing its virtual disk on Virtualbox

By depratama
No Linux machine at work? the easy way could be to simply install Virtualbox in one of the PC, create a VDI and install Ubuntu 14.04 in it. But the day will come when you need more space! Here is how to resize it: Resize Virtualbox VDI Open Virtualbox, make sure to shutdown your virtual machine. Then open a terminal (here windows): 1 2 3 4 cd “ C : \ Program Files \ Oracle \ VirtualBox ” VBoxManage list vms VBoxManage clonehd uuid 0000000000000000 backup . vdi VBoxManage modifyhd uuid 0000000000000000 -- resize 204800 This is the Virtualbox official manual  of available commands. And  this is a website  to convert Gb into Mb (–resize takes Mb as input, 200Gb = 204800Mb). Boot Gparted to resize the partition After a default install of Ubuntu Server on one physical disk, you will have a SWAP partition, and then an extended partition in which you’ll have your LVM partition (So 3 partitions).  Download Gparted  .iso,...
Read more

Word 2003 “This document couldnot be registered. It will not be possible to create links from other documents to this document.”

By depratama
One day when i open a document in Ms. Word 2003, I get the message “ This document could not be registered. It will not be possible to create links from other documents to this document .” After searching using google.com and open some website, i have one solution. It’s only one maybe two step that i have to do. I open my services panel and activated my DCOM Server Process Launcher . And, it works, the message no longer show again when i open my document using word 2003. That’s all. I hope it works to you too, if you have same problem. Nb: Open services panel, just open Run (Start–> Run) and type services.msc then Enter .
Post a Comment
Read more

Website Using HTTPS Protocol

By depratama
Last week, I changed protocol of my website from http to https. There were steps that i had to do. First, I installed openssl package and mod_ssl # yum install mod_ssl openssl Then, I configured the openssl  and created certificate # cd /etc/pki/tls/certs # make server.key # openssl rsa -in server.key -out server.key # make server.csr # openssl x509 -in server.csr -out server.crt -req -signkey server.key -days 3650 # chmod 400 server.* After that, I changed configuration of httpd/apache #nano /etc/httpd/conf.d/ssl.conf DocumentRoot "/var/www/html" ServerName www.server.world:443 SSLCertificateFile /etc/pki/tls/certs/server.crt SSLCertificateKeyFile /etc/pki/tls/certs/server.key Last, I restarted the webserver #service httpd restart That's all what i did last week to change my website protocol from http to https.
Read more