Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

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.
0
NOC123
Asked:
NOC123
  • 3
  • 3
1 Solution
 
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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now