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…
Resetting MySQL root password in Windows
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…
Creating a PHP MySQL Login Page Script
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…
Connect PHP with MySQL
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…
How to reset the Joomla Administrator password
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…
