Hi all,
I am new to SQL and have read various forum tips in my attempt to reconfigure the SQL password to connect from Navicat to the SQL server. Originally, I got the below messages:
ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
and
ERROR 1045: Access denied for user: 'root@localhost' (Using
password: YES)
and was told I should make the password changes from my terminal. I then issued the below command:
Last login: Thu Nov 3 07:35:06 on ttys000
administrators-MacBook-Pro:~ admin$ sudo dpkg-reconfigure mysql-server-5.7
After entering my password, I got this:
sudo: dpkg-reconfigure: command not found
administrators-MacBook-Pro:~ admin$
I then ran:
whereis sudo
and got:
/usr/bin/sudo
followed by
administrators-MacBook-Pro:~ admin$
This seemed right, so just for good measure, I tried another way of resetting the password:
sudo mysql -u root
use mysql;
update user set plugin='' where User='root';
flush privileges;
exit;
The result was:
sudo: mysql: command not found
administrators-MacBook-Pro:~ admin$ use mysql;
-bash: use: command not found
administrators-MacBook-Pro:~ admin$ update user set plugin='' where User='root';
-bash: update: command not found
administrators-MacBook-Pro:~ admin$ flush privileges;
-bash: flush: command not found
administrators-MacBook-Pro:~ admin$ exit;
What am I missing/doing wrong?
I am new to SQL and have read various forum tips in my attempt to reconfigure the SQL password to connect from Navicat to the SQL server. Originally, I got the below messages:
ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
and
ERROR 1045: Access denied for user: 'root@localhost' (Using
password: YES)
and was told I should make the password changes from my terminal. I then issued the below command:
Last login: Thu Nov 3 07:35:06 on ttys000
administrators-MacBook-Pro:~ admin$ sudo dpkg-reconfigure mysql-server-5.7
After entering my password, I got this:
sudo: dpkg-reconfigure: command not found
administrators-MacBook-Pro:~ admin$
I then ran:
whereis sudo
and got:
/usr/bin/sudo
followed by
administrators-MacBook-Pro:~ admin$
This seemed right, so just for good measure, I tried another way of resetting the password:
sudo mysql -u root
use mysql;
update user set plugin='' where User='root';
flush privileges;
exit;
The result was:
sudo: mysql: command not found
administrators-MacBook-Pro:~ admin$ use mysql;
-bash: use: command not found
administrators-MacBook-Pro:~ admin$ update user set plugin='' where User='root';
-bash: update: command not found
administrators-MacBook-Pro:~ admin$ flush privileges;
-bash: flush: command not found
administrators-MacBook-Pro:~ admin$ exit;
What am I missing/doing wrong?