Archive for the ‘MySQL’ Category

Command to check Mysql version in Plesk

go to following directory

%plesk_dir%\Databases\MySQL\bin

run the following command

mysql -uadmin -pMYSQL_ADMIN_PASSWORD -V

MySQL Problem ERROR 2005 (HY000): Unknown MySQL server host ‘localhost’ (0)

add the following entry is host file

127.0.0.1 localhost

How to Reset MySQL root password.

1) First Stop the MySQL service with command  service mysql stop

2) Execute the command  mysqld --skip-grant-tables --skip-networking

3) Now you can connect to MySQL without  the root user password

4) Connect using mysql -u root

5) mysql> UPDATE mysql.user SET Password=PASSWORD('newPassword') WHERE User='root';

  mysql> FLUSH PRIVILEGES;

  mysql> exit
6) Restart the MySQL service .

 

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter