SerwerWeb.pl

If you have forgotten the root password or another user database is a very simple way to reset it. All commands made from the root of the operating system.

For starters turn off the MySQL server:

/etc/init.d/mysql stop

Run in the background database server command:

mysqld_safe --skip-grant-tables --skip-networking &

We log on as root to the mysql database without a password:

mysql -uroot mysql

Then, in a mysql console:

mysql> update user set Password=PASSWORD('nasze_nowe_hasło') WHERE User='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye

We resume the process from the background fg command, and when prompted:

mysqld_safe --skip-grant-tables --skip-networking 

we use the CTRL + C, should appear:

^C130504 21:32:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Run in normal mode, the MySQL server:

/etc/init.d/mysql start

Finally, you can check the password reset:

mysql -uroot -p