Jesin's Blog

Welcome to the Portal of Technology

  • Facebook
  • GitHub
  • Google+
  • RSS
  • Twitter
  • Home
  • Categories
    • Domains
    • Linux
    • Networking
    • PHP
    • Virtualization
    • Web Design
    • Web Servers
    • Windows
  • WordPress Plugins
    • Custom Error Pages
    • HTTP Digest Authentication
    • Mailgun Email Validator
  • Toolbox
    • DNS Lookup Tool
    • htdigest Generator Tool Online
    • htpasswd Generator Tool Online
    • HTTP Headers Lookup Tool
    • MD5 Encryption Tool
    • Open Port Check Tool
    • SHA-1 Encryption Tool
    • URL Encoding/Decoding Tool
  • About Me
  • Contact Me
  • Sitemap
Home ›
mysql

Forgot MySQL root user password (Linux)

March 28, 2011 Linux Jesin A Leave a Comment

linux category thumbnail

Reset your MySQL root password if you ever forget it by following the instructions provided here. Earlier I wrote an article to reset the MySQL root password in windows, this article does the same thing in Linux resetting the MySQL root user’s password if you forget it. The instructions outlined here are based on the Linux command-line. The procedure is same for both Windows and Linux, stopping the MySQL service, creating an file with the SQL query to reset the Linux password and executing it through the init-file option.Continue Reading…

Tags: mysql

Resetting MySQL root password in Windows

March 19, 2011 Windows Jesin A Leave a Comment

forgot mysql password windows smiley

This tutorial describes how to reset the MySQL root user password if the root password is forgotten. The procedure in windows involves creating a new file which contains a query to UPDATE the MySQL root user’s password from the table named ‘user’ and then start the MySQL process again. Before starting check whether MySQL is running as a service or as a process. To check this got to start -> run or [windows] + R and type services.msc. If you find a service named MySQL or something similar to wampmysql then MySQL is running as a service right click it and stop it. Else open task manager and locate a process named mysqld and “End” the process. If you’re using Linux read this article.Continue Reading…

Tags: mysql

Creating a PHP MySQL Login Page Script

December 3, 2010 PHP Jesin A 3 Comments

php category thumbnail

PHP Login page script with three modules, the first one for allowing new users to register, the second for allowing users to login and the third page is a private page which only logged in users can access. Before reading this article make sure you read Connect PHP with MySQL because there is extensive use of PHP mysql functions throughout this article. The registration module uses INSERT query, the login module uses SELECT query to verify whether a user’s credentials exist in the database and creates a session and the private page checks to see if there is a session variable.Continue Reading…

Tags: mysql, php, php scripts

Connect PHP with MySQL

November 26, 2010 PHP Jesin A 1 Comment

connect php with mysql thumbnail

Connect PHP with MySQL database, execute queries to manipulate information and retrieve data and display it using MySQL. Connecting with a MySQL database using PHP requires the use of three functions mysql_connect() mysql_select_db() and mysql_query() In this article I’ll be explaining how to connect to a MySQL server, create a database, create a table, insert values into it and retrieve it to display it in the form of HTML tables.Continue Reading…

Tags: mysql, php

How to reset the Joomla Administrator password

September 16, 2010 PHP Jesin A Leave a Comment

php category thumbnail

A decade ago we were worrying about where we kept our car/house/company keys and as our wealth grew we had to manage more number of keys. Come back to the current world world we live now and the situation doesn’t get any better, the only difference is we need to manage our key to our online world aka the password. From emails to bank accounts, forums to social networking websites we have a whole paragraph of  passwords and the situation worsens when you become a web designer/webmaster. A password for your web hosting account, one for the domain control panel another for your CMS and the list goes on. So it won’t take a long time before you click on that “Forgot Password” button.

Alright enough of storytelling lets get to business. So you’ve forgotten your joomla administrator password and you can’t find that much needed “Forgot Password” link on the joomla administrator login. Now what do you do, read this article further.Continue Reading…

Tags: forgot password, joomla, mysql, phpmyadmin

Get a wealth of information delivered to your inbox. Subscribe and never miss a single article.

  • Tutorials and howtos
  • Code, scripts and commands
  • Online Tools

* No spam, unsubscribe anytime

Hire Me

  • SSL installation and hardening (A+ on Qualys SSL test)
  • Apache & Nginx configuration
  • Email deliverability improvement (10/10 on Mail Tester & MailGenius)
  • WordPress customization, optimization and migration
  • and much more…

    Tools

    • DNS Lookup Tool
    • htdigest Generator Tool Online
    • htpasswd Generator Tool Online
    • HTTP Headers Lookup Tool
    • MD5 Encryption Tool
    • Open Port Check Tool
    • SHA-1 Encryption Tool
    • URL Encoding/Decoding Tool

    Nav

    • Home
    • About Me
    • Contact Me
    • Privacy Policy
    • Sitemap
    Vultr SSD VPS

    Creative Commons License
    Jesin's Blog by Jesin A is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
    Based on a work at websistent.com.