Hmm looks like I need to GRANT myself additional permissions

Question

Hmm looks like I need to GRANT myself additional permissions sorry for the noise

DG · Answer

Connect to MySQL ```$ mysql u root p``` When prompted enter in the temporary password from ` var log mysqld log` Change root password in this case we will use `toor Fl33t` as default password validation requires a more complex password For MySQL 5 7 6 and newer use the following command ```mysql gt ALTER USER root localhost IDENTIFIED BY toor Fl33t ``` For MySQL 5 7 5 and older use ```mysql gt SET PASSWORD FOR root localhost = PASSWORD toor Fl33t ``` Now issue the command ```mysql gt flush privileges ```

DG · Answer

Though i think your problem is your not use your root user

DG · Answer

and your normal user as you said is not granted the rights which you probably need to do UNDER the root user

DG · Answer

Also im still a newbie at this stuff so I am answering what i feel is right even though only setting this up 2 weeks ago