MySQL Root Password Reset Rumi, March 18, 2013 First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords. mysqld_safe –skip-grant-tables You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password. mysql –user=root mysql update user set Password=PASSWORD('new-password') where user='root'; flush privileges; exit; Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again. Related Administrations Configurations (Linux) MySQL
Install CakePHP 3 On Ubuntu 16.04 September 30, 2018September 30, 2018 This guide assumes you’ve set up a Ubuntu 14.04 server and have MYSQL up and running. This guide uses the “PHPMyAdmin” from the “One Click Apps” available on Digital Ocean running on a vps running Ubuntu 16.04. The smallest memory (512mb) should be enough to get you up and running…. Read More
Reset a MySQL root password for Debian July 14, 2016 Use the following steps to reset a MySQL root password by using the command line interface. Stop the MySQL service (Ubuntu and Debian) Run the following command: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: sudo /etc/init.d/mysqld stop Start MySQL without a password Run… Read More
LHMP- Linux Haiwatha Mysql PHP simplistic new breed!! February 18, 2017February 18, 2017 Step 1 – Setup repository for pre-compiled Hiawatha Debian binaries The first thing you’ll need to do is to setup the repository for Hiawatha Webserver. You may also compile it on your own if you wish, but for this tutorial we’ll be using the pre-compiled binaries. First, get and install… Read More