Results 1 to 3 of 3

Thread: MySQL Error ERROR 1064 (42000) - moodle installation

  1. #1
    Join Date
    Aug 2020
    Beans
    2

    Re: MySQL Error ERROR 1064 (42000) - moodle installation

    GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodledude@localhost IDENTIFIED BY 'passwordformoodledude';


    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near IDENTIFIED BY 'passwordformoodledude'' at line 1




    I'm stuck here... please help.

  2. #2
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    15,240
    Distro
    Kubuntu 20.04 Focal Fossa

    Re: MySQL Error ERROR 1064 (42000) - moodle installation

    GRANT does not use IDENTIFIED as a valid parameter.

    https://dev.mysql.com/doc/refman/8.0...ase-privileges
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  3. #3
    Join Date
    Aug 2020
    Beans
    2

    Re: MySQL Error ERROR 1064 (42000) - moodle installation

    Hi Thank you for the response, sir. Now, I see why. I was following the tutorial in the moodle site.

    Thank you!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •