First reset mysql password.
Now that we have changed the root user password we can create a new user. Also in putty we write the following
We will be prompted to enter a password, enter the password set in step 5 above.
And that was all, now you can log in to navicat.
Code:
/usr/local/etc/rc.d/mysql-server stop
Code:
mysqld_safe --skip-grant-tables &
Code:
mysql -u root
Code:
use mysql;
Code:
update user set password=PASSWORD("PAROLA_NOUA_PENTRU_USER_ROOT") where User='root';
Code:
flush privileges;
Code:
quit
Code:
/usr/local/etc/rc.d/mysql-server restart
Code:
mysql -u root -p
Code:
use mysql;
Code:
CREATE USER 'USER_NOU'@'%' IDENTIFIED BY 'PAROLA_USER_NOU';
Code:
GRANT ALL PRIVILEGES ON * . * TO 'USER_PUS_LA_PASUL_4'@'%';
Code:
quit