Navicat SQL connection password issue

Discussion in 'Mac Programming' started by bash1, Nov 7, 2016.

Tags:
  1. bash1 macrumors newbie

    bash1

    Joined:
    Nov 7, 2016
    #1
    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?
     
  2. robvas macrumors 68020

    Joined:
    Mar 29, 2009
    Location:
    USA
    #2
    Looks like you don't have sql installed and you're also following a linux guide
     
  3. CreatorCode macrumors regular

    CreatorCode

    Joined:
    Apr 15, 2015
    Location:
    US
    #3
    "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.
     

Share This Page