Setup MySQL on Ubuntu Droplet getting error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 

sudo /etc/init.d/mysql stop
Now start up MySQL in safe mode, so you'll skip the privileges table:
sudo mysqld_safe --skip-grant-tables &
Login with root:
mysql -uroot
And assign the DB that needs to be used:
use mysql;
Now all you have to do is reset your root password of the MySQL user and restart the MySQL service:
update user set password=PASSWORD("YOURPASSWORDHERE") where User='root';

flush privileges;
quit and restart MySQL:
quit

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Now your root password should be working with the one you just set, check it with:
mysql -u root -p

Popular posts from this blog

How to install and configure Apache2 for Webhosting on Linux (Ubuntu 14.04)

Apache2 Installation and Configuration on Ubunut 14.04 and run two instant website on server. ____________________________________________ Step1 After install Ubunut 14.04 ____________________________________________ Goto Terminal $sudo apt-get update $sudo apt-get install apache2 by default all apache2 file install in /etc/apache2/ And location of where we put our website contain /var/www/ ____________________________________________ Step2 _____________________________________________ Goto /var/www/ and creat a folder name /arvweb and creat a demo file/page under /arv/arv.html   by using below command $sudo mkdir -p /var/www/arv $sudo nano /var/www/arv/arv.html  #(and past below text) <html>   <head>     <title>Welcome to arv.com!</title>   </head>   <body>     <h1>Success!  arvapache.blogspot.com</h1>   </body> </html> _____________________________________...
Read more

How to set Java Path if you want to put your java any directory in linux Computer

NOte !!!  Thursday 12 January 2017 03:36:52 PM IST You have to change you username !!! here above is user6 !!! You have to change your extrated folder location of JAVA !!! here above is /home/user6/software/jdk1.8.0_111 !!! Matarial Need.. Tar/zip file of Java and extract it on below location /home/user6/software/jdk1.8.0_111 Step 1 edite profile #sudo gedit /etc/profile type past bleow lines JAVA_HOME=/home/user6/software/jdk1.8.0_111 JRE_HOME=/home/user6/software/jdk1.8.0_111/jre PATH=$PATH:$JRE_HOME/bin:$JAVA_HOME/bin export JAVA_HOME export JRE_HOME export PATH Step 2 run below command after extrat your java /home/user12/software/ Note = Your java extrated location /home/user64/software/jdk1.8.0_111 Run blow command in sudo mode for say ubuntu where is your java installed/extrated file sudo update-alternatives --install "/usr/bin/java" "java" "/home/user6/software/jdk1.8.0_111/bin/java" 1 sudo update-alternatives --install...
Read more

Make autoservice for Tomcat

-------------------------------------------------------------------------------- Step 1 -------------------------------------------------------------------------------- Create file in this location /etc/init.d/tomcat2 with following instructions and past below lines... #nano /etc/init.d/tomcat2 #!/bin/bash # description: Tomcat Start Stop Restart # processname: tomcat # chkconfig: 234 20 80 #Should be your java path location.... JAVA_HOME=/usr/lib/jvm/jre-openjdk export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH export PATH #Should be your tomcat location CATALINA_HOME=/opt/tomcat2 case $1 in start) sh $CATALINA_HOME/bin/startup.sh ;; stop) sh $CATALINA_HOME/bin/shutdown.sh ;; restart) sh $CATALINA_HOME/bin/shutdown.sh sh $CATALINA_HOME/bin/startup.sh ;; esac exit 0
Read more