Jump to content

How do I create an account on mySQL without being logged in?


partTimeRunner
 Share

Recommended Posts

A few weeks ago I was given admin control of a Windows server. On it mySQL was already installed with no user accounts and databases set up. I have tried logging in as root, localhost, ect but any default account has been stripped of privileges.

 

For example I get an error message reading: “Access denied for user ‘root’@’localhost’ (using password NO)”.

 

This was done probably for security purposes. Either way I need to be able to set up an account so that I can make my database. My question – is it possible to create an account or give root the rights required to log into mySQL without already being logged in? The person who gave the server to me said that I would not need an account in order to make the database. This confuses me because with the limited experience I have had with mySQL I have had to been logged in to make any kind of change.

 

What do you guys suggest?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...