Category Archives: MySQL

11.19.12
by

How to retrieve weak Password stored in MD5 form?


It’s very common that people sometimes uses very common passwords and they are extremely weak. In case you forget that password also then what?

Normally Passwords are stored in MD5 form in Database and you directly can’t make out what exactly the password is…

.

.

.

.

.

In that case copy the MD5 code and google it, if it’s weak then there are high chances that you will get the password on google itself.

or Visit http://md5stat.altervista.org/index.php?list=found

About these ads
11.16.12
by

How to set ROOT password in MySQL


On RHEL and CentOS, MySQL does not set a root password by default. MySQL does not set a root password by default. It is very strongly recommended to set a root password as a security precaution.

[root@cloudstack etc]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.61-log Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> SET PASSWORD = PASSWORD(‘admin’);
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@cloudstack etc]# mysql -u root -padmin
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.61-log Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

Done!!