Tuts4Tech

Resetting your mysql root password

First of all we need to stop mysql /etc/init.d/mysql stop Create a mysql table dump to reset the password UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; Now we need to start mysql in safe mode and import the mysql table dump mysqld_safe --init-file=/path/to/mysql/table/dump & Finally we need to kill mysql and start it in [...]

Continue reading...

Nano write check before editing

Have you ever been using nano to edit a long configuration file and when you've just finished you go to save and you get "Error writing /dir/somefile: Permission denied" as you've forgotten to use sudo or switch user if so this tutorial might just be your solution. What this does is it runs a script [...]

Continue reading...