Hey guys I am having the error every time i try to initialize the database and load the seed data? Plz help

Hey guys I am having the error every time i try to initialize the database and load the seed data? Plz help



Initializing database.database setting.
LVL 1
NOC123Asked:
Who is Participating?
 
arnoldCommented:
It is not admin, because you are getting an access denied.

Query the MySQL.user tanker.

Note admin@localhost is a different account than admin@servername.
Even if both have the same username, admin, and the same password.
These are two separate accounts with different rights.

In MySQL cli,
Cli are you local to the system on which MySQL is installed?
0
 
arnoldCommented:
MySQL or mssql?

Posting images .... Is limited.

You get an access denied, what user and what rights does the user have?

Text information is more useful.

What are you using? GUI tool? Which?
0
 
NOC123Author Commented:
I am using mysql. The user is admin. Right now i am using cli.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
NOC123Author Commented:
Thank you very much man for pointing me toward's the right direction.  I uninstalled sql and reinstalled. Then i created the database in the there. But that didn't work. Bc the file I was running was basically creating the database. Eventually I changed the username to @local. That did create the databases but i was still getting sql error 12. Eventually i changed the user to root.  Which is sql default. And boom it worked.

Thank's again.
0
 
NOC123Author Commented:
Pointed me toward the right direction.

Thank you.
0
 
arnoldCommented:
FYI, you can use whatever username and from wherever you need, but make sure the rights granted to the user@location are correct for the tasks you want to allow the account to perform.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.