MySQL

Recover MySQL root Password

by

1. Stop the MySQL server. # /etc/init.d/mysql stop 2. Start the MySQL server process with the –skip-grant-tables option so that it will not prompt for password. # mysqld_safe –skip-grant-tables & 3. Connect to mysql server as the root. # mysql -u root Welcome to the MySQL monitor…. ……….. Type ‘help;’ or ‘\h’ for help. Type … Read more

Replace phpMyAdmin by Adminer

by

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. It consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle. phpMyAdmin is one of the most famous tools for managing the MySQL database. However, Adminer have important differences with … Read more

SQL OR NOSQL?

by

If you are searching for SQL or noSQL solutions, it is very difficult to decide among top SQL / noSQL Databases. MySQL is the best for multi-document transactions, complex security, complex join, extreme compression. NoSQL is good for linear scalability, high performance, schema flexibility. But both depend on data need to manage 😉 Scalability MySQL … Read more