Posts Tagged ‘sql

If you want to create an additional admin account for MySQL server, connect to the MySQL server with a MySQL client program and execute the following command:
GRANT ALL ON *.* TO ‘admin’@'localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
Change the word “admin” to whatever username you want to use for the admin account and change “password” [...]

Here is an example of a basic login function which is taught in a lot of PHP tutorials. The purpose of this code is to prevent someone from viewing a web page unless they provide a valid username/password in a form. The username/password is stored in a MySQL database.
$username = $_POST["username"];
$password = $_POST["password"];$query = “SELECT [...]


About this blog

This blog is about technology related topics. It will primarily contain problems and solutions to IT problems that I encounter on a day-to-day basis. In addition interesting things I come across either on or off the internet will be posted here as well. I will also include step-by-step tutorials to common tasks people may need to do with their computers.

Web Hosting Discount

    Get the first month for only $0.01 using coupon code HGCOUPONBLOG. No contracts, cancel anytime.

Revolutionary One Time Password Device

Add to Technorati Favorites