Showing posts with label Mysql. Show all posts
Showing posts with label Mysql. Show all posts

Tuesday, April 23, 2013

mysql hack -- some tips..!

1- Mysql engine selection

MySQL uses row-level locking for InnoDB tables to support simultaneous write access by multiple sessions, making them suitable for multi-user, highly concurrent, and OLTP applications. MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables, allowing only one session to update those tables at a time, making them more suitable for read-only, read-mostly, or single-user applications. " @http://dev.mysql.com/doc/refman/5.5/en/internal-locking.html

Thursday, January 31, 2013

reset root password of mysql

If you are getting problem ins accessing mysql using root because you forgot password and getting below error.

error snapshot-
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES/NO)

Than  you can reset the root password using below.

"sudo dpkg-reconfigure mysql-server-<version-number>"

OR

/usr/bin/mysqld_safe --skip-grant-tables &
mysql --user=root mysql
update user set password=PASSWORD("mynewpassword") where User='root';
 
"with --skip-grant-table" it will allow root access without password.