macOS Navicat SQL connection password issue

[bash1]

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?

 

[robvas]

Looks like you don't have sql installed and you're also following a linux guide

 

[CreatorCode]

"SQL" is a language specification, not a product.

It looks like you're trying to set up MySQL. MySQL has a lot of documentation on its own website. Start with that.
http://dev.mysql.com/doc/

Get it running with the MySQL client first.

Once you've got that up and running, you can worry about third-party clients like Navicat.