partTimeRunner Posted June 19, 2014 Share Posted June 19, 2014 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 More sharing options...
justsomeguy Posted June 19, 2014 Share Posted June 19, 2014 If there are no databases then I would just uninstall MySQL and reinstall it, then set it up the way you want it. Link to comment Share on other sites More sharing options...
partTimeRunner Posted June 27, 2014 Author Share Posted June 27, 2014 Okay. I was going to do that as a last resort. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now