Import Sql(dump file) to mysql database

First lets look at what is mySQL database? MySQL is a relational database management system (RDBMS) which has more than 11 million installations. The program runs as a server providing multi-user access to a number of databases. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the codebase. The project's source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements. Why ...

Continue Reading »

[MySQL]Reset the root password

For users of the powerful database MySQL, access, as well as right to modify the admin (root) password is important, because both are required when installing and in situations when the master password is lost. The user must be connected to the root password to modify it but for reinitialising the password, this process can be skipped. Resetting the password is possible after connection to theMySQL database with the help of specific commands. In case the password is lost, then it is also possible to get access to the MySQL server through a bypass ...

Continue Reading »

Cum resetezi parola de root din Phpmyadmin

Rulezi /etc/init.d/mysql stop Restartezi Mysql  cu comanda mysqld --skip-grant-tables --skip-networking & Rulezi mysql mysql -u root Apoi UPDATE user SET password=PASSWORD('newpassword') WHERE user="root"; Optional FLUSH PRIVILEGES; Apoi startezi /etc/init.d/mysql restart ...

Continue Reading »