Vladimir Putin “We discussed this important issue yesterday over a beer...”
Barack OBAMA “You know, my faith is one that admits some doubt...”
how to reset mysql root password:
Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for [...]
The general syntax of SET statement is :
SET variable_assignment [, variable_assignment] …
variable_assignment : user_var_name = expr | [GLOBAL | SESSION] system_var_name = expr | [@@global. | @@session. | @@]system_var_name = expr
SET statement is used for assigning the values for different types of variables which affects the operation of your client or the server. In [...]
In this section we are covering the topics like ANALYZE TABLE, BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE, RESTORE TABLE Syntax.
ANALYZE TABLE Syntax
The general syntax of ANALYZE TABLE statement is:
ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] …
This syntax is used to analyze and store the key distribution to a table. [...]
In MySQL user account information’s are stored in mysql database tables. In this section we will describe you about Create User, Drop User, Grant Syntax, Rename User, Revoke Syntax and Set Password Syntax.
CREATE USER Syntax
The general syntax of CREATE USER statement is :
CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]…..
In MySQL version 5.0.2 include the [...]
MySQL5.0 supports local transactions by statements like START TRANSACTION, SET AUTOCOMMIT, COMMIT and ROLLBACK. Transaction means a group of SQL Statements, which executes as a unit. And MySQL either executes all the statement successfully or it doesn’t execute anyone. This can be achieved by the commit and rollback. When all the statements executes successfully then [...]