Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

bash1

macrumors newbie
Original poster
Nov 7, 2016
1
0
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

macrumors 68040
Mar 29, 2009
3,240
630
USA
Looks like you don't have sql installed and you're also following a linux guide
 

CreatorCode

macrumors regular
Apr 15, 2015
159
279
US
"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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.